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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. alhamil5

    Supress Pg Header After Last Record Read?

    Yes Syn, I actually have two subreports, each of which is in its own Report Footer section---they should only print AFTER all the detail records of the main report have printed. I put the 'suppressit' code where your post indicated - first = false in the Report Header, then = true in a section...
  2. alhamil5

    Supress Pg Header After Last Record Read?

    Syn - I spoke too soon! I did what you suggested but now the page header is just suppressed on EVERY page. Any ideas?
  3. alhamil5

    Supress Pg Header After Last Record Read?

    Thanks, Syn. You're so helpful to everyone with this stuff, maybe you should write a book. The Crystal books I have are all either way too simple ('here's how to run the Crystal wizards' type stuff) or way too esoteric ('here's how to embed a field in your underlaid chart and make its color...
  4. alhamil5

    Supress Pg Header After Last Record Read?

    I'm at wit's end with this...what 'suppress' formula should I enter in my page header so that the page header WILL print on any page where a detail record appears, but WILL NOT print on any pages that come after the final record in the detail section has printed? I don't want the page header...
  5. alhamil5

    Break Page on Data Change

    Solved my own problem - I selected the &quot;details&quot; section, checked the conditional formatting box for New Page After and for the formula, I entered this: Next ({rep# field}) <> {rep# field} Sometimes it's the most obvious solutions that elude me while I'm looking around for something...
  6. alhamil5

    Break Page on Data Change

    There are no &quot;groups&quot; in my report. All the relevant data is in the &quot;details&quot; section of the report. The data is coming in from a .csv flat file, in the same order as it is to appear in the report---this is necessary because the sorting requirements are unorthodox. The...
  7. alhamil5

    Break Page on Data Change

    In the source data for my report, records are grouped, i.e. all sales for sales rep #1 appear as individual rows, then all sales for rep #2, then rep #3, etc. The number of rows per rep will vary each time the report is run, so there could be 5pp of sales for rep #1, one page for rep #2, etc...
  8. alhamil5

    How to change Database of an Access based report

    If your report doesn't always get its data from the same source, I think you'd have to use an Active Data source when you first set up the report and then point to the desired data in your code. I recently finished an app that does this. Users of a certain program do a data dump out of that...
  9. alhamil5

    How To Force VB 6 App to Run On Server

    I've written a very small exe in VB 6 that opens a Crystal Report, exports the report to .pdf format and then saves it to a disk file. This executable is intended to be launched, run and closed from within another program, so in the production environment the only &quot;user&quot; of the...
  10. alhamil5

    Run-time Error '429' from VB6, CR8.5

    Synapse - thanks for your reply. When you say you suspect it's a problem with unregistered DLLs, do you mean unregistered on the Crystal Server machine? I would think that unregistered DLLs on the Crystal Server machine would cause the .exe to fail no matter where I launch it from, but that's...
  11. alhamil5

    Run-time Error '429' from VB6, CR8.5

    I've written a tiny VB6 standard .exe that calls a Crystal Reports version 8.5 report, exports it to .pdf format and saves it to a disk file. The .exe runs on the Crystal Server machine, there is no client-side code or client-side installation. When I launch it from a DOS prompt on my own, Win...
  12. alhamil5

    Page Header Not Repeating In Subreport

    I solved my own problem with a workaround - I copied the page header from my subreport into a second page header on my main report and then used conditional formatting to control printing so the second page header would only print on pages where the subreport is printing.
  13. alhamil5

    Page Header Not Repeating In Subreport

    The page header I've set up in my subreport only prints once, at the start of the subreport. It doesn't show up again after page breaks. How can I fix this so the page header of the subreport will repeat after each page break? Thanks in advance.
  14. alhamil5

    Strings Being Interpreted As Numbers At Runtime

    I solved my problem; I imported my .csv file into MS Access 2000, then exported it back out to .csv. Using the newly exported .csv, everything ran fine. Weird. The only difference I could see between the new export and my original .csv file was that the new export surrounded every field value...
  15. alhamil5

    Strings Being Interpreted As Numbers At Runtime

    Maybe this will help...here's an excerpt from my source data. If I delete the last row in this excerpt, the report runs fine and everything comes into the report as a string. But if I include the last row, any column that has more numbers than letters in it is interpreted as Number and text...
  16. alhamil5

    Strings Being Interpreted As Numbers At Runtime

    Thanks Kai, but it's not working. I used the word &quot;string&quot; to seed my first row, but it doesn't seem to make any difference. When I run the report without filtering out the seed row, nothing prints in columns that have predominantly numeric data, even in the seed row. Any other ideas?
  17. alhamil5

    Strings Being Interpreted As Numbers At Runtime

    At runtime, fields I have defined as type String in my .ttx file are being interpreted as type Number when the .csv source data file is opened and passed to Crystal. In the report designer, all the fields for my report are listed as type String, which is correct. But when I run the report, it...
  18. alhamil5

    can i use crystal to write a report from text

    Here's my VB6 code for passing data from .csv text files to a Crystal 8.5 report that also contains a subreport: Private Sub Form_Load() '************************************************************* 'PARSE THE COMMAND-LINE EXECUTABLE...
  19. alhamil5

    Strings From .csv File Being Interpreted As Numbers At Runtime

    Even though I've defined ALL source data field types as String in my .ttx file, for some reason my report is treating any numeric data it finds in my source data file as a Number data type. This is a problem because where I want the report to print -001 for example, it's printing -1. Also...

Part and Inventory Search

Back
Top