Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Is SSRS (2008) a good choice for table partitioning export to pdf?

Answered Is SSRS (2008) a good choice for table partitioning export to pdf?

  • Tuesday, January 29, 2013 5:48 AM
     
     
    Sign In to Vote
    0

    Scenario: two column table looks likes this:

    1   a

    1   c

    1   d

    3   f

    4   g

    4   k

    Want to create 3 pdf files ( 1.pdf, 3.pdf, 4.pdf based on first column value) where, for example, 1.pdf contains

    1  a

    1  c

    1  d

    That is all records where the first column is 1 (as in 1.pdf).  Similarly 3.pdf will contain one record and 4.pdf will have 2 records.

    Can SSRS does this task or am I going about it wrong?

    TIA,

    edm2


    • Edited by edm2 Tuesday, January 29, 2013 5:50 AM
    •  
     

All Replies

  • Tuesday, January 29, 2013 6:03 AM
     
     
    Sign In to Vote
    0
    It is possible , you need to add a list control and group by id ... Sorry, cannot test it right now.

    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Blog: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance

     
  • Wednesday, January 30, 2013 2:06 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hello,

    Thanks for your post.
    You can try to create a Data Driven subscription and export the reports to three different PDF file based on the parameter value, for example, column1 in the table.
    (Note: The Evaluation, Developer, or Enterprise edition of SQL Server is required for Data Driven subscription.)
    Please refer to the following steps:
       1. Create a report with a parameter “column1”. The available values of the parameter are retrieved distinct values from the column1 in table.
       2.  Deploy the report to Report Server and specify the data source connection with stored credentials.
       3. Create a sample a subscriber database and create a table to store the subscription data. For example, you can create a table with three columns: filename, format and parameter.
       4. Create a Data Driver subscription. In delivery options page, specify the “File name” and “Render Format” with the values in the table created above and specify the parameter values with “parameter”.
    For more details steps, please refer to the tutorial:
    Creating a Data-Driven Subscription

    Regards,
    Fanny Liu

    If you have any feedback on our support, please click here .

    Fanny Liu
    TechNet Community Support