One of my issues was to develop a report with a grouping column at the right like that:
a group on ProductCategory and ProductSubcategory
One of my issues was to develop a report with a grouping column at the right like that:
a group on ProductCategory and ProductSubcategory
As you know, Sql Server can link reports easily with parameters.
One of my processes required sending a multiple values parameter that consisted of a concatenation of all IDs of the main report’s query, to a subreport.
To construct a multiple values parameter, follow these steps:
Create a hidden parameter on the main report:
One of my requests was to describe SQL Server Reporting Services (SSRS) merging Cells.
As you may know, SQL server provides a simple way to merge cells vertically:
I was struggling to get the structure of a temporary table.
The idea was to pull out the temporary database information “tempdb.sys.columns” , then format them in order to display the outcome in a form of a SQL query.
There is no way to Move up and down datasets on the reports designer
(Even though there are up and down arrows that seem to allow such move)