Link to home
Start Free TrialLog in
Avatar of tulasisiva
tulasisiva

asked on

Display No Rows or No Data Found Message for the Matrix in SSRS

Display No Rows or No Data Found Message for the Matrix in SSRS
Question ; I wanted to show as  NO DATA FOUND  WHEN THERE  ARE NO ROWS OR DATA FOUND  in   a  matrix....   I have used the below expression , but it throws me an error.. 
 
=IIF (CountRows(  "DS_SP_Industry_Classification_Invoices_Received_Month_Wise_Last_Year"))=0, True,False)
 
 
Please Correct the above expression and provide me the Solution .....

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of carlosalbertoxp
carlosalbertoxp

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tulasisiva
tulasisiva

ASKER

I am binding the Stored procedure (Dataset) to the Tablix, Is it Possible that not particular field ...If my SP or DataSet returns nothing , can i show that No Data Available....

Above, you are mentioning the field associated with the dataset ,, Is it possible to show the dataset on it own return nothing....
Good