In my original posting, I describe removing the footer section, but the problem is, when you remove it, and of course all the objects within, the calculation that happens during that breakpoint don't happen. Even though with the detail section removed, the detail variables DO calculate correctly. If I put the footer section back in, but don't put the objects back in, and decrease the size to the smallest possible (about half a space thick) it makes large areas in my final report that are blank, but the subsequent breaks and page footers have the correct values. Any ideas?
At 02:17 PM 02/01/2006, you wrote:
Dan and Dawn:
The Report footer (or any section) can indeed be taken off in 6.5++. Just click on the line at the bottom of the desired section and the green line will turn into a red dashed line; press the DEL key on the keyboard and you will be prompted if you want to delete the section and all objects within, click Yes and the section and all object within will be gone.
And, as R:azzak always says, thatÂ’s all there is to it.
Javier,
Javier Valencia, PE
President
Valencia Technology Group, L.L.C.
14315 S. Twilight Ln, Suite #14
Olathe, Kansas 66062-4578
Office (913)829-0888
Fax (913)649-2904
Cell (913)915-3137
================================================
Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the sender and
delete the material from all system and destroy all copies.
======================================================
-----Original Message-----
From: [email protected] [ mailto:[email protected]]On Behalf Of Dawn Oakes
Sent: Wednesday, February 01, 2006 3:56 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Report help needed
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
Dawn,
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
