Refer SSRS Table cell value
The report elements can be accessed by using the ReportItem keyword in SSRS.
Refer SSRS Table cell value was last modified: March 15th, 2018 by
Getting next monday to next sunday parameters value
Use the following query to obtain the next monday to sunday dates.
select dateadd(week, datediff(week, 0, getdate()), 7) as NextMonday, dateadd(week, datediff(week, 0, getdate()), 13) as Nextsunday
Getting next monday to next sunday parameters value in sql server was last modified: January 26th, 2018 by
Select Listagg(columnname) within group (order by 1) as Col1
Use the PL/SQL Code to show multiple row output in one row separated by comma.
Converting SQL output Rows in to single row output separated by comma in Oracle was last modified: January 10th, 2018 by
Repeat header on each page SSRS
Enable the Advance mode in the grouping of the SSRS Report.
Select Static and Press F4
set the property repeat on new page to True.
Repeat header on each page SSRS was last modified: December 6th, 2017 by
Interactive Sorting in SSRS
Right click on the Table header of the Report and choose Text Box Properties
2. Choose Interactive sorting and Enable it .
Interactive Sorting in SSRS was last modified: December 6th, 2017 by
item ‘.rdl’ cannot found (rsitemnotfound)
ISSUE : Even when the RDL URL is correct the report is not identified in the Report Manager
Solution: Remove the .rdl at the end of the URL should fetch the report.
the item ‘.rdl’ cannot be found. (rsitemnotfound) was last modified: November 29th, 2017 by
Get Month First day PLSQL SSRS Report
Getting the first day of the Month in PLSQL of SSRS is little different and the syntax is as follows.
=DateSerial(Year(Date.Now), Month(Date.Now), 1)
Get First day of a Month in PLSQL SSRS Report was last modified: November 21st, 2017 by