Search results for query: *

Here's what I have.... Flat file with following data fields: Hospital, Category, Cases, Days, Charges, expected Payment, Actual Payment, patient type (qualifying field) Would like to add calculated fields to do: Average Length of stay, average charges/case, actual payment/case, etc. Need to...

Reports contain information that is not available for public viewing. Any other way?

Can you be more specific by what you mean about the structure of the database?

Can't get the crosstab to do more than one data element for the value. I need 12 data elements in the value section. Is there some way to develop a SQL crosstab that would be a work around on this? Not real fluent on SQL, but I'm not scared of it either.

Problem isn't getting all on one report, necessarily. What I end up getting is the "Category" and Row labels (i.e. Cases, Days, etc.) showing up for each hospital. For Example. Hospital 1 Hospital 2 Cath Cath Cases 'Data' Cases 'Data' Days...

Need some serious assistance with this. I have been trying to research in my various books how to do this, with no success. Trying to get the general output as follows in a report format... Hospital 1 Hospital 2 Hospital 3 Heart Cath (Category) % Cases for Hosp Cases Days Charges...