Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rbarekere

    flattening data in crystal report

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

    Discrete parameter value display problem

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

    Discrete parameter value display problem

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

    Discrete parameter value display problem

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

    Summarizing shared value from sub report in main report

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

    Grouping while 1 table connecting to other 2 tables with leftouterjoin

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

    Discrete parameter value display problem

    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 :)
  8. rbarekere

    Grouping while 1 table connecting to other 2 tables with leftouterjoin

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

    Discrete parameter value display problem

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

    Summarizing shared value from sub report in main report

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

    Summarizing shared value from sub report in main report

    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/...
  12. rbarekere

    Summarizing shared value from sub report in main report

    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?
  13. rbarekere

    Summarizing shared value from sub report in 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...
  14. rbarekere

    Long subreport starts from subsequent page

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

    Grouping while 1 table connecting to other 2 tables with leftouterjoin

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

    Summarizing shared value from sub report in main report

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

    Grouping while 1 table connecting to other 2 tables with leftouterjoin

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

    Grouping while 1 table connecting to other 2 tables with leftouterjoin

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

    Long subreport starts from subsequent page

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

    Long subreport starts from subsequent page

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

Part and Inventory Search

Back
Top