Hide Subreport when no data found

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)

Hide Subreport when no data found

Author

Topic

adeelkarimkhan
Starting Member

1 Post

Posted - 2010-01-22 : 07:54:08

Hi.. i am facing an issue while working with subreports in reporting services... when there is no data ion subreport i need to just show the columns of select query.. but its not showing any data..

one more thing i tried is union of actual query with dummy data query. but issue is that when data is returned by actual qyery dummy data also gets visbile.. please suggest the solution...

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2010-01-22 : 12:20:39

make the actual dummy data blank


SELECT ChickenLeg
FROM ChickenCoop
UNION
SELECT '' AS ChickenLeg

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2010-01-22 : 12:57:10

And then filter the selected text box to omit blank records(where ChickenLeg <> ''

John
It's a small world (but I wouldn't want to paint it)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-01-23 : 07:37:35

you may use the union query and then apply an expression for hidden property of report to show detail based on countrows() function applied on dataset to see if dataset has any valid data or not

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources