Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crosstab report - formulas
You could Export the report data to FoxPro, Excel, Access etc., add columns (fields) for your calculations, massage your data, and then use this new file to create your crosstab in Crystal. There may be an easier/better way to do this but it may still help you.- Bowne
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Passing a parameter value to a select record
I also use STARTSWITH. I define my param with a MAX and MIN LENGTH of 1 character and pull all records that start with that char (from a char field, length of 9) without a problem.- Bowne
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
CALC MIN(VAL)...FOR... I need to speed this process up
The code below works but I would like to speed it up. Any ideas? Table1 has 1.1 million records. Table2 was created using: SELECT COUNT(*), * FROM table1...GROUP BY address, zip and has 53k records. findaddr = "" findzip = "" lowest = 0 use table1 in 0 use table2 in 0...- Bowne
- Thread
- Replies: 5
- Forum: Microsoft: FoxPro
