Error: Sub report Could not be shown

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Error: Sub report Could not be shown

Author

Topic

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2012-08-01 : 07:08:05

Hi,

I have a main report report1 and sub report report2.

Report2: Sub report
It has a dataset D2 and report requires a parameter P2 to run. P2 available values are populated from D2.

Report1: main report

It has a dataset D1 and it returns a value(res) 'A,B,C,D'.
It calls the sub report Report2 with the parameter value =Split(fields!res,",")

When the report is run I am getting the error as
"An error occurred while executing the subreport ‘report1’: One or more parameters required to run the report have not been specified."

Kindly help me out please.

Thanks,
Sandesh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-01 : 09:52:16

it means the parameter P2 is not able to get proper value from report 1

make sure D2 gives expected values correctly and also you're passing parameter value correctly from report 1 to report 2 in subreport properties

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2012-08-01 : 10:15:27

Hi Visakh,
I checked the parameter values they are fine.
However, If I make the available values for parameter p1 in sub reports to non query. Then the report is executing successfully.
But I am not supposed to change the available values of parameter P1 since report2 is also a main report

Thanks,
Sandesh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-01 : 11:14:42

that means the value passed from main report is not matching with available values for parameter of subreport which dataset d2 returns. you should analyse query for d2 and see why values doesnt match with those send for report1

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2012-08-02 : 03:08:50

Hi Visakh,

Yes that was the issue. the data was not matching there was additional - in between the data. So now its working. Thanks for the help.

Thanks,
Sandesh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-08-02 : 10:13:50

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources