| Author |
Topic |
|
dbnewbie
Starting Member
1 Post |
 Posted - 2010-09-13 : 09:54:34
|
| Hello,I have a report that I change (add a field and deleted 3 fields). I ran the changed store proc successfully in Management Studio. I ran that same store proc in VSS (where I build the report) in the Data area and I did not get any error - but I did not see the data at all.I refreshed the Dataset even log out and log in of VSS - just in case. Same, no show of data.Help.Thanks |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2010-09-14 : 11:40:20
|
| do you see data in the data tab in SSRS? is it pointing to the correct server? |
 |
|
|
suyogkandi
Starting Member
4 Posts |
Posted - 2012-04-30 : 11:08:42
|
| I am also having same problem. I double checked data is displaying in Datatab but in preview I am not seeing data. I checked all the properties. What would be the reason ?Early response will be appericited. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-30 : 11:20:45
|
quote:
Originally posted by dbnewbie
Hello,I have a report that I change (add a field and deleted 3 fields). I ran the changed store proc successfully in Management Studio. I ran that same store proc in VSS (where I build the report) in the Data area and I did not get any error - but I did not see the data at all.I refreshed the Dataset even log out and log in of VSS - just in case. Same, no show of data.Help.Thanks
you mean procedure not even showing data in datatab?are you sure you're passing same set of parameters?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-30 : 11:21:16
|
quote:
Originally posted by suyogkandi
I am also having same problem. I double checked data is displaying in Datatab but in preview I am not seeing data. I checked all the properties. What would be the reason ?Early response will be appericited.
do you've any internal filters or additional parameters set in report?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
suyogkandi
Starting Member
4 Posts |
Posted - 2012-05-01 : 06:45:57
|
| I do not have any prarmeter or filter on the table or dataset. I tried to create new dataset and new table but it is not working.I used same dataset query and developed seperate report and it is working there. But I have another retangles on this old report and I want when user want to export into excel it should show all data in seperate tabs. So I want this report should display data in same old report in a seperate retangle. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-01 : 09:58:46
|
quote:
Originally posted by suyogkandi
I do not have any prarmeter or filter on the table or dataset. I tried to create new dataset and new table but it is not working.I used same dataset query and developed seperate report and it is working there. But I have another retangles on this old report and I want when user want to export into excel it should show all data in seperate tabs. So I want this report should display data in same old report in a seperate retangle.
does old report has some report level filters which is preveting data from getting displayed? May be you dont have data which satisfies the filter conditions in this dataset------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
suyogkandi
Starting Member
4 Posts |
Posted - 2012-05-02 : 04:36:10
|
| I do not have any filter any where except in query. Same report worked when I used subreports in place of retangle. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-02 : 19:53:38
|
quote:
Originally posted by suyogkandi
I do not have any filter any where except in query. Same report worked when I used subreports in place of retangle.
is there some expression set for hidden property of rectangles?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
suyogkandi
Starting Member
4 Posts |
Posted - 2012-05-03 : 04:33:54
|
| I have not set any thing. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-03 : 16:10:32
|
| you either have some hidden property set for any of nested containers or you've some other container overlapping this causing it to hide the data. But without seeing report I cant determine what is exact reason!------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
SQL Basic
Starting Member
8 Posts |
Posted - 2012-05-30 : 23:01:27
|
| Even I have the same problem. My rows and column headers are showing up but not the report data rows. The Report is actually bound to a typed databaset which I preview actually returns rows, this dataaset is query based dataset with joins on 3 tables. The preview of dataset returns rows but the rows are displayed on Report. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-30 : 23:05:52
|
| is it parameter driven report?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
data not showing on SSRS Preview