Dan,
I understand your plight! I have no idea why the
detail section can be taken off, but the footer can't. I
remember having that problem myself when using 6.5. I don't know if
I'm going to be much help. The only solution that I can come up with
(other than struggling through a view creation) without seeing everything,
is pretty laborious- it may not make sense for your
situation.
1. Leave the F2 section in your report, and set
the variables to NOT clear after the report prints (under report
settings)
2. Create a
command file where you first declare all your variables, then create a temp
table (or have a permanent table already created) with all the columns you need
(to correspond with the pk and all 33 variables)
2. Declare a cursor for the pk values. (To keep it
simple, let's assume it's tech number)
3. In your while loop, set your variables to zero,
then print one report for each pk value (ie. print reportname where technumber =
.vcursorvariable. (You can print the report to the screen or the printer.
I don't think it will work if you print it to file - but try it - it'll
save paper and time!)
4. You can then insert into your table the pk
and the value of all 33 variables (because they're not
cleared).
5. As
you fetch the cursor variables and print the reports the table will get
populated with your summary information. You can then base your summary report
on the new table.
You
can see that doing this would take a lot of paper and/or a lot of user input,
depending on the number of reports. If you're printing to the screen,
someone has to close the screen preview before the rest of the commands will
run. If you can get it to work printing it to file, that's your best
bet. I vaguely remember trying it, but having no luck. A permanent
table would make more sense than a temp table if you're bound to run the report
more than once for the same criteria.
You know...7.5 is soooo much better! It may
be better to say No! I can't do that unless we upgrade. (Or, I can,
but it'll take xx hours). Your call
obviously.
From: Dan Champion [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 01, 2006 1:32 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Report help needed
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
