Geek Answers Handbook

Crystal Reports 11 - How to Print Different Data on Multiple Pages

I have a transportation shortcut that needs to be printed on a Dymo Label printer with slightly different data on each of the three pages. Can this be done with only one .rpt so that users only need to print one report, not three?

http://imgur.com/5UUl4

+4
source share
3 answers

It's been a while since I used Crystal Reports, but you can set your .RPT to three sections with detailed data (A / B / C), and B and C "print a new page before." Thus, each part will consist of three separate sections.

You do not need to do anything crazy with custom formulas. All you have to do is display each piece of data three times, one on each page, each page slightly different.

(Of course, you can use the header and simply put the changed data in the information section ... but it will take more time to simply repeat the required data in each data section.)

Confirmed

  • Open report
  • Right-click the Details section
  • Select "Insert Section Below"
  • Repeat steps 2 and 3 twice
  • Confirm that you see the three "Details" sections.
  • Use the Section Expert (or Visual Studio Properties) for sections A and B, and select New Page After. (If you are using Expert Expert, make sure you are on the Paging tab.)
  • Create the desired content in each detailed section.
  • You probably want to ban all other sections, including the headers and footers of the report / page.

. Detailed description of the RPT section

Report setup

Expert Section

Section expert

+2
source

You have two main methods.
You can use groups and use this option to start a new page for the group when it changes. Another option is to use subreports, but I would avoid this option. If you want me to clarify, please let me know.

0
source

If you can repeat your data three times, so each entry for your report is duplicated, you can do something with several sections of details (from the expert section, create three sections of information)

And then use "Supress (No Drill-Down)" with the formula to alternately show each version of the label depending on the record number. alt text

For each section of information, add a formula (using basic syntax)

  • formula = (Remainder(RecordNumber,3) <> 1)
  • formula = (Remainder(RecordNumber,3) <> 2)
  • formula = (Remainder(RecordNumber,3) <> 0)

Then create each slightly different mark on each of the part sections.

I managed to get three rows of data by doing a similar cross-connection (in SQL Server), assuming a table with data called ReportData p>

 ;with cte as ( select 1 as ver union select 2 as ver union select 3 as ver ) select * from cte cross join ReportData order by OrderNumber, ver;
0
source

More articles:


All Articles