data not displaying in the report
when i preview that report but the fields are displaying connection settings are no issues.what are possibilities to get this type of errors whether any parameters binding problem
February 6th, 2015 7:00pm

Hi ,

Kindly Check below Possibilities ;

  • Check that your dataset query return rows.
  • If you are using any Parmeter that Query is returning value or not.
  • Have report use any parameters, filters, or conditions to hide rows?
  • You should run sql profiler and review the query submitted to sql server by your report.

Thanks

Free Windows Admin Tool Kit Click here and download it now
February 8th, 2015 11:46am

Hi shimbu,

Per my understanding that the data of the field not display when you preview the report, right?

The issue can be caused by the data not refreshed and retrieved after some modification and also can caused by the parameters, Please reference to the details information below to help us better analysis about the issue:

  1. Did you got any error message or just see blank, Did you have large numbers of rows in the report?
  2. Did you use an stored procedure or use temp table? if so, please try not to use temp table. 
    As PrajapatiNeha mentioned that you can check to run the query in query designer to see if you can get the data display, please try to click the  "refresh fields".
  3. Right click the .rdl file and select the "View Code" to see if the datasource, dataset, field information exists correctly in it.
  4. You can also deploy the report to report server to see if the data will display.


In your scenario, I recommend you to recreate an same report to see if the problem still exists.

If you still have any problem, please feel free to ask.

Regards
Vic

February 9th, 2015 2:20am

Are you setting some default values for parameters? If yes check if valid data exists for parameter combination in the table.

See if any of the parameters are multivalued? If yes, your query should have the logic to parse the individual values out before doing the filtering 

Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 3:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics