Crystal MTD YTD Daily Report- as one PDF file
Posted on 2010-09-14
I am trying to mimic an existing excel report that has 3 tabs (Daily, MTD & YTD). All three tabs are similar but have different values based on report types MTD, Daily and YTD. I have to recreate this report in Crystal with PDF as output format. I told the user that we can’t do multi tab reports in Crystal to PDF. So, they asked me to do one below the other
i.e; PDF Page1: Daily, ; PDF Page2: MTD, ; PDF Page3: YTD
Crystal gets the data from a strored proc refcursor. The refcursor has all there (Daily, MTD, YTD) data. How to do this in Crystal?
I tried creating a report with Report Type (Daily, MTD, YTD) as user prompt and all column formulae based on the user prompt. The report is complex and has 2 summary sub reports. But the user didn’t like it because they need to run the report three times to get all three report types: Daily, MTD & YTD). They asked me to create one single report without asking for the report type (i.e Daily, MTD & YTD) prompt. It makes sense because the refcursor returns all necessary columns for three report types. By generating three different reports, we are hitting the database 3 times.
To be short, I want to create a report using a refcursor. But the report should have 3 different headers (Daily, MTD, YTD) and proper page breaks should be created after each report type and I also need to create sub-reports at each report type to show summary information.