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: *

  • Users: CH
  • Order by date
  1. CH

    How to suppress a section based on another section being suppressed

    How do I suppress a section based on another section being suppressed? I have a report with 30+ detail sections. Each section has a different suppression formula. For my last detail section and group footer section, I want to suppress only if ALL the previous sections have been suppressed. Is...
  2. CH

    Crystal Reports 9 not prompting for file destination when exporting

    I am using CR 9 with VB6. The export does not prompt the user for a destination when exporting a report from a computer with only the runtime files. The export works fine on a computer that has CR 9 fully installed. I am distributing all the export run time files listed in the CR 9 Help...
  3. CH

    Page header carry over

    Try this... 1) create a new formula @TurnPageHeaderOff = WhilePrintingRecords; Global BooleanVar SuppressHeader := True; Place this formula field on the report before the subreport. 2) create a new formula @SuppressHeader = WhilePrintingRecords; Global BooleanVar SuppressHeader...
  4. CH

    Need subreport page footer

    I have a report with many subreports. I need to changed the page footer based on the current record that is printing in the subreport. I have tried using a shared variable but the value is updated at the completion of the subreport; therefore, if the subreport runs over more than one page or...
  5. CH

    Changing the SQL statement in Crystal Reports

    Thank you for your response. I just wanted to make an addition for anyone who might have the same problem. When sending the sql statement using the SQLQUERY the ORDER BY clause was still giving me problems. It turns out that the ORDER BY clause requires a carriage return and linefeed to...
  6. CH

    Changing the SQL statement in Crystal Reports

    I am new to Crystal Reports and having a hard time. I am using Crystal Reports with a Sybase database and a VB application where the user can query on 20 different fields. I build the sql statement in VB as the user builds his/her criteria. The SELECT section selects the same fields for every...

Part and Inventory Search

Back
Top