Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Subreport and pdf Expand / Collapse
Author
Message
Posted Monday, September 30, 2013 11:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:07 PM
Points: 169, Visits: 506
Is there a way to view the report and the subreport as a pdf?

My report works fine in SSRS and when clicked on the parameter on the main report , opens the subreport too. However , When I export it to pdf, the subreport functionality doesn't work.


Any idea how can I implement this?
Post #1500144
Posted Monday, September 30, 2013 12:44 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 1,653, Visits: 5,205
Can you give some idea of the layout of the report and sub-report?

MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1500163
    Posted Monday, September 30, 2013 12:48 PM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Today @ 6:45 AM
    Points: 1,653, Visits: 5,205
    Also, what version of SSRS specifically? This is in the 2008 section, but do you have R2?

    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1500164
    Posted Monday, September 30, 2013 2:03 PM
    SSC-Enthusiastic

    SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

    Group: General Forum Members
    Last Login: 2 days ago @ 2:07 PM
    Points: 169, Visits: 506
    Yes its 2008.
    Post #1500188
    Posted Monday, September 30, 2013 2:04 PM
    SSC-Enthusiastic

    SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

    Group: General Forum Members
    Last Login: 2 days ago @ 2:07 PM
    Points: 169, Visits: 506
    The main report has a Product Id # in a pivot format giving monthly data and the subreport has all the attributes of the Product.
    Post #1500189
    Posted Monday, September 30, 2013 2:41 PM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Today @ 6:45 AM
    Points: 1,653, Visits: 5,205
    ok, if you are on 2008 R2, you can use the RenderFormat function to determine whether the subreport is visible be default, so if exporting to pdf for example, you make the subreport visible.

    If you are not in 2008R2 but just plain 2008, then you can't.


    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1500197
    Posted Monday, September 30, 2013 3:24 PM
    SSC-Enthusiastic

    SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

    Group: General Forum Members
    Last Login: 2 days ago @ 2:07 PM
    Points: 169, Visits: 506
    Anything we can do in 2008?
    Post #1500207
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse