Hi Telerik,
Please help me how to achieve this:
I have a stored procedure (MS SQL 2008) which is accepting some parameters and returns series of ids of for example invoices. I need to print every invoice on a new paper. I can create one report for one invoice, but I don't know, how to cycle throug the ids to print all invoices. Or may be, I can create one long for example MS Excell document containing a page breaks to print every inoivce on a new paper.
Thank you for any help.
Tom
Please help me how to achieve this:
I have a stored procedure (MS SQL 2008) which is accepting some parameters and returns series of ids of for example invoices. I need to print every invoice on a new paper. I can create one report for one invoice, but I don't know, how to cycle throug the ids to print all invoices. Or may be, I can create one long for example MS Excell document containing a page breaks to print every inoivce on a new paper.
Thank you for any help.
Tom
3 Answers, 1 is accepted
0
Hi Tom,
Check out the Invoice demo report that is shipped with the Telerik Reporting installation, which is pretty much what you require in your explanation. There is a Report Parameter that is used in a report filter to only show the data for the chosen Order# (ID in your case).
Review the demo report carefully and let us know if further help is needed.
All the best,
Steve
the Telerik team
Check out the Invoice demo report that is shipped with the Telerik Reporting installation, which is pretty much what you require in your explanation. There is a Report Parameter that is used in a report filter to only show the data for the chosen Order# (ID in your case).
Review the demo report carefully and let us know if further help is needed.
All the best,
Steve
the Telerik team
HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!
0
tomas
Top achievements
Rank 1
Rank 1
answered on 19 Oct 2012, 11:50 AM
Thank you very much.
MY problem is, that our users dont want to select and print one invoice after the other. Or I have missed something in your demo. (Which is really helpful for me)
Thank you very again.
Tom
MY problem is, that our users dont want to select and print one invoice after the other. Or I have missed something in your demo. (Which is really helpful for me)
Thank you very again.
Tom
0
Hello Tom,
In such case, you simply do not need to filter. Here are the steps you can take to make our Invoice work the way you need:
Regards,
Steve
the Telerik team
In such case, you simply do not need to filter. Here are the steps you can take to make our Invoice work the way you need:
- remove the report parameter
- remove the report filter
- remove the filter from the WHERE clause in the InvoicesDataSource query
- set PageBreak=After for the detail section
- (not mandatory) set the PrintOnEveryPage=True for the groupHeaderSection1.
Regards,
Steve
the Telerik team
HAPPY WITH TELERIK REPORTING? Do you feel that it is fantastic? Or easy to use? Or better than Crystal Reports? Tell the world, and help fellow developers! Write a short review about Telerik Reporting and Telerik Report Designer in Visual Studio Gallery today!