Unfortunately, there are multiple lines per a claim with different dates of service. If a person checks into the ER, there can be multiple claims for that one person depending on how the hospital is organized. Therefore, we group by claim number in order to summarize the totals. What makes it more difficult is if the claim is a CAP claim (under contract) or a 3rd party claim. The amounts are stored in different fields. So, we will summarize the claim by grouping it. Then we need to sort it by provider, member, claim number, from date of service. based on this, then we can determine if the patient has one admit or multiple admits.
Currently, we group the records in Crystal Reports and then export to Excel. But as we use Crystal Reports XI, it exports to Excel 2003 workbooks. There is a limitation of 65,536 records per worksheet. We have to convert the workbook to Excel 2010, copy the worksheets into one master worksheet, then perform this calculation.
I am attempting to perform all in Crystal Reports. I want to be able to summarize the claims, then sort it, then apply the formulas to determine number of admissions.
I am very much open to any suggestions...
IP Logged
