Migrating from CR 9 to 2011

[Luvsql]

I'm finally at a place where I can migrate up to CR 2011, so I've downloaded the eval version to get used to the Designer and ensure how reports run properly. Immediately I have a few issues:

1. CR 9 the Field Explorer was on the left and then the Designer and Preview. Now I have to click on the Field Explorer and because I want it on the left I have to drag it over, but then it covers up some of the designer. Why won't it stay permanently open to the left of the design tab?
2. I had a report with many parameters, most of which had blank defaults or a few had values as defaults. This version when I refresh, it's inputting ... as the defaults and I have to manually choose each one. Kind of annoying.

 

[IdoMillet]

In older versions of Crystal, the parameter default value was simply the first value in the list of values.
In the later versions, a separate property of default value was added. You need to explicitly set the value of that property in order to get the behavior you want.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Luvsql]

In my CR9 reports, I only have 1 single default value. There is no list of values. When I open this same report in CR 2011, it is entering "..." as the default and I have to manually choose the default, which was already entered in version 9. I also have the option of the default being blank ie no value, but this doesn't seem to be possible either. Also can't enter a default date to be today as the default.

 

[PeterDimitrov]

When you convert a Crystal 9 report to 2011 a parameter with default values will be converted to a parameter with a static LOV. However Default Value, which is a new field, will be not set and you will need to select something from the list. Find the "Default Value" field in the "Value Options" list at the bottom of the parameter's screen and put there the first value from the static list. If you have a lot of reports with a lot of parameters this might be a tedious operation so you can consider creating an app to do that for you.

You can use just constants in the "Default value" field. If you want to use dynamic values, for example relative dates (today , end of the week etc.), variables related to the current user, computer etc., you have to switch to a viewer , which supports this. If another viewer is not an option, as a workaround, you can use "magic" values. For example if you want to use Today as default value you can set the default value to a date , which will be never in use ( like 1/1/1900), then create a formula and check if the parameter value is equal to the "magic" value and replace it with the currentdate. Use this newly created formula in your record selection formula. Crystal 2011 supports optional parameters so you can consider empty value as a "magic" value too. It will be a training issue to let the user know that if the date value is left empty the report will use the current date.

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports and SSRS.