Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

filtering\search criteria issue

edited February 2012 in General
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.

Comments

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


  • edited February 2012
    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.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited February 2012
    Hi Nico;
    yes we have both...
    harry


  • edited February 2012
    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.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.