At 01:23 PM 3/9/2016, Kayza Kleinman wrote:
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,
My hectic schedule and time permitting, let me prepare a quick sample
report (based upon your data, if I understand it correctly) to illustrate
the feature of conditionally changing the properties of Shape control
that is related to specific Page Number and Row Count.
Looking at your layout/presentation below, it seems that you may need to
add column(s) for the Report Break(s) to identify the group of rows to be
used in Grid on a given Page Number.
It also seems that the Grid1 and Grid2 always include designated columns
but different rows on alternative pages.
Very interesting concept.
Very Best R:egards,
Razzak
-----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
