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

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

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

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

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

I have a group A and it has numerous detail record. I have added a running count, inorder to find the last detail record of the group. I need this to make the last detail record of every group to be bold. Problem here though the running count I have, I dont know the logic how to find the last...

i have designed a crystal report whch has groups say A, B and C in main report. I have created sub report by grouping C and sub report has the data (measures). Main report doesnot contain any measure. Now the subreport is linked to main report based on prompt on C. I have created a shared...

I have a problem in cross tab report. In RH (report header) I have a cross tab which spans across multiple pages. Now I am not finding way to print a page no for each page. I tried some options all prints at the last page only. Not in all pages. I appreciate your suggestions. -Raghu

I have multiple value parameter in crystal report and i need to print the last value selected for that parameter. For Ex. I have selected 1, 2 ,3, and 4 in from the list of values of a multiple value parameter. 4 is the last value and in the report header i need to print 4. I appreciate your...

I would like to suppress whole column if dbfield value is 0.00. I was able to suppress it in common tab of format field by using formula if dbfield =0.00 then true else false. But i would like to suppress column value only when all the values in column are equal to 0.00. Otherwise I would like...