After designing the report and when the report is Previewed , you will notice DATA file getting created in the project folder of report .To know more about DATA file : DATAFILE (rdl.data) To delete dataset cache files : Prerequisite : Download BIDS Helper In BIDS / SSDT , goto Solution Explorer ( CTRL +…Details
Refer my post on TechNet Wiki – http://social.technet.microsoft.com/wiki/contents/articles/20587.ssrs-sorting.aspx
Try this MSDN SSRS forum discussion for clear explanation on how to remove space (because of no data) between bars in Column Chart .
In some cases , we might need copy of RDL file , say .,For example : you had completed developing your report and only alignment & formatting changes are pending and you don’t want your final version of the report to be disturbed because of these changes . Remember we do have the undo/redo option…Details
In SSRS , IIF evaluates both True and False part irrespective of condition imposed . Because of that , expressions using IIF will lead us to error in some cases . Two common scenarios where IIF causes problem : i. ) Divide by zero .ii ) Argument ‘Month’ is not a valid value . i…Details
In this article , let us see an example on how to SUM based on condition in SSRS tablix report . Consider below query is my report dataset :DECLARE @tmp TABLE (Code VARCHAR(10),Level1 INT,Level2 INT)INSERT @tmp SELECT ‘CHN’,5,10INSERT @tmp SELECT ‘KOL’,5,15INSERT @tmp SELECT ‘IND’,10,25INSERT @tmp SELECT ‘NY’,5,10INSERT @tmp SELECT ‘TX’,5,15INSERT @tmp SELECT ‘US’,10,25SELECT * FROM…Details
Refer my post on Technet Wiki ( for single character multi-valued parameter ) – http://social.technet.microsoft.com/wiki/contents/articles/17104.passing-comma-separated-values-ssrs-multivalued-parameter-as-input-to-the-stored-procedure.aspx