Hidden but visable on export?

Question

Hidden but visable on export?

TroyG

SSCrazy

Points: 2633
More actions
December 13, 2005 at 7:59 pm

#166260

Hi,
Not sure if this is possible - working with VS2k5 and RS2k5 - have a report which has hidden items which are toggled to allow expanding/drilling through the data.
This is working fine for the report when viewing it, however when scheduling it to be emailed the report is send as everything being hidden - whereas to get all the value out of the report it needs to be received in an expanded form.
Is this possible?
Thanks in advance for your help
Regards
Troy

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

mvee Hall of Fame Points: 3634 More actions · Answer 1

I might be misunderstanding what you are trying to do, and I'm no expert, but I do know that there is an option to set the toggle as expanded by default. Then the report would probably be sent with everything expanded. There might be a way to set this when calling the report, I'm not sure.

Then again, you probably don't want everything expanded by default...

Syed Asim Rizvi Ten Centuries Points: 1112 More actions · Answer 2

There is one possible solution for this is by using by your report scheduled time in expression of Hidden property.

Lets say, you scheduled your report to run at 12:00, so your expression will look like:

“=iif( InStr((Globals!ExecutionTime), "12:00"),False,True)”

This will expend the hidden rows only at the schedule time, and will hide all the other time.

HTH

TroyG SSCrazy Points: 2633 More actions · Answer 3

Thanks everyone for the responses - quite inventive I have to say - although sadly the report will be subscribed to at varying times...having the visibility flag permanently set to false sort of defeats the point of having it, but none-the-less still an option.

I suppose by the sounds of things there really isn't any way around this which is probably why the email has the http link in it....but then the same problem is raised with the dumping to unc path also *groan*

Oh well, if anyone else has any ideas or thoughts on this, please feel free to post up...

Thanks again for the posts!!

ofir shoval Ten Centuries Points: 1278 More actions · Answer 4

Well u can make 2 reports same,just different by the visibility.

The 1 that is all visible for email and the other 4 the users.

But of course if u have a lot of reports 2 do so,it isn;t good solution....

Dave Klug SSCertifiable Points: 5811 More actions · Answer 5

You can create a parameter, such as Expand All, and then check this value as to whether the toggle items should be expanded or collapsed when the report generates.

I use theis technique on all reports where toggling is involved to prevent the user from having to manually expanding hundreds of pages before exporting.

TroyG SSCrazy Points: 2633 More actions · Answer 6

Brilliant - great idea David....thanks for the response and the idea.