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

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

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

  • 0

    SAP is the current ownder of Crystal reports. Sage 300 CRE used Crystal Reports XI. There are many resources available online.

    I did find the the user's guide which you may find helpful. Chapter 23 is parameter fields and prompts.

    http://help.sap.com/businessobject/product_guides/boexir2/en/xir2_cr_usergde_en.pdf

    Also as of Sage Timberline Office 9.8 you can create Ranges with Crystal reports. For more information you can review the knowledgebase article How do I add ranges to my Crystal report? ID: 23173

     

    There is a search capability in Sage City in the top right. There are then filters that can help you narrow the search in a sidebar on the left.

     

    Casey Knapp

    Senior Customer Support Analyst, Sage Construction and Real Estate

    Sage North America

  • 0 in reply to Casey K

    Thank you Casey.

    I think my actual problem was my report was using a data source other than "Timberline Data Source", so Sage CRE was not able to get data and also did not show the parameters.