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.
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>
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
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]
