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