I'm not sure how you are changing the shape. Also, how do I design the report to get fields a, b and c on page 1, fields d, e and f on Page 2, and then going to the next set of rows in the next two pages?
Thank you! Kayza Kleinman Director of the Nonprofit Helpdesk CIO Jewish Community Council of Greater Coney Island, Inc www.jccgci.org www.nphd.org -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, March 09, 2016 8:24 AM To: Kayza Kleinman Subject: [RBASE-L] - Re: Need a two page report At 12:39 AM 3/9/2016, Kayza Kleinman wrote: >Thanks. > >My problem is not the background. I was basically using the technique >you just described for me. It's not a color, it's a grid and the grid >for page one is different for page two. > >The idea is something like this: > >Page one - background = Grid1 >Row 1 - col a | col b | col c >Row 2 - col a | col b | col c > >Page two - background = Grid2 >Row 1 - col d | col e | col f >Row 2 - col d | col e | col f > >Page 3 - background = Grid1 >Row 3 - col a | col b | col c >Row 4 - col a | col b | col c > >Page 4 - background = Grid2 >Row 3 - col d | col e | col f >Row 4 - col d | col e | col f > >Can I do something like this in one run? Yes, you can! Place a shape control on a [Detail] band and dynamically change the Shape properties, as you see fit. Take a look at the sample "ZebraStyleReport" included with RRBYW18 & RRBYW19 sample databases. Keeping that technique in mind, and knowing the Report Page Number, you can change the color of Grid1 for Page One, Grid2 for Page 2, Grid1 for Page 3, and Grid2 for Page 4 and so on. Very Best R:egards, Razzak >-----Original Message----- >From: [email protected] [mailto:[email protected]] On Behalf Of A. >Razzak Memon >Sent: Friday, March 04, 2016 1:11 AM >To: Kayza Kleinman >Subject: [RBASE-L] - Re: Need a two page report > >At 11:08 PM 3/3/2016, Kayza Kleinman wrote: > > >We have a report that we need to run on a regular basis that has > >about > >5 rows per page. > >However, each row stretches across the width of 2 pages, and each > >page needs to have its specific background on it. > > > >Does anyone have any idea how I can do this without running two > >reports? Right now I have a routine that prints all of Page 1 then > >all of Page 2 and someone then needs to physically interleave all the > >pages. That's not a viable path though. > > >Kayza, > >Here's how ... > >01. While in Report Designer, place a "Page Style" band on your report > > Report Designer | Main Menu | Report | Page Style > >02. Stretch the Page Style band as the same size of the desired page > >03. Place a "Shape" object on the Page Style band and enable the Parent >Height and > Parent Width > > Standard Controls | Shape > > Right-click on the Shape object and then click on Parent Height > Right-click on the Shape object and then click on Parent Width > >04. Assign a Component ID to "Shape" object, such as "cidShape" > > Right-click on the Shape object and click on Component ID ... > > Value: cidShape > >05. Use the sample code below as "On Before Generate Custom EEP..." >for Page Style > band > > Right-click on Page Style Band and click on On Before Generate > Custom EEP... > > -- Example > -- Page Style On Before Generate EEP > -- Set Page Colors for Page 1 and Page 2 > SET VAR vPageNumber TEXT = NULL > GETPROPERTY REPORT PAGENO 'vPageNumber' > SWITCH (.vPageNumber) > CASE '1' > PROPERTY cidShape BRUSH_COLOR 'YELLOW' > BREAK > CASE '2' > PROPERTY cidShape BRUSH_COLOR 'NAVY' > BREAK > DEFAULT > PROPERTY cidShape BRUSH_COLOR 'WHITE' > BREAK > ENDSW > CLEAR VARIABLES vPageNumber > RETURN > >That's all there is to it! > >Hope that provides you with some directions to accomplish your goal of >assigning specific background color for page 1 and page 2 of your report. > >Feel free to reach out to me with any questions. > >Very Best R:egards, > >Razzak
