locked
SQL Server 2008: Reporting Service - Print a individual report for each item on a dataset. RRS feed

  • Question

  • Firstly thank's for you attention, again.
    I have a report to show a graphic of the purchase evolution to a provider. It have a parameter "@provider", it is a code by the provider on my database.
    I need to print one report for each provider from a sql server query, means, one provider by page on a single file (pdf, html, whatever)

    prov,proveedores,providers

    i was searching on previouses post, but i not find the answer,
    I hope that your can help me.
    Regards.


    • Edited by CM16 Thursday, March 1, 2018 11:02 AM error
    Wednesday, February 28, 2018 6:54 PM

All replies

  • Hi,

    You could make the return value of expression equals to the Parameter you selected on the page. Like:

    Parameters!your_para.Value

    BR

    Thursday, March 1, 2018 7:58 AM
  • Hi Henry, thank's for your response.
    I need that the only parameter (@proveedor) take the values automatically from my dataset "dsProveedores". The user of the report does not send parameters to show the reports.
    This dataset (dsProveedores), is the result of a query that shows the providers with transactions on the last month, using getdate(), then, the values changes constantly

    Thursday, March 1, 2018 10:56 AM