Is there a way to access the parameter description field. I want to use it like a code table. But I want the user to see the value and I want to use the description field.
Why does a check for IsNull(Parameter_String) or Paramater_String = '' work fine(behaves like I would expect) when developing my Crystal Report. But when I place it on the Seagate Info Server and schedule it and either check Null or leave blank on the prompt window, it does not evaluate out...
I have set a global variable in a formula, I have placed in the Page Header (I assume thats the place to put it, I tried the Report Header too). It is assigned as follows:
Global NumberVar Max_Period;
Max_Period := maximum(Period); // Period is a field from the returned data set. I want the...
I am creating a report in CR 8.5 against an Oracle 8 database and have two tables which are join together using an outer join. I have an additional field that needs to be filtered in which the user provides the value. The field I am filtering on is on the outer joined table. We need all the...
Is there a way to add a parameter or suppress a parameter depending on what the use selects from another user parameter? I want to allow the user to pick the report type but depending on which report option they select they need to fill in another parameter.
(The answer can't be database driven...
I am trying to sort on a different field than the field in which I am grouping. I would like to group on Items but sort in their order date. So the whole report is in order date sequence with groupings of items within each date. I have changed the grouping to "on original order" and...
I have a formula which converts a Date to Year-Month (2001-10) which I am using to Group records. The formula is: Year(Delivery_Date)&Month(Delivery_Date). The problem is that the answer comes back as 2,0000.000010.0000
The only thing I know of is the number "Options" on the report...
Sometimes when Iam using my Crystal Dictionaries the Show SQL Query option is not enabled. What am I doing or what can be done to ensure this option is on. I need to review my sql, to ensure the Dictionary is correct. Sometimes the same dictionary causes this to work and not to work. But I...
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.