Re: FPD report help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Fred Taylor (ftaylor_at_mvps.org!REMOVE)
Date: 02/05/05 

Date: Sat, 5 Feb 2005 12:00:42 -0700

You could add the totals by adding a an additional record at the end with
the totals in it. Put it all in a cursor using a SELECT * FROM yourtable
INTO CURSOR yourcursor and then doing an INSERT INTO yourcursor (somefields)
VALUES (somevalues)

As far as the headers go, I don't think you can get there from here very
easily in FPD. VFP it would be a piece of cake via automation. 

-- 
Fred
Microsoft Visual FoxPro MVP
"Dan_Musicant" <man@privacy.net> wrote in message 
news:0d1a01po12mt7e013knn6humjp4339g57c@4ax.com...
> My client runs a mature many-featured FPD application and I've been
> asked to modify a couple of the PRG-generated reports. These reports use
> ?, no FRX involved, and are powered by cursors for the data. The reports
> have numerous options driven by selector windows. Once the selections
> are made, the user picks between Screen and Printer. I'm being asked to
> include an option to create an Excel spreadsheet. I did something like
> this for them a couple years ago. It was a bunch of work, but I came up
> with a satisfactory solution. I thought I'd ask here before really
> getting into this.
>
> The printed version supports some stuff that I don't know how I'd
> support in a spreadsheet. I mean, I can do a COPY TO FILE (lcFilename)
> TYPE XLS, and if my fieldnames are sufficiently descriptive, it might be
> satisfactory. But it would be nice if I could include nice things like a
> page heading and a total line at the end. Is that stuff possible without
> some weird kludge?

Relevant Pages

  • Re: Need help with form
    ... We will be entering the data by cost center, then by expense element. ... all of the user's tables into one common table, run queries and reports. ... I have made a totals query from the main input table and grouped by the cost ...
    (microsoft.public.access.formscoding)
  • Re: Reports Sum over groups
    ... file and reports from our "server" PC. ... was trying to install was older than the current update already on the PC. ... These reports have multiple sorts and groupings. ... it is calculating totals just fine. ...
    (microsoft.public.access.reports)
  • Re: Big Problem, cant get sheet to calc correctly
    ... Take the quotes out of your formulas where they enclose *real* numbers. ... it reports a 70 if someone takes 34 hours off in a row, ... B is used to make Column D report a 70 or a calculation. ... worked and show the totals and, the total hours subtracted from 70 is hours ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Reports Sum over groups
    ... file and reports from our "server" PC. ... These reports have multiple sorts and groupings. ... it is calculating totals just fine. ...
    (microsoft.public.access.reports)
  • Re: Help on creating this report
    ... The easiest way to do complicated reports is to pre-process the data exactly ... To parse out the names in the Recip column I'd use the GetWordNum ... second name to the cursor of the first name. ... and the B, C, D columns for Nancy. ...
    (microsoft.public.fox.vfp.reports.printing)