Really sorry - managed to overcome my own issue with =split(JOIN(Parameters!SalesOrderNumber.Value,","),",")

Hi,
All fixed thank you I was getting confused with setting the margins in cm and then the print preview in mm another problem solved thank you

Hi Sue,
Thanks for the above and this is what I was doing but it seems to keep reverting back to 20 x 20 x 20 x 20.
The below image is...

Thanks Sue,
Would I be correct in thinking that if your grouping on rows or columns it takes all the data in that row or column to group by? And given...

I thought I would add a snippet of my query which may help me to explain what Im trying to achieve. So below is my query
SELECT
 ...

Thanks for the input guys its really appreciated (all be it I am a little lost). My SQL knowledge is limited hence me being lost so please be patient with...

Thanks as per the solution I pulled the SQL from my reporting software as that's how I ended up designing it

SELECT "Material_Trans"."Material", "Material_Req"."Material", "Material_Req"."Material_Req", "Material_Trans"."Tran_Type", "Material_Trans"."Material_Req", "Material_Trans"."Location_ID", "Material_Trans"."Material_Trans_Date", "Material_Trans"."Quantity",...

That link will certainly help me in the future thank you. I think I've solved the issue now (well Im currently testing the output) the solution was I wasn't joining...

Sorry (and looking at your signature Im guilty... the you can lead a user to data)

Anyway so Im looking to get from the 2 tables see attachment as the formatting...

Hi Hugo,

Again thanks for taking the time to assist its really appreciated. I didn't really want to mess with the SQL server and the DB where the data is stored...