filtering\search criteria issue

rbuser

I'm stumpted... I am trying to write a report for a medical client. I have
a table of "transactions" or "charges" that they performed for last year.

I need to "count" how many visits total the office had, and visits for
certain procedure codes and diagnosis codes.

the transactions have these fields that are pertinent to my report: date of
service; "procedure code (equivalent to an item code if i was in a non
medical environment); diagnosis code.

To count as a visit, there has to be at least one code from a "range of
procedure code(s)" - included for that days visit. however, for reporting
purposes, i need to include all other "procedure codes" for the day, not
just the "ones in the range defining the visit".

Then, after counting the visits, i will need to include the # of unique
patient count for the visit(s) that are being reported.

I am willing to pay a consulting fee to someone to help me on this - my
associate in my company has delphi experience, but neither of us have much
experience in DM ReportBuilder.

rbuser

In case i didn't mention, we are using Digital Metaphor Report Builder
product for this report.

nicocizik

Hi Harry,

Are you using a registered copy of ReportBuilder or another application
with ReportBuilder built-in?

This is more of a SQL question rather than a report one. If you are
using the data workspace to access your data (DADE) you can easily
create multiple queries based on your specifications below and custom
filter them using the Autosearch feature of ReportBuilder.

The resulting queries should look similar to the following...

SELECT COUNT(*)
FROM Transactions
WHERE Office = ...

SELECT COUNT(*)
FROM Transactions
WHERE Office = ... AND ProcedureCode = ...

etc.

rbuser

Hi Nico;
yes we have both...
harry

nicocizik

Hi Harry,

I would recommend taking a look at the main end-user demo located in the
\Demos\3. EndUser\1. Report Explorer\ directory. All of the reports in
this demo use DADE to create their datasets and many of them take
advantage of the AutoSearch feature. Seeing how these reports are
designed should give you a good starting point for creating your own.

I also recommend perhaps working through some of the DADE tutorials
located in the Developer's Guide.