We help IT Professionals succeed at work.

Reporting Services - How to maintain toggle item functionality when rendering to HTML

1,063 Views
Last Modified: 2012-05-08
Hi All,
I've developed a fairly straighforward report, which is rendered to HTML using the SSRS web service and then sent as the body of an email.
This works fine, however I'd like to implement the expand/collapse function on some tables and have this included in the generated HTML - ideally some Javascript to toggle the expansion, mimicking the functionality of the report viewer controls.
Is this possible? The information on MSDN is somewhat misleading, as it states that "If ToggleItem is set, the toggle image is displayed next to a toggle item. When the image is clicked, the report server refreshes the HTML to include the report item." (http://msdn.microsoft.com/en-us/library/aa178954%28SQL.80%29.aspx), it also states that "The show-and-hide toggle on report items is supported only by rendering extensions that support user interactivity, such as the HTML rendering extension." (http://msdn.microsoft.com/en-us/library/ms157454.aspx), but I can't seem to get it to work!
Does anyone have any suggestions? I've trawled the web but found nothing on this one!
Many thanks in advance,
S Armondi
Comment
Watch Question

Send it as an excel file?

Author

Commented:
Hi Auric1983,
Unfortunately that is not possible, as the rendered HTML is then used as part of the body of an email.
Thanks,
SAM
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.