Is there any feature like summing total in crystal report?
Answers were Sorted based on User's Feedback
Answer / rahul
Crystal reports provide features like grand total, sub-
total, running total etc. You can select any of these
features in Insert menu item.
|Is This Answer Correct ?||20 Yes||1 No|
Answer / sajal
yes crystal reports has fetures like grand total, sub-
total, running total etc for summing up numweric values
|Is This Answer Correct ?||15 Yes||4 No|
Answer / arvind gupta
Yes Sub Total, Running Total
|Is This Answer Correct ?||8 Yes||2 No|
Answer / vishwa
We can use the formulas to calculate this.
Eg., Aggregate functions
Or you can use running totals to generate this.
Eg. Sum () option
|Is This Answer Correct ?||8 Yes||4 No|
Answer / neeju
yes, use formula field.
|Is This Answer Correct ?||7 Yes||3 No|
Answer / damaji shelke
|Is This Answer Correct ?||1 Yes||0 No|
Answer / prashant
Running Total can be used for summing the group value, row
value, grand total etc.
|Is This Answer Correct ?||1 Yes||1 No|
Answer / sapna
|Is This Answer Correct ?||0 Yes||3 No|
Answer / srinivasa iyengar
Vishal is correct. U can use formulas for summation..
|Is This Answer Correct ?||2 Yes||6 No|
Answer / guest
Yes, we can add any database field afterwards also. Select
‘Database Field’ in Insert menu item.
|Is This Answer Correct ?||2 Yes||13 No|
How do we connect to the database?
Can we use stored procedure for creating the report?
Can we export data of reports into other format like in world doc etc?
to ensure that all of the data from a field is displayed in a report text object you should do which of the following?? a) use the format wizard b) size the text object manually c) select the auto format option for the text object d) select the can grow option for the text object e) set the can grow option to the details section of the report
One more interview question If I have the data where some columns have multiple values in a given row of data returned from the database. The stored procedure returns data as it is that is blanks values and non blank values. However, I need to suppress the blank values not by showing 0 values but by shifting the cells up. Is there a way using a formula to shift the blank cell one row up based on a selection critieria? In the example below, I want to get rid of the blank values under Exposure column without replacing with 0. example: Company Margin Exposure AB 500 3 10 7 8 ABC 200 4 2 5 10 Thanks Anita
I have a crystal report with a linked subreport as well. is there any way not to print the current record on the main report if no records are returned from the subreport? thanks you email - firstname.lastname@example.org
How to conditionally suppress a field based on whether a page number is odd or even?
how can we convert crystal dictionary dc5 file to another datasource format like mdb or xml schema
Why is Excel Report preferred over crystal reports?
How to print two details fields at the bottom of the page
hi...to all i want to generate the two crystal reports one is employee and another is project. now i want to display the two reorts in a single crystal report viewer. i've tried using sub-reports but the page header is not avaliable in a sub reports.. so i want to display two separate crystalreports in a single viewer.. can anybody help me.. plz
Can anyone help me with an answer to this question? Where is the image located, after you've placed it on the report?