Thanks for your help. If I have to end up going to create a view, it will be very difficult, the example I quoted was just a simple example. Actually there are 33 variables getting processed at different breakpoints in the report.
Any idea why the Detail section can be taken off the report, and still have all the variables associated with the detail section process correctly, but if I delete the footer for the breakpoint, the variables associated with that don't work?
Are there any other work arounds?
Dan
At 11:25 AM 2/1/2006, you wrote:
Dan,
Sorry - as soon as I sent it, I saw you're apparently using 6.5 (I didn't notice the list name.) You still should be able to shrink the size, but in 6.5, it can't be zero. The other option is to create a view that summarizes the data for you, then base the report off the view, printing the data as detail.
CREATE VIEW viewname AS SELECT techname, weeknum, (sum(hours)), (sum(pay)) FROM table WHERE whereclause GROUP BY techname, weeknum.
Hope it helps.
Dawn
From: Dawn Oakes
Sent: Wednesday, February 01, 2006 11:19 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Report help needed
Dan,
Have you tried just shrinking the size of F2? Right-click and make sure Dynamic Height is checked, then drag the bar up all the way to make it as small as it can go. If there are no fields in the band, you should have a height of zero.
Dawn
From: Dan Champion [ mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 01, 2006 10:53 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Report help needed
Hi,
I have a current report that has two breakpoints, Variables are set in the correct section, and everything is working correctly.
Now I would like to create a summary report that ends up with all the same totals, without the detail, Footer2 information. The first report though it has variables to lookup and calculate on does not need to display the detail section, so one was never used. However Footer1 and Footer2 is where I did all my display. The new report I thought would be a cinch, Just delete the footer 2 section, and everything would be great. Not so. If I remove it, none of the variables set up for F2 get calculated. If I put it back without the variables, It all works fine, but creates blank lines for every line that would be in that section... How do I surpress the blank lines. Examples below
Current Report (With weekly details)
RH title
PH Tech Week Hours Pay
F2Jim 1 40 400
F2 Jim 2 40 400
F2Jim 3 40 400
F2 Jim 4 40 400
------------------------------
F1 Jim 4 160 1600
(New Page per each tech described in breakpoint)
RF Totals
RF 6 techs 2400 24,000
New Report should be exactly the same except all the F2 details don't need to be shown.
RH title
PH Tech Week Hours Pay
------------------------------
F1 Jim 4 160 1600
(breakpoint has the page break turned off now)
F1 Dan 3 125 1300
F1 Rick 4 200 2700
RF
RF Totals
RF 6 techs 2400 24,000
Dan Champion
www.championsolutions.net
616-299-7420
Dan Champion
www.championsolutions.net
616-299-7420
