Search results for query: *

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.