Recent content by bouser69

Thanks lbass It worked with the function Maximum

Hi there Could any one please help me. I do have this situation. I grouped on 5 fields but wanted to sort on another field. This non grouping field is non measure object. How could I do sort on this field even grouping on 5 fields? I am using Crystal XI. Thanks in advance

Could any one please guide me the steps that involved for migration from 6.1a to 6.5. If this is not the correct place to post please tell me from which forum i can get any help I did searched for doumentation I couldn't find that if any one has documentation could you please post it.

Thanks a lot for your replies lbass It worked. The query name also should be the same. Before that it is different now I changed the query names it worked.

I am using universe as a datasource. The joins and tables in both queries are same with different conditions. Even if I remove those conditions also I am getting double prompts. I am not sure what I am doing wrong.

Hi lbass ok I got you. The problem there is in report I do have prompts if I add second query I need to add these 2 prompts in 2 queries then I am getting double prompts issue. If I remove prompts in one query it is impacting on performance. for that reason I am including the subreport

Thanks lbass The reason that I am using subreports are I do have different conditions for subrpeor and mainreport. I couldn't clearly understand this question instead of linking the subreport table to the main report table? I am placing subreport in report footer

Thanks Ian after creating the shared variable for Id in mainreport I I used in subreport. But how can I calculate average. I don't have any groups in mainreport or in subreport.

Hi I am calculating the averages of 2 fields. One field in main report and one field in subreport. The result of Average should be based on the Id's that are in mainreport and subreport. I need to link the Main report Id and Subreport Id. For this purpose I created a Id parameter at...

Thanks For the quick reply Is that possible without concatenating? Because I do have report and charts with the same purpose. For reports I did grouped by Id and in report I showed the Message. We need to have same in the chart. I am not sure whether my Business users will accept this or not.

Hi There How can I solve this issue? In Bar chart I want to group by one variable (ID) on X axis but I want to display some other Variable (Message). Because ID is the Unique one not the Message. It could be a chance that for different ID the Message will be the same because of that reason I...