locked
Subreports repeated many times on main report when preview RRS feed

  • Question

  • User-1305878657 posted

    hi Team,

    i m facing one problem in crystal report where in my crystal report having two subreport when i m previewing the crystal report then Subreports repeated many times on main report when preview.

    i dont know why it happens i already check in code where i not getting repeated record but while priview of main report i m getting repeated record.

    pls help me.................

    thank in advance

    Tuesday, October 29, 2013 6:57 AM

All replies

  • User-1392847221 posted

    Hi,

    I don't remember exactly its quite long to work on Crystal report but i think there is a supress option you can use that.

    Tuesday, October 29, 2013 9:48 AM
  • User-578610739 posted

    Hi Mohan,

    While use subreport, some rules to be follow to overcome this type of issue.

    1. Proper linked to be set between main report and sub report.

    2. Put sub report in group footer or page footer (if group is not used). So it execute at the last of grouping or paging and show at only 1 time. Also benefit of this is, all parameter value will be set while execution reach to sub-report(s).

    3. For each sub report , if you show horizontally, then use different -different group section i.e. {field-name- group-footer}-a , b (may be naming convention wrong, not remember exactly ). and each section suppress for null.

    4. Also the worst thing is your main report width and your sub-report width is match , so contain will fit. This is for height also.

    Wednesday, October 30, 2013 1:27 AM
  • User-1889818738 posted

    I have same problem

    I used Subreport Because WaterMark Does not Show Line Objects

    so, I Purt WaterMark on Main Report and Whole Data in Main Report Detail Section,

    now problem is That Data is Repeating

    Please Reply

    ASAP

    Friday, September 4, 2015 3:22 AM
  • User1243880387 posted

    So, that data needs to be a single row from the datasource of multiple rows?

    In case there will be multiple row data in the main report, the report will print its detail section as many times as the number of rows, which is evident.

    So, make sure subreport is also placed at proper place.

    In case data is ok to come in multiple rows, and its correct, so place subreport in header or footer so that it may print one time only.

    Monday, September 14, 2015 4:28 AM