dotnet Report Local...
 
Notifications
Clear all

dotnet Report Local Service Installation

6 Posts
2 Users
0 Likes
163 Views
Mahmoud Sayed
Posts: 3
Topic starter
(@mahmoud-sayed)
Active Member
Joined: 2 months ago

Hi,

 

The query use 2 tables one for master and the other for detail. I make the detail fields as “Only in Detail” option

The detailed query didn’t return the detail table on it so it return this error. ”LegalAccountantLicenseRenews” not exist in “From” section

 

kindly create a meeting schedule to illustrate it.

 

image
5 Replies
Dotnet Report
Posts: 28
Admin
(@admin)
Member
Joined: 10 months ago
Ok, so this is a setup issue, basically you need to setup "Joins" to make this work. Please see this kb article:
 
 
Once you setup the join correctly, this should work. 
 
Thanks
 
dotnet Report Team
 
Reply
Mahmoud Sayed
Posts: 3
Topic starter
(@mahmoud-sayed)
Active Member
Joined: 2 months ago

Hi again,

The issue now is the generated query has Arabic chars ‘Nvarchar’, so it make a problem in where clause, it should converted to nvarchar.

<image001.jpg>

<image007.jpg>

Reply
Dotnet Report
Posts: 28
Admin
(@admin)
Member
Joined: 10 months ago

Ok good, more progress 🙂

Can you send me a sql query that does work, and I will check on what to fix to make it work.

Thanks

dotnet Report Team

 

Reply
Mahmoud Sayed
Posts: 3
Topic starter
(@mahmoud-sayed)
Active Member
Joined: 2 months ago

 

NotWorking

Working

SELECT [AccountantLicenseView].[RequesterId] AS [RequesterId], [AccountantLicenseView].[FullName] AS [FullName], [AccountantLicenseView].[Email] AS [Email], [AccountantLicenseView].[LicenseNumber] AS [LicenseNumber], [AccountantLicenseView].[Gender] AS [Gender], [AccountantLicenseView].[Dob] AS [Dob], [AccountantLicenseView].[StartDate] AS [StartDate], [AccountantLicenseView].[EndDate] AS [EndDate], [LegalAccountantLicenseRenews].[EndDate] AS [EndDate], [LegalAccountantLicenseRenews].[StartDate] AS [StartDate]

FROM [AccountantLicenseView] WITH  (READUNCOMMITTED) 

INNER JOIN [LegalAccountantLicenseRenews] ON [AccountantLicenseView].[Id]=[LegalAccountantLicenseRenews].[RequesterId] 

 WHERE  ISNULL([AccountantLicenseView].[RequesterId], 0)='877' AND  ISNULL([AccountantLicenseView].[FullName], '')='عبدالعزيز بن صالح بن حمد الجاسر      ' AND  ISNULL([AccountantLicenseView].[Email], '')='saudigroup@hotmail.com                                                                                                                                ' AND  ISNULL([AccountantLicenseView].[LicenseNumber], '')='74' AND  ISNULL([AccountantLicenseView].[Gender], '')='M' AND  ISNULL([AccountantLicenseView].[Dob], '')='1980-12-30' AND  ISNULL(CONVERT(VARCHAR(20),[AccountantLicenseView].[StartDate], 101), '')='12/30/1980' AND  ISNULL(CONVERT(VARCHAR(20),[AccountantLicenseView].[EndDate], 101), '')='05/10/2009'

 

ORDER BY [AccountantLicenseView].[Email]

SELECT [AccountantLicenseView].[RequesterId] AS [RequesterId], [AccountantLicenseView].[FullName] AS [FullName], [AccountantLicenseView].[Email] AS [Email], [AccountantLicenseView].[LicenseNumber] AS [LicenseNumber], [AccountantLicenseView].[Gender] AS [Gender], [AccountantLicenseView].[Dob] AS [Dob], [AccountantLicenseView].[StartDate] AS [StartDate], [AccountantLicenseView].[EndDate] AS [EndDate], [LegalAccountantLicenseRenews].[EndDate] AS [EndDate], [LegalAccountantLicenseRenews].[StartDate] AS [StartDate]

FROM [AccountantLicenseView] WITH  (READUNCOMMITTED) 

INNER JOIN [LegalAccountantLicenseRenews] ON [AccountantLicenseView].[Id]=[LegalAccountantLicenseRenews].[RequesterId] 

 WHERE  ISNULL([AccountantLicenseView].[RequesterId], 0)='877' AND  ISNULL([AccountantLicenseView].[FullName], '')=N'عبدالعزيز بن صالح بن حمد الجاسر      ' AND  ISNULL([AccountantLicenseView].[Email], '')='saudigroup@hotmail.com                                                                                                                                ' AND  ISNULL([AccountantLicenseView].[LicenseNumber], '')='74' AND  ISNULL([AccountantLicenseView].[Gender], '')='M' AND  ISNULL([AccountantLicenseView].[Dob], '')='1980-12-30' AND  ISNULL(CONVERT(VARCHAR(20),[AccountantLicenseView].[StartDate], 101), '')='12/30/1980' AND  ISNULL(CONVERT(VARCHAR(20),[AccountantLicenseView].[EndDate], 101), '')='05/10/2009'

 

ORDER BY [AccountantLicenseView].[Email]

 

 

Reply
Page 1 / 2
Share: