correct Access reporting format

[khurram7x]

well, I'm getting crazy for on this. I'm looking to create reports which should be as close as possible to Excel sheet i'm attaching. i've used suggestion by 'plog' in Tables forum and took a single field 'Step' for all 10 steps shown in Excel sheet, and it no doubt is a right way.

Now boss want reports in format which should he as close to Excel. I've divided attached Excel sheet in two tables, 'tblSteps_Prog' and 'tblSteps'. I've used 'qrySteps' in an attempt to combine these tables and generate a CrossTab query 'qryC_Steps' to get come across Excel style a bit, but still could not completely get to the style because i still need to Sum the result at each 'Step'.

Instead of writing more complicated details, what is the best way in Access to generate kind of reports shown in attached Excel sheet?? Maybe i'm doing wrong, because i've a very little experience with Access. This is my first detailed project and i still couldn't get out of formatting still (

 

[Ranman256]

I too have met this VP/manager. You must convey to them how data is added.
The detail items are shown first, then the Subtotals are shown, then totals.
Not bass-ackwards.
You can spend a short time working the data, or lots of man-hours trying to massage data to meet the request of a person who doesnt know how databases work.
Access gives you EASY to use reporting tools. But managers need to understand this.

 

[khurram7x]

I too have met this VP/manager. You must convey to them how data is added.
The detail items are shown first, then the Subtotals are shown, then totals.
Not bass-ackwards.
You can spend a short time working the data, or lots of man-hours trying to massage data to meet the request of a person who doesnt know how databases work.
Access gives you EASY to use reporting tools. But managers need to understand this.

So how do you suggest how i deal with reporting this kind of a sheet in Database way??
Like i said, i'm not very experience with Access so I need additional guidelines in addition to advises, at this stage.

 

[JHB]

Sorry, I'm not able to open your Excel file, could you post some printscreen instead?

 

[khurram7x]

Sorry, I'm not able to open your Excel file, could you post some printscreen instead?

Attaching screenshots.
Uploading XLXS version of Excel file at Google, maybe you'll be able to open this??

https://drive.google.com/file/d/0B40aEpxbK6NfQkZ3V1I4dEJNYjQ/view?usp=sharing

Thanks.

 

[JHB]

Better ask, is it something like this you're looking for?

 

[khurram7x]

Better ask, is it something like this you're looking for?

Yes, and I achieved almost same with Cross Tables and then Reports.
At the moment, I'm stuck with totaling.When i Total all components of a Job Pack (X represent Job Pack in Screenshot 1) it works correct by Grouping on JP in header (Job Pack), but when I go further and Sum based on 'Area', it does not Sum as it should be (Total of all Job Packs). And then there's another level where Sum needs to be applied, at Project level (Total of all Areas).
I'm not looking for Grand Total at 'Area' level because, first, Grand Total cannot be in header section of the report, second, there's another level of Sum 'Project' on top of 'Area'.

I'm attaching three screenshots. Basically, Sum works like this (as you can see on top of ScreenShot 3):
X (represent Job Pack) = Sum of all components of Job Pack
Area = Sum of total of all Job Packs
Project = Sum of works in all Areas

Am i able to clarify myself please??

Thanks

Thanks,
K

 

[gemma-the-husky]

if you want an excel report, then either

a) output a query to a csv/excel
b) write code to populate an excel template

an access report just isn't a spreadsheet.

 

[JHB]

Yes, and I achieved almost same with Cross Tables and then Reports.
..

Am i able to clarify myself please??

Thanks,
K

I'll have a look at it in the weekend, just now I've some other urgent tasks.