locked
cystal report performance. RRS feed

  • Question

  • User-1075092149 posted

    i am using many sub-report in my crystal report, therefore, the performance is very poor when i export to text file. how should i improve the performance.

    the following are the solution to improve but i don't know how to do that.

     

    -If you are using Sub Reports, then you can use the ON
    DEMAND SUB REPORTS instead of normal sub reports. Since
    using the normal sub reports will be a cost factor to
    retrieve the data from the data source.

    -Using Linked Tables with Indexes is the better option
    instead of sub reports. Again it depends upon your requirement.

    -Instead of retrieving all the records, its always
    recommended to fetch only the necessary records using the
    where condition.

    Tuesday, January 17, 2012 9:39 AM

All replies

  • User1591401481 posted

    hope this will help you

    -If you are using Sub Reports, then you can use the ON
    DEMAND SUB REPORTS instead of normal sub reports. Since
    using the normal sub reports will be a cost factor to
    retrieve the data from the data source.

    right click on sub report ----> subreport tab ---> and select on demand sub reports

    -Using Linked Tables with Indexes is the better option
    instead of sub reports. Again it depends upon your requirement.

    Right click on sub report ----> pop up window appears then select change subreport link

    -Instead of retrieving all the records, its always
    recommended to fetch only the necessary records using the
    where condition.

    click on Reports in menu bar ---> then select selection formulas --> records

    you can put a query here as we used in our SQL where clause

    id >= 100 

    Tuesday, January 17, 2012 5:33 PM
  • User-1075092149 posted

    hope this will help you

    -If you are using Sub Reports, then you can use the ON
    DEMAND SUB REPORTS instead of normal sub reports. Since
    using the normal sub reports will be a cost factor to
    retrieve the data from the data source.

    right click on sub report ----> subreport tab ---> and select on demand sub reports

    -Using Linked Tables with Indexes is the better option
    instead of sub reports. Again it depends upon your requirement.

    Right click on sub report ----> pop up window appears then select change subreport link

    -Instead of retrieving all the records, its always
    recommended to fetch only the necessary records using the
    where condition.

    click on Reports in menu bar ---> then select selection formulas --> records

    you can put a query here as we used in our SQL where clause

    id >= 100 

    what is the different between onDemand sub report and normal sub-report. can it improve the speed of exporting file??? 

    i am now is passing ID as parameter to sub-report to retrieve related data to sub-report, but the speed is very slow.

    Tuesday, January 17, 2012 10:40 PM
  • User-1075092149 posted
    anyone tell me if i don't use sub report,can i use more than 1 stored procedure as a data source for this report
    Wednesday, January 18, 2012 9:18 AM
  • User1591401481 posted

    you can not call more then one store procedure in single report

    look at the below URLs please 

    http://stackoverflow.com/questions/883705/how-can-i-use-more-than-one-stored-procedure-in-a-crystal-

    reporthttp://forums.asp.net/t/1211422.aspx/1

    Wednesday, January 18, 2012 4:06 PM