Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Showing the same report layout but multiple times for different invoices Expand / Collapse
Author
Message
Posted Wednesday, April 30, 2014 1:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 26, 2014 5:00 AM
Points: 4, Visits: 56
Hi,

I am after some help and please excuse the subject description, I was struggling to think of the best way to describe what I am trying to do.

At the moment I have a report that when you select a Work Order from a drop down, you are then presented with a list of Invoices associated with that Work Order, you select the ones that you want and the report generates two groups of data shown in the report one that gives the invoice details, Labour/Parts etc grouped by Work Order and Task.

The second group of data summarises this data by section,

The Data set that is being used has everything at a task level to allow the grouping.

All this works fine, the problem that I have now is the powers that be want to be able to generate a complete copy of the report multiple times per invoice and have everything grouped at invoice level, I can change the grouping to show by Invoice but I am just left with sections duplicated in my first data but for each of the different invoices. What I want is a complete copy of the report generate at an Invoice level and grouped at an Invoice level based on each of the Invoices that I select.

Again excuse me if this has been explained badly as I can see what I want to do but not sure how to explain it in the best way to get help, if it assists I can upload a copy of the exsisting report.

Thanks in advance P
Post #1566254
Posted Wednesday, April 30, 2014 2:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:49 AM
Points: 7,087, Visits: 6,894
Are you able to provide am example of the output as it is now and what you want it to look like?

Obfuscate the data if it is sensitive.



Far away is close at hand in the images of elsewhere.

Anon.

Post #1566256
Posted Wednesday, April 30, 2014 2:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 26, 2014 5:00 AM
Points: 4, Visits: 56
Hi David,

Would a screen shot of the exsisting report help, is there a way to upload a file or image on here?

Thanks Phil
Post #1566260
Posted Wednesday, April 30, 2014 2:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:49 AM
Points: 7,087, Visits: 6,894
When you post there is a button bottom right (Edit Attachments) that will allow you to add attachments.
If you could make a mock up of what you want it to look like would enable us to see what the problem is.



Far away is close at hand in the images of elsewhere.

Anon.

Post #1566266
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse