Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Span landscape report over two pages?
- Thread starter DVDGirl
- Start date
synapsevampire
Programmer
What does span it mean?
You can create two sections for each and conditionally suppress each as to whether the page number is divisible by 2.
So the first section has the first half of the page with a suppression (Right click the section, select format section->X 2 next to suppress) formula such as:
Remainder(pagenumber,2) <> 0
The second section would have the overflow with a suppression such as:
Remainder(pagenumber,2) = 0
-k
-k
You can create two sections for each and conditionally suppress each as to whether the page number is divisible by 2.
So the first section has the first half of the page with a suppression (Right click the section, select format section->X 2 next to suppress) formula such as:
Remainder(pagenumber,2) <> 0
The second section would have the overflow with a suppression such as:
Remainder(pagenumber,2) = 0
-k
-k
synapsevampire
Programmer
Ooops, had the suppression backwards:
So the first section has the first half of the page with a suppression (Right click the section, select format section->X 2 next to suppress) formula such as:
Remainder(pagenumber,2) = 0
The second section would have the overflow with a suppression such as:
Remainder(pagenumber,2) <> 0
-k
So the first section has the first half of the page with a suppression (Right click the section, select format section->X 2 next to suppress) formula such as:
Remainder(pagenumber,2) = 0
The second section would have the overflow with a suppression such as:
Remainder(pagenumber,2) <> 0
-k
- Thread starter
- #4
Hi K -
Thank you for your suggestion, however, still I can't get it to work. It may be because of how I have my report set up. I have four subreports in the page header for the first page. On the second page, I have an additional three subreports.
Basically, I have 7 subreports for each day of the week. I want the first page to display Monday through Thursday, and the second page to display Friday through Sunday. I want it this way, so the report can be printed on a duplex printer.
When I tried your solution, I created a section on the page header (Page Header b). When I didn't supress either section, I got the error message: The page size was not large enough to format the contents of an object in the report."
Please let me know if you have any other suggestions or questions. Thank you!
-DVD Girl
Thank you for your suggestion, however, still I can't get it to work. It may be because of how I have my report set up. I have four subreports in the page header for the first page. On the second page, I have an additional three subreports.
Basically, I have 7 subreports for each day of the week. I want the first page to display Monday through Thursday, and the second page to display Friday through Sunday. I want it this way, so the report can be printed on a duplex printer.
When I tried your solution, I created a section on the page header (Page Header b). When I didn't supress either section, I got the error message: The page size was not large enough to format the contents of an object in the report."
Please let me know if you have any other suggestions or questions. Thank you!
-DVD Girl
synapsevampire
Programmer
What do days have to do with spanning it over 2 pages?
Your environment is fairly complex, and no doubt very slow.
Generally subreports wouldn't be placed in a Page Header, so I fear that you may have a good deal of information you're not sharing.
It's still unclear in my mind, but it sounds like you should be grouping weekly, and have two sets of subreports within the weekly grouping with suppression based on the portion of the week.
-k
Your environment is fairly complex, and no doubt very slow.
Generally subreports wouldn't be placed in a Page Header, so I fear that you may have a good deal of information you're not sharing.
It's still unclear in my mind, but it sounds like you should be grouping weekly, and have two sets of subreports within the weekly grouping with suppression based on the portion of the week.
-k
- Thread starter
- #6
I am trying to create a weekly schedule. I am connecting to a database with a list of appointments. Each appointment is a record. In Subreport1, I query the database for a list of appoitnments on 7/28/03 (Monday.) Subreport1 is a table with all appointments descending. The data is formatted into a table in the subreport, 2.5" wide.
Each day thereafter is the same: each Subreport's data is queried differently according to the date.
The report needs to span over two pages, because it doesn't fit on one page. I had thought that I could design past the page margin, and the report would automatically "wrap" to another page like a cross-tab. Of course, that doesn't work.
Hopefully, my description makes the concept a little clearer. Sorry, I wasn't more exact earlier. I guess what I'm trying to accomplish is a lot harder than I thought...
Each day thereafter is the same: each Subreport's data is queried differently according to the date.
The report needs to span over two pages, because it doesn't fit on one page. I had thought that I could design past the page margin, and the report would automatically "wrap" to another page like a cross-tab. Of course, that doesn't work.
Hopefully, my description makes the concept a little clearer. Sorry, I wasn't more exact earlier. I guess what I'm trying to accomplish is a lot harder than I thought...
synapsevampire
Programmer
You may not need subreports at all, you can group by day, and group by week.
Please post example data and expected output, you may be overcomplicating this.
-k
Please post example data and expected output, you may be overcomplicating this.
-k
- Thread starter
- #8
I finally got it to work. I started all over from a blank report. I put the first group of subreports in the Report Header. I supressed Page Header and Details. I placed the second group of subreports in the Report Footer. I made a common Page Footer.
For some reason, when I was trying this solution earlier in the report I was messing around with, it just wouldn't come out. But when I started from scratch, it did. I'm beginning to notice that Crystal is buggy like that. Oh well.
In any case, I really appreciate all of your helpful suggestions, as it got me thinking of different ways to tackle the problem and eventually got me to a solution.
For some reason, when I was trying this solution earlier in the report I was messing around with, it just wouldn't come out. But when I started from scratch, it did. I'm beginning to notice that Crystal is buggy like that. Oh well.
In any case, I really appreciate all of your helpful suggestions, as it got me thinking of different ways to tackle the problem and eventually got me to a solution.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question