Thanks for the suggestions! I did accomplish this task by setting up a multi-value parameter by country (per lbass) and then picking Allow Multiple Values in the parameter field setup. I now have just one report where users can pick US, Canada, or both.
What I am trying to accomplish is: I now have three separate reports on our report browser; Sales Canada-Only, Sales US-Only, and All Sales (which is US & Canada). I would like to replace the three reports with just one. Would using a parameter, based on Country code, be a possible solution...
I'm using CR v10. I would like to set up a parameter on a report that lets the user pick one of three values: CANADA, U.S., or BOTH. I need help writing the formula for the report grouping. My formula, below, works for US and Canada, but gives me nothing for BOTH (since I have already used...
You can also use this formula to convert an 8 digit number to date format.
WhilePrintingRecords;
NumberVar input := {DATE}; // or whatever your field name is
// This line checks for a minimum value, any value will work.
If input < 19590101 then Date (1959, 01, 01) else
Date ( Val (ToText...
Thank you for the response. My scheduling software requires that a report instance (with at lease one record) be created before it will replace the old report instance. Is there a crystal formula that will return one record for a report, even though no records from the database have been...
In CR 10, instead of receiving an "empty" report when there are no records returned, I would like to know if there is a formula I could write that will print something on the report (e.g. "No Sales for Month") even when there are no returned records for a report.
I use rePORTAL, from Shahrabani & Associates, LLC., (www.shahrabani.com) as my scheduler/viewer. It allows report level security as well as support for dynamic and cascading parameters - - and a fraction of the cost of CE.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.