Displaying results from Database

**Pule** · 01-19-2011, 03:51 AM

Hi,

I'm new here and am happy to be part of this forum.

I'm extracting data from the SQL Server database and displaying result on Excel for reporting purposes. There's 2 things that I would like assistance for and they are

1. There are couple of rows displayed from a specific department and I would like to see the department name showing only once in a column and not repeating itself. The only time when the department name should display again is when the sql reads a different department.

2. I would like to automatically sum values of each department and produce the totals at the bottom. The main trick for me is that number of departments varies with every run as some departments might not be processing on certain dates so I need to calculate values for each department that has processed for a specific day and display the totals.

Thank you in advance.

regards,
Pule

**alansidman** · 01-19-2011, 08:07 AM

Please post your SQL statement. Please indicate the fields that you would like to aggregate.

**BigDat6CC** · 01-20-2011, 09:42 AM

Hello Pule

One way is to progress is to make a very simple Access report for departments, with a total for each. Then use the report as the basis for export to Excel.

Keep your report very simple. In my experience, exporting complex reports can produce some weird results.

**Fo_Fa** · 01-20-2011, 05:00 PM

Yes, this is a job for access reporting.
best thing is to create a query (sounds like you have that already) and then base the report off of that.
You can set it to only display certain items when they break, and a summary line by using grouping. The report wizard should walk you through it.