Summarizing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that I need to roll-up one network to only give a "sum" of
the total billed. Also that needs to be included in that database are details
of the second network. I have both networks split out now, however both show
the detail and the one needs to just summarize billed data. How do I
accomplish this?

For example.

Claim Screening (this needs to be rolled up to just sum the billed data).
With a tag labeled 'Various'.

CRS needs to show the detail.

The network field label is NTWK_NM.

Do I need to use a subreport to roll up the claim screening? And what parts
to use for that?

Thanks
(e-mail address removed)
 
Show us some table structure information and sample records. Then how you
would like this displayed in a report.
 
For the summary that should print first page:
Customer Name
Network1
Sum of reporting sub by network, class, total sum
Total Network1 sum

Network2
Sum of reporting sub by network, class, total sum
Total Network2 sum

Page break prior to DETAIL only needed.

For the detail:

Customer Name
Network1
Detail records (by reporting sub, record #, sum of record)
Sum network detail records
Page break at every new network with (page header for customer) each page
must show customer name.

Customer Name
Network2
Detail records ( by reporting sub, record #, sum of record)
Sum network detail records
Page break at every new network with (page header for customer) each page
must show customer name.

And so on.
 
You can set up an expression in your sorting and grouping that combines some
records while keeping details on others.

"Customer Name" isn't really sample records. However a WAG might assume you
want to combine all customers with names beginning with A-G and show details
of others. Your sorting grouping expression might look like:
=IIf(Customer<="G", "A-G", Customer)
 
I've given another example below.

I need an individual report by customer, by their network (and so on) & then
their detail records report printed after the summaries. There are several
databases as well I'm getting this information. I've created a new table to
combine all the individual database tables (my networks) to run the report
with in a separate reporting database.

I'm thinking in order for this to work, I should have a subreport utilized
in the page header for the summary piece.


Summary:
ABC Company
Patient Choice (network)
Reporting sub 001 Summarized Billed amount
Reporting sub 002 Summarized Billed amount
Total Patient choice

Health clinic (network)
Reporting sub 001 Summarized Billed amount
Reporting sub 002 Summarized Billed amount

Page break before company detail

DETAIL NEEDED:
ABC Company
Patient choice (network)

Reporting sub 001
Claim # Billed amount
Claim # Billed amount
Claim # Billed amount
Subtotal reporting sub 001

Reporting sub 002
Claim # Billed amount
Claim # Billed amount
Claim # Billed amount
Subtotal reporting sub 002
Total Patient choice (network)

Page break before next nework

ABC Company
Health clinic (network)
Reporting sub 001
Claim # Billed amount
Claim # Billed amount
Claim # Billed amount
Subtotal reporting sub 001
Reporting sub 002
Claim # Billed amount
Claim # Billed amount
Claim # Billed amount
Subtotal reporting sub 002
Total Health clinic (network)
 
If you want to display summary information together and then later in the
report display the detailed information, you can
-add a subreport of summary information in the detailed report header or
-add a subreport of detailed information in the summary report footer

You mentioned "in the page header" which isn't a good idea.
 
WHat is the visual basic programming I need to pull all database tables
together to support this?

I have 7 databases, with each having a network table. how do I program this
in
 
I assume you have a good reason for 7 databases. You can link to tables from
multiple MDB files. You can create a union query that combines records from
multiple similar tables.
 
Back
Top