Crystal Reports - how to set up parameters in Sage CRE?

I have created a custom Crystal Report.   It has three parameters related to dates and job status.

The report runs in the Crystal application and I would like to make it available via the Sage CRE report list.  I have added the new report with the filename ending in (CR).rpt

When I print preview the report, the window hangs. There is no form for the user to enter parameter values.

How do I set up the parameters in Sage so the user can enter their choices?

Also - is there a search-by-forum function here that would allow me to search this forum?

Thank you-

Bill

Parents
  • Bill,

    Adding (CR) to a Crystal Report design file name is a good mnemonic to visually distinguish a CR report design name in your reports folder, but that naming convention has no procedural significance.  

    When you add a new report to a Report Menu using Reports Manager (Reports > Reports Manager), you are presented with three radio buttons under the "Source" section of the "New Report" pop-up panel. Always choose the "Crystal report deign" option when the design file name is a Crystal design. That will assure that the report triggers the run-time version of Crystal Reports to process the report.

    All parameter prompts for Crystal Designs must be built into the Crystal Design. There is no option to present the native Timberline Report prompts such as "Ranges" or "Conditions".

    Hope that helps clarify your situation.

    Art Minds

    (former) Sage Timberline Office Certified Consultant

    Pasadena, CA

  • 0 in reply to ArtMindsConsulting_pinner

    Thank you for your help Art.

    I have selected the "Crystal Report" option on the 'Change Report' dialog, but my Crystal parameters are not appearing.  I have found an existing Crystal Report that is showing parameters so I am now examining it to find out what is different.

Reply Children
  • 0 in reply to billwagnon

    My parameters include a date range for which I had a Begin Date and an End Date parameter.  The existing report has a single range parameter marked 'Allow discrete values: FALSE'.

    I changed my report to handle the parameter the same way, and now the new report is showing the parameters.  

    I have a couple other things in play on this report that I need to check, but parameters appear to be working now.