1.What is caching? What are the different types of caching?
2.Is there any feature like summing total in crystal report?
Answers were Sorted based on User's Feedback
Answer / satish reddy
Caching means just storing the frequently used itmes in
memory . Caching is a tried and tested technique for
performance improvement.
Two types of output caching,
1.Page output caching:- It adds the response of page to
cache object. Later when page is requested page is displayed
from cache rather than creating the page object and
displaying it. page output caching is good if the site is
fairly static.
2.Page fragment caching:- it parts of the page are changing,
you can wrap the static sessions as user controls and cache
the user controls using page fragment caching.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / naresh
Answer to 2nd question:
Yes, There are options in crystal reports for summing up
the records. You can sum the records by group , or by grand
total. There is also another feature for summing up
is "Running Total". You can just insert running totals, or
summaries by just using the icons or you can write your own
formula.
Answer to 1st question:
I don't know how this question can be answered interms of
crystal enviroment. Anyhow I know somethig abt caching,
There are many servers comes along with your CRS suite, BO,
or Crystal Enterprise suite.
All these servers run behind crystal reports to run and
publish the reports successfully. Maintaining all these
servers is kind of amin job.
Below are the list of servers that work together to make
Crystal reports a successfull pack:
1) Input server(File repository Server)
2)Output server(File Repository Server)
3) Cache server
4) destination job server
5) event server
6)list of values job server
7) page server
8)program job server
9) RAS(Reports Application Server)
10)report job server
11)CMS(Central Management Server)
| Is This Answer Correct ? | 2 Yes | 1 No |
How can we performance tune reports?
9.Can we export data of reports into other format like in world doc etc? 10.Can we create report using more than one database?
11.How do we format field? 12.How do we connect to the database?
What is the difference between running total and sub-total?
What is an enterprise?
0 Answers Mahatma Gandhi University,
How can we know the time taken for particular report execution?
In one subreport how many subreport we can insert?
How many types of subreport are there?
7.Are there any limitations in crystal reports? 8.Can we use our own SQL for creating a report?
2 Answers Bhawan Cybertek, ICICI,
3.Can we use stored procedure for creating the report? 4.Does Crystal Report support all the functions that we have in Oracle?
5.Can we add any database field once we have chosen ?Close? button?
How to set up valid email address and printer in Cognos, so can delivery the report by email or print it out?