Need help with listing order of Proposals in Crystal Report

Options
Samantha Ford
Samantha Ford
Tenth Anniversary First Comment
in Blackbaud Raiser's Edge NXT®: General Discussion
I have a Crystal Report with Details A and Details B sections that are pulling RE Proposal information.  Details A is information for Annual proposals and Details B is information for Captial Campaign proposals.  When there are multiple proposals for sections A and/or B, Crystal is listing the propsals as A, B, A, B, and I would like to list the proposals as A, A, B, B.  


Any suggestions on how to fix this would be appreciated.  Thanks!


Samantha 
Tagged:

Comments

  • Chester Bammel
    Chester Bammel
    Tenth Anniversary 25 Likes 10 Comments Photogenic
    You will need to create a group for proposal type.  A-type proposals will be first listing all details, then will be followed by B-type proposals and their details.


    Hope that helps.

    ​Chester

     
  • Samantha Ford
    Samantha Ford
    Tenth Anniversary First Comment

    Chester Bammel:

    You will need to create a group for proposal type.  A-type proposals will be first listing all details, then will be followed by B-type proposals and their details.


    Hope that helps.

    ​Chester

     

    Thanks Chester for the suggestion.  We tried creating groups and the proposals are still listing out of order.  I have another question:


    For suppressing duplicates in details (by section), the following formula works if the duplicates are listed consecutively:  {table.ProposalImportID} = previous({table.ProposalImportID})

     


    Is there a formula to suppress when they are non-consecutive? In my example below, I want to suppress the entire duplicated row.  Also, to suppress the entire row, is this accomplished in section expert (suppress no drill down x-2) or by each object field (format field...common...suppress if duplicated...suppress x-2)?

     


    Proposal  Name        Ask Date    Ask Amount


    Children's Garden     12/25/16     $1,000


    Memorial Walkway   10/31/17      $500


    Children's Garden     12/25/16      $1,000


  • Chester Bammel
    Chester Bammel
    Tenth Anniversary 25 Likes 10 Comments Photogenic
    When you say your proposals are still listing out of order, are you sure your groups are in the correct order?  For instance if the group you created is Group 2, then you might need to drag it to the Group 1 position, so it will group by the proposal type first, then by whatever the second group is.   If that is the only group you have, then I am not sure what it would be without seeing the report itself.  You would be welcomed to send me a copy at clb089@shsu.edu.


    Regarding whole row suppression, you are correct stating that it is in the section expert (suppress no drill down x-2) area.  Typically the formula is built on the condition of one field, but it could be multiple, such as:           Value 1 > 10 AND DataType = "Z"



    ​Regarding the duplicate rows, if you are getting unexplained duplicates, then 99% of the time it is because of a linking issue with your tables.  You are getting more than one duplicated record because there are additional instances of whatever it is linking to in the second table.  Proper linking could fix that.    If there are valid reasons you are getting multiple records but you only want to display one record, then usually you will group by that value and display the relevant information in the group header.  Hope this helps.
  • Samantha Ford
    Samantha Ford
    Tenth Anniversary First Comment

    Chester Bammel:

    When you say your proposals are still listing out of order, are you sure your groups are in the correct order?  For instance if the group you created is Group 2, then you might need to drag it to the Group 1 position, so it will group by the proposal type first, then by whatever the second group is.   If that is the only group you have, then I am not sure what it would be without seeing the report itself.  You would be welcomed to send me a copy at clb089@shsu.edu.


    Regarding whole row suppression, you are correct stating that it is in the section expert (suppress no drill down x-2) area.  Typically the formula is built on the condition of one field, but it could be multiple, such as:           Value 1 > 10 AND DataType = "Z"



    ​Regarding the duplicate rows, if you are getting unexplained duplicates, then 99% of the time it is because of a linking issue with your tables.  You are getting more than one duplicated record because there are additional instances of whatever it is linking to in the second table.  Proper linking could fix that.    If there are valid reasons you are getting multiple records but you only want to display one record, then usually you will group by that value and display the relevant information in the group header.  Hope this helps.

    Thank you so much for your suggestions, we are still working on this.  What forumla should I use to suppress a whole row?

     

Categories