Welcome to the Report Viewer SDK feedback portal. We’re happy you’re here! If you have feedback on how to improve the Report Viewer SDK, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

I'm using Angular SDK version 3.3.34

I'm trying to paste in SQL designer query that i developed in Microsoft SQL Server Management Studio, but editor recognize only 2 parameters @From and @To. I tried to add other variables manually, but this dont work and i got error:


Empty



Empty



Query:


SELECT

[dbo].[TransactionItem].[ID],

[dbo].[Company].[DisplayName] AS CompanyName,

[dbo].[Store].[DisplayName] AS StoreName,

[dbo].[Transaction].[TransactionDate] AS Date,

[dbo].[Item].[ShortDisplayName] AS ItemName,

[dbo].[Item].[Code] AS ItemCode,

[dbo].[ItemHierarchy1].[DisplayName] AS ItemHierarchy1Name,

[dbo].[ItemHierarchy2].[DisplayName] AS ItemHierarchy2Name,

[dbo].[ItemHierarchy3].[DisplayName] AS ItemHierarchy3Name,

[dbo].[ItemHierarchy4].[DisplayName] AS ItemHierarchy4Name,

[dbo].[ItemHierarchy5].[DisplayName] AS ItemHierarchy5Name,

[dbo].[ItemBrand].[DisplayName] AS BrandName,

[dbo].[Manufacture].[DisplayName] AS ManufactureName,

[dbo].[Partner].[DisplayName] AS PartnerName,

[dbo].[PartnerGroup].[DisplayName] AS PartnerGroupName,

[dbo].[TransactionItem].[Quantity] AS Quantity,

([dbo].[TransactionItem].[Price] - [dbo].[TransactionItem].[Discount]) AS PriceAfterDiscount,

([dbo].[TransactionItem].[Price] - [dbo].[TransactionItem].[Discount]) * [dbo].[TransactionItem].[Quantity] AS Amount

FROM [dbo].[TransactionItem]

INNER JOIN [dbo].[Transaction] ON [dbo].[TransactionItem].[TransactionID] = [dbo].[Transaction].[ID]

INNER JOIN [dbo].[Item] ON [dbo].[TransactionItem].[ItemID] = [dbo].[Item].[ID]

LEFT JOIN [dbo].[Location] ON [dbo].[Transaction].[LocationID] = [dbo].[Location].[ID]

LEFT JOIN [dbo].[Company] ON [dbo].[Location].[CompanyID] = [dbo].[Company].[ID]

LEFT JOIN [dbo].[Store] ON [dbo].[Location].[StoreID] = [dbo].[Store].[ID]

LEFT JOIN [dbo].[POS] ON [dbo].[Location].[PosID] = [dbo].[POS].[ID]

LEFT JOIN [dbo].[ItemHierarchy1] ON [dbo].[Item].[ItemHierarchy1ID] = [dbo].[ItemHierarchy1].[ID]

LEFT JOIN [dbo].[ItemHierarchy2] ON [dbo].[Item].[ItemHierarchy1ID] = [dbo].[ItemHierarchy1].[ID]

LEFT JOIN [dbo].[ItemHierarchy3] ON [dbo].[Item].[ItemHierarchy2ID] = [dbo].[ItemHierarchy2].[ID]

LEFT JOIN [dbo].[ItemHierarchy4] ON [dbo].[Item].[ItemHierarchy3ID] = [dbo].[ItemHierarchy3].[ID]

LEFT JOIN [dbo].[ItemHierarchy5] ON [dbo].[Item].[ItemHierarchy4ID] = [dbo].[ItemHierarchy4].[ID]

LEFT JOIN [dbo].[ItemBrand] ON [dbo].[ItemBrand].[ID] = [dbo].[Item].[ItemBrandID]

LEFT JOIN [dbo].[Manufacture] ON [dbo].[Manufacture].[ID] = [dbo].[Item].[ManufactureID]

LEFT JOIN [dbo].[Partner] ON [dbo].[Partner].[ID] = [dbo].[Transaction].[PartnerID]

LEFT JOIN [dbo].[PartnerGroup] ON [dbo].[PartnerGroup].[ID] = [dbo].[Transaction].[PartnerGroupID]

WHERE [dbo].[Transaction].[TransactionDate] >= IIF(IsNull(@From, '') = '', CAST('1970-1-1' AS datetime), CAST(@From AS datetime))

AND [dbo].[Transaction].[TransactionDate] <= IIF(IsNull(@To, '') = '', GETDATE(), CAST(@To AS datetime))

AND [dbo].[Company].[ID] = IIF(IsNull(@Company, '') = '', [dbo].[Company].[ID], @Company)

;