Weird SSRS issue - column not displaying data
-
Hello,
I have a report that I've been working on that is created from a Stored Procedure (sproc). The sproc is returning data in all columns and the data is validated. So I went to create an SSRS report on top of the sproc. However, for some reason, there are 2 columns in the SSRS report that are not displaying data even though it is shown in the output of the sproc in SSMS and in the Query Designer of SSRS. (See screen shot below). As I've just started the SSRS report, I've not done anything as far as customizing anything other than the Parameters (setting their Available Values and Default values). I'm using the same parameter values when running the sproc in SSMS and the SSRS Query Designer. So I'm not sure why in these 2 columns I'm not seeing the data? Any help would be greatly appreciated!
TIA!
-
First place to start, can you confirm that you set a value in the tablix cells? A screenshot of the tablix in design mode would be helpful. Make sure you have a cell selected so we can see the row and column handles.
There are also two rows in the SP result that do not have data for the columns. Any chance those are the ones you're seeing in the report?
Wes
(A solid design is always preferable to a creative workaround) - And sometimes SSRS just goes weird - seems to mostly happen when data needs to be refreshed. And then there are several ways to force that as well so it's kind of a pain.
Have you tried going back over to design view and refreshing from there?Sue
-
Thanks for the replies! Turns out that the reason was I was using Multi-valued parameters and I just "assumed" that when flagging that checkbox that it told the Report to pass in ALL the values selected. So user friendly - NOT lol
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply