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. Icebun

    Forcing Report Footers to print one same page

    None of these suggestions worked - the last one didn't apply anyway as there are no groups. Thanks anyway. Another other ideas anyone ?
  2. Icebun

    Forcing Report Footers to print one same page

    Hi all, I have a report that is made up of a "container" and 6 sub reports. The 6 sub reports are contained in report footers on the "container" report as follows : Footer 1 Sub Report 1 Footer 2 Sub Report 2 Footer 3 Sub Report 3 Footer 4 Sub Report 4 Footer 5 Sub Report 5...
  3. Icebun

    Compiled Report filenames using tilde (~)

    Erm, I don't think you understand what I'm talking about. I'm not using DOS (is there even a version of Crystal reports for DOS). Nor am I using an command line operations. I'm trying to compile a Crystal report from Windows 2k Pro. The rpt filename is Code List.rpt. After comilation I have 3...
  4. Icebun

    Compiled Report filenames using tilde (~)

    Often when compling a report, the .exe and .crf filenames that are generated by Crystal use DOS filename with a tilde on the end. For example : Code List.rpt will be compiled as CODELI~1.CRF and CODELI~1.EXE. Is there any way round this ? I'm using Crystal Version 7.0.1.100. Thanks.
  5. Icebun

    Upgrade Options from CR7

    I am are currently using CR7 to distribute reports to users. We have recently started to use graphs. One feature missing in CR7 is the ability to use running total fields on graphs. Top get around this, I was planning to upgrade to CR9, but I now find that there is no facilility to distribute...
  6. Icebun

    Why do I have to press form feed to print my report ?

    Crystal Version 7.0.1.100 Printing from CR, or from a distributed EXE. Using the correct printer driver (i.e. the same driver as all our other reports).
  7. Icebun

    Why do I have to press form feed to print my report ?

    On certain crystal reports I've written, I have to press the form feed button on the printer to get the report to print. This doesn't seem to be consistent (i.e. it happen sometimes with some certain reports, but never with other reports). There is, however, one report that ALWAYS requires us...
  8. Icebun

    Changing data source from ODBC to Access

    OK, I've tried doing this using both suggestions above : 1. When I try using 'convert database driver' and then 'file system', Crystal lets me select the folder where the mdb file is located, but not the actual file (there are 2 mdb files in the folder). 2. If I use the ODBC- MS Access driver...
  9. Icebun

    Changing data source from ODBC to Access

    Hi all, I have a report based on five SQL tables which I am querying using ODBC. I've made a copy of the tables in an Access database so that we can continue to run the report on a laptop. I now need to do a 'Set Location' in the crystal report so that it points to the Access database, rather...
  10. Icebun

    Adding Total line to Chart

    Apologies, the last line should read 5000.
  11. Icebun

    Adding Total line to Chart

    I have a line graph that plots one of 4 expenditur etypes by month. Month is the x axis and expenditure values are plotted on the y axis. There are 3 expenditure types (capital, pay, non pay and income) so I get 4 lines. How can I add a line to show the net total of all 4 expenditure types...
  12. Icebun

    Problem with multi-table report

    Thanks Ken, I think I would have a problem using a subreport, as the data all needs to be on one line as follows : FINANCIAL CODE----DATA FROM TABLE 2----DATA FROM TABLE 3 I think I may have to do this in Access.
  13. Icebun

    Problem with multi-table report

    Hi, I'm trying to write a report based on three tables linked like this : Table 1 ------- Table 2 \-----------Table 3 Table 1 is the 'main' table in the report and holds details of our financial codes. Tables 2 and 3 hold details of financial transactions, and are both...
  14. Icebun

    Using parameters from main report in a formula on subreport.

    I have a report containing a main report and a subreport. Users enter a year and a month on the main report. This is used to calculate financial information in two columns : 1. a current month total (for the month and entered) 2. a cumulative total (for all months up to and including the month...
  15. Icebun

    CRRUN32.EXE error

    Some of our users get a CRRUN32 error when running a compiled report. The dialog box doesn't contain any detail, just CRRUN32.EXE in the title and an OK button. Other reports on the same PC run OK. The Crystal Report that causes the error runs OK on other machines with the same OS (Win2K)...
  16. Icebun

    Multiple Value Formula Field

    Join isn't available in v7. Tried inserting a ; after the while statement to no avail. The problem is definitely the while statement. If I remove it, the formula validates with no probs. So, any other methods for getting multi value parameter fields to print ?
  17. Icebun

    Multiple Value Formula Field

    Hi, I'm try to display all the values from a multiple value parameter field in the report header. There is an article on this on Crystal's website that mentions using the following code : numbervar counter; numbervar final; stringvar holder; counter := count({?Multi}); while counter > 0 do...

Part and Inventory Search

Back
Top