pamsauto
asked on
Need help with SQL reporting services report design
Can someone give me a pointer as how to get a report design that is for an invoice. It is being printed on a duplex printer. So I want the invoice information on the front and a static policy page on the back of each page. I did this in crystal reports, but it seems that you cannot use things like "if mod(pagenumber)=0 then static text is visable to fill a page for the back of the invoice.
Anyway, that is my issue at heart, page control.
Anyway, that is my issue at heart, page control.
Well i would like to add some thing here.
There is a global variable within each report, you can find one in menu that appears when you select formula (option menu - right click) of any text field. There under globals there are available PageNumber and TotalPages (or something like this) ... now what you can do is change the value option of the text field just that it is only visible on every odd page.
Other option would be to design the report in a way that you have a list control that always print on alternate pages.
Hope it make any sense ... i can hardly phrase it :(
Regards,
Rehan
There is a global variable within each report, you can find one in menu that appears when you select formula (option menu - right click) of any text field. There under globals there are available PageNumber and TotalPages (or something like this) ... now what you can do is change the value option of the text field just that it is only visible on every odd page.
Other option would be to design the report in a way that you have a list control that always print on alternate pages.
Hope it make any sense ... i can hardly phrase it :(
Regards,
Rehan
As long as the printer can automatically do duplexing, then you can achieve this with a List control. List controls are designed for Invoice style layouts.
The list control will be grouped on Invoice number so it repeats once per invoice, you can drag text boxes and layout free form within that, one of which can be your policy statement. You can also embed other data controls, for instance a table to show the invoice lines, make the list it's parent and link on invoice number.
Cheers
Chris
The list control will be grouped on Invoice number so it repeats once per invoice, you can drag text boxes and layout free form within that, one of which can be your policy statement. You can also embed other data controls, for instance a table to show the invoice lines, make the list it's parent and link on invoice number.
Cheers
Chris
ASKER
Chris-
Can you explain a little more to me. I am new to MS Reporting and this is my first rodeo on this stuff. I under stand list boxes and I see the grouping and parent things you are talking about. I currently have a main report that is the invoice key data and a subreport that is the detail data for an invoice. This report only does one invoice per time when it is run.
Thanks in advance.
Can you explain a little more to me. I am new to MS Reporting and this is my first rodeo on this stuff. I under stand list boxes and I see the grouping and parent things you are talking about. I currently have a main report that is the invoice key data and a subreport that is the detail data for an invoice. This report only does one invoice per time when it is run.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There may be a 3rd party extension written?
We handle this by having pre-printed paper loaded into the printer prior to printing :(