[RBASE-L] - RE: Report help needed

[Javier Valencia]

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: rbase-l@rbase.com [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 F2      Jim   1     40   400  F2     Jim   2     40   400 F2      Jim   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