Search results for query: *

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.

lbass previously gave a suggestion on summarizing shared value from sub report in main report by resetting the shared value in group. It really worked well. I have another situation where in main report grouped based on A in GH1a. Now the sub report is located in GH1b. Now I want a total in...

This is what happening. I think this is a SAP specific problem (guessing) If for a GH1 value, Phase B has equal number of Phase C in Gh2, data is fine if for a GH1 value, there is no Phase B and there are Phase C in GH2 then also data fine. Problem when for a GH1 value if Phase B has 1 value...

I have Table A, B and C. A to B and A to C linkage is using left outer join based on Project Key. So all projects listed in A will be displayed and common projects in B and c will fetch data. Table B and C has project Phase. Now I need to create a group based on Project Key in GH1 and PRoject...

From the design point Main report and sub reports have only one common link and rest all are many to many linkage. Main reason for using sub report is because there is a requirement to display subreports side by side in section to make it to look like a single table I have verified keep...

I have 2 subreports which are displaying the data based on the GH1a value in main report. And sub reports are placed in GH1b and GH1c. For some of GH1a value 2nd sub report is 2 or 3 pages long. In such cases i could see GH1a and GH1b together in say first page but GH1c starts from second page...