Search results for query: *

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.

We are using SI version 7.5.2 I have a user parameter called From_Date which is a String Data_Type. In a Formula I have: DateVar Use_From_Date; If ({?From_Date}= '' or isNull({?From_Date}) or {?From_Date}= '0') Then ( Use_From_Date := date(Year(CurrentDate),Month(CurrentDate),1); )...

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

Thanks for the help. Both solutions work, except I have one addtional problem. When the Col#_Value is summed in the Groupings, Crystal disables the Summary field so I end up with blank summaries in my groupings. The detail works great but if Crystal detects any traces of a 'maximum' used in...

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 had previously read this and it gave me something to try with the isnull solution. The additional problem I have is I have an additional filter which caused that solution to no longer work. I also did not see the final answer on the shared. I have not tried tried the subreport yet but I am...

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

You are correct. But I do not want the user to see the other parameter. They get confused by seeing this extra parameter. So by just not filling it in, is technically not a problem since it doesn't get used depending on what they select. I just want a way to make it easier for the end-users...

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

This final suggestion work perfectly! Thanks (I did have to add an OnLastRecord in order for the last total in detail B to not be suppressed). Thanks again for your willingness to see this thru.

Given your data the end result should be as follows: 7/15/01 1234 5 1234 5 <---grouping sum 7/15/01 2345 3 2345 3 <---grouping sum 7/16/01 1234 5 1234 5 <---grouping sum 7/16/01 2345 3 7/17/01 2345 3 2345 6 <---grouping sum...

Your first statement is correct. The Grouping is by Date and then by Product. And yes if the same product is sold on 3 consective days, the report is to show one total for that particular product. If a different product is sold within one of thos days then the end result would be 3 product...

Grouping by Item then by Day will first order the items in sorted order and then within each item, group them by day. (using the data example above item 1234 would have the 7/20/2001 record grouped with the other 1234 records). So this will not solve the problem. At this point I think I will...

Still no luck. I started from scratch so it would be clean. But the end result is still the same. Suppressing the 'Day' (Date) grouping makes it so the report does not show the day grouping but it still groups the data by day so an item on two different days have two seperate grouping totals...

This does not work correctly. The end result is that each item is summed per day. I do not want the report grouped per day, just sorted so that the items do get grouped together and summed once an item changes. So if the same items span consecutive days they are grouped together. ex: 7/15/01...

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 &quot;on original order&quot; and...

You are very much appreciated. It worked like a charm!

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 &quot;Options&quot; on the report...

I thought you had the answer, but no luck. I created a new report with only a title and used NO datasource as my new report template. It worked for a few tries but then one Dictionary did not work and now a few others don't work either. I used a Dictionary that is very simple, 3 tables. When...

No, I can not find a pattern and yes it is the same dictionary. I would say it happens most when I use the 'Add Database to Report' option. I have create two reports with Page Header and Page Footer standards so I don't have to keep creating and aligning this stuff, sort of like a template if...