Skip to Content
avatar image
Former Member

Updated format causes details in a group to start list in middle for the first record?

The Original.PNG attached shows a test Stub/Check/Stub from our ERP system that is using the original .RPT file and the top stub (which is in the details section within the group) shows the invoices starting at the top and working their way down the list. Same for the bottom stub (which is a subreport). original.png

The Changed.PNG attached shows the same test Stub/Check/Stub from our ERP system and the only difference is that I saved the .RPT file into the latest format with CR 2016. Now the detail section list begins the list on Line 6 instead of at the top and then begins the second invoice at the top with the remaining invoices in order. The bottom stub reacts the same as the original file. changed.png

I would like to know if there is a setting in the group or some difference between the older versions of CR (before CR9) when listing details within a group vs. 2016? How can I ensure that if I save the .RPT file in 2016 format that the list will start from the top?

I am using Crystal Reports 2016 independently.

Thank you for your time in advance.

Chris

original.png (15.5 kB)
changed.png (14.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jul 31, 2017 at 12:16 PM

    Hello Abhilash,

    Please see attached screenshot of design screen in CR 2016. Please let me know if you need any further information.

    -Chris

    design-stub-check-stub.png

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 31, 2017 at 01:37 PM

    In Section expert is there any suppression rules for details section.

    Have you checked suppress blank section for details.

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 31, 2017 at 09:57 AM

    Hi Chris,

    Could you please attach a screenshot of the design page too?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 01, 2017 at 08:56 AM

    In Preview mode can you show this section and how it corresponds to the data, if you have a details section corresponding to your blank space then it is a section control problem which can be resolved in section expert or changing order of data. Could be that in original order of data is such that blank appears at end of list and is therefore not seen.

    Add comment
    10|10000 characters needed characters exceeded

    • Just another thought.

      Do you still have the old version?

      If yes go to top menu and select Database -> Database expert-> Links tab.

      Compare joins from the two versions. Also right click join lines and see type, ie inner, left outer etc and make sure new version is same as old.

      Ian

  • avatar image
    Former Member
    Jul 31, 2017 at 09:38 PM

    @ Ian Waterman, no there are no suppression rules for details section currently set.

    -Chris

    Add comment
    10|10000 characters needed characters exceeded