Creating a group after the detail

• nicholas.campbell 65005

  Grasshopper

  Points: 14

  More actions

  August 2, 2011 at 3:17 am

  #245389

  Hello

  I am creating a report which basically groups everything on a claim basis, then has the detailed financials per currency, what they have asked me to do, is then create an additional two columns after the detail which are back within the group it currently looks something like this,

  claimid name address phone currency amt

  1 john southend 0207 GBP 1,000

  USD 2,0000

  2 sam essex 01702 CAD 1,000

  GBP 2,0000

  and they want it to look like this

  claimid name address phone currency amt comment

  1 john southend 0207 GBP 1,000 ABC

  USD 2,0000

  2 sam essex 01702 CAD 1,000 ABC

  GBP 2,0000

  so basically the comment section is not repeating like the claim section.

  can you let me know if this is even possible?

  Thanks and Regards

  Nick

• sdvoranchik

  SSCrazy

  Points: 2800

  More actions

  August 2, 2011 at 8:58 am

  #1362227

  If I understand correctly, I don't see any reason why this wouldn't work. You should be able to add the comment field to the report, if it is in the group you may have to use an aggregate function so the expression may look like:

  FIRST(Fields!Comment.Value)

  Let me know if that works or if you you get an error.

  Good luck, Steve

• nicholas.campbell 65005

  Grasshopper

  Points: 14

  More actions

  August 2, 2011 at 9:32 am

  #1362258

  Hi Steve

  The problem is, I only need show the comment once so basically if you visualise an excel export

  the grouped data like name address etc is essentialyl a merged cell (the number of merge cells dependent on the number of currencies and their summed amount), then single cells for each currenncy and their amounts then what i need is it to go back to merged cell.

  If i did a first(fields! etc) it would display the first comment each time for each currency.

  There is only ever 1 name, 1 address etc, and then upto 4 currencies and then back to only 1 comment.

  Easy fix it is putting the comment over in the grouped section on left, but for someone reason they need the comment field on the right after we have shown the 4 currencies?

  Hope that makes sense, in my head it does 🙂

• sdvoranchik

  SSCrazy

  Points: 2800

  More actions

  August 2, 2011 at 9:50 am

  #1362282

  I think you definitely lost me now. If the comment works properly in the group on the left side of the report, it should work the same way in the same group on the right side of the report (assuming you are using a table not a matrix?). Table reports don't technically process left to right. Are you using a table or matrix?

  If I understand correctly you said there is only 1 name, 1 address and 1 comment which should all be in the same group.

  Then below you can have up to 4 currencies as detail rows.

  This is pretty standard behavior for a table report.