Recent content by rbarekere

I have a table which has 4 columns Customer, Partner type, Agent no and employee #. cust type agent emp 1001 A 01 1001 B a1 1002 A 02 1002 B a2 I have grouped the data based on customer and I would like to flatten the data with 2 columns Agent Emp and I want...

Is there any way to convert the prompt output to date type and then use it in array?

I tried to convert the array value to date datatype. But it didnt work may be due to a fact that Minimum and maximum assignment is done while array assignment

This is not CR parameter, this is the parameter created in backend, it converts to string type in crystal report.

Thanks LB. I did the same mistake in another one. It seemed to me like it is working ! Thanks a lot

It is the restriction imposed by product vendor SAP :) Crystal report users MDX syntax instead of SQL syntax to connect to SAP BW (datawarehouse). So there is no SQL Expressions available while you connect crystal report to SAP BW

This prompt is coming from backend, (SAP BW, dont want to mention though)! We cant have this prompt in Crystal Report due to performance consideration :)

I am using crystal report only. Concept will remain same but we donot have option of using SQL Expression or command line sql. Only way to achieve the Join is using the table link in database expert. I couldn't proceed with joining table, instead I continued with subreport though it has...

Displaying parameters chosen using a formula faq767-5684 Using the help of code mentioned in above FAQ, I wrote a code for displaying date prompt which include range and multiple value selection. datatype for the parameter is "STRING"! Possible way of user entering the value is select from...

I tried exactly the same. For Ex: I have 3 records for Gh1b. 1) 2,200 2) null and 3) 500. Gh1c value respectively displays 1) 2,200 2)2,200 and 3)500 Finally RF value is 500. Here is the reset formula for GH1a numbervar Proj_Balance; if not inrepeatedgroupheader then Proj_Balance:=0...

This is the piece of information I got from some one Passing a multiple value parameter to a subreport is allowed. I would suggest letting Crystal Report create the parameter in the subreport. Try following these steps: 1. Create the multiple value parameter in the main report 2. Create/...

Is there any way i can pass all values A, B and C to sub report and calculate the Grand total in Report footer. Then present the subreport in the Report Footer of Main report?

More information on the above problem. As I have told I have reset value in GH1a. Now say I have 3 Gh1a values say A, B and C. Then sub report value for A is 100, no value for B and for C value is 100. If I select only A and B in parameter then i get the report footer total as 100 which is...

Thanks TeyBrady. That was exactly what i was looking for. -Raghu

Thanks lbass. It wont work in my scenario, because data source is SAP BW. Unfortunately it allows only "LEFT OUTER JOIN", and no full outer join.