SageForum for UK versions of Sage 50- Help and support.

Hey,

Is it possible to have 2 "details" sections on a report.

What I want is 1 "details" section with a filter that only displays lines with stock code "M" then a break section with text and then another "details" section further down the page with a filter that only displays lines with stock code "S3".

Is this a possibility as I'm struggling?

Hope this makes sense

You can not have multiple details sections, but you can have what you want (I Think).

You would need to group things so that the lines instead of being printed in item number order get printed in either
Stock Code order so product codes are in alphabetical order.
Or by the SERVICE_FLAG so service items come first or last.

Which one to do depends on what you want to happen if you have Product Items with other codes.

The text on service lines (Including S3) is a field called TEXT and on product lines (Including M) it is called DESCRIPTION
So you need 2 sections to print each, typically this is done with ITEM_NUMBER Footers this is the normal sage format so you probably have these already.

So the Structure is
INVOICE_NUMBER
>>>>STOCK_CODE or SERVICE_FLAG
>>>>>>>ITEM_NUMBER

So if you add a SERVICE_FLAG section and put that between INVOICE_NUMBER and ITEM_NUMBER it should work

hey Bruce,

thanks for the response,

Perhaps it will be easier to illustrate what I am looking to do:



This is an example snippet of the report I want to generate - under "Check your order" - I want another list of lines from the sales order lines where the product code is "M".

Under "Check your invoice" plan there is a list of lines with product code "S3" as below




I can figure out the data stuff it's just the structure i'm struggling with - I'm not sure it's possible

Here we go...rough and ready proof of concept using the standard invoice as a basis.

the Invoice Details... I have also used comment lines on my M lines
the report designer layout

I have added the group and moved it to have it structure, dropped the footer, kept the header with different text boxes for each section, using conditional formatting to only show one, for production, I would put them on top of each other so they print in the same space, I have left them offset so you can see how it was done..
Finally the print result.

Here is the sample layout

Hi Bruce, that looks fantastic thanks for the help!

I suspected that it would involve repeating the same section and overlaying text but wasn't sure on how to implement as the report designer isn't the most intuitive.


I'll try this later today and let you know the results!