DataSet panel (Report Data) in SSRS designer is gone
With a report (rdl) file selected in your solution, select View and then Report Data. It is a shortcut of Ctrl+Alt+D.
reporting-services
How to get rid of blank pages in PDF exported from SSRS
In BIDS or SSDT-BI, do the following: Click on Report > Report Properties > Layout tab (Page Setup tab in SSDT-BI) Make a note of the values for Page width, Left margin, Right margin Close and go back to the design surface In the Properties window, select Body Click the + symbol to expand the … Read more
SQL variable to hold list of integers
Table variable declare @listOfIDs table (id int); insert @listOfIDs(id) values(1),(2),(3); select * from TabA where TabA.ID in (select id from @listOfIDs) or declare @listOfIDs varchar(1000); SET @listOfIDs=”,1,2,3,”; –in this solution need put coma on begin and end select * from TabA where charindex(‘,’ + CAST(TabA.ID as nvarchar(20)) + ‘,’, @listOfIDs) > 0