RoyBaird
Posts: 115
|
| Posted: 12/01/2009, 1:26 PM |
|
I have a "summary" report that links to a detail report via a field named "claim_no". The query in the detail report is a custom query so I could add some fields together and only report the sums. In the query builder, I can run the SQL statement with a claim_no and it works fine, but when I call the detail report from the summary, I get no records. I have looked and looked at this beast. Here is the sql statement....
select claim_no, service_line,provider_name,date_from,date_thru,notcov_sit,amnt_billed, (amnt_not_covered + amnt_ineligible + amnt_duplicate +
amnt_serv_not_cov + amnt_pended + amnt_not_resp + amnt_cutback + amnt_visit_limit + amnt_xs_benefit + amnt_xs_annual + amnt_xs_life ) as not_covered,
amnt_ppo_savings, (amnt_deductible + amnt_copay) as ded_copay, amnt_paid from src_nrdtl14 where claim_no = '{src_nrdtl12_claim_no}'
I copied and pasted the url parameter from the browser address line to make sure I had not fat fingered it : ed/claims_filed_dtl.php?src_nrdtl_claim_no=2.
Just need fresh eyes to have a look....
thanks in advance....
_________________
Roy |
 |
 |
damian
Posts: 838
|
| Posted: 12/01/2009, 3:13 PM |
|
try hard coding the value 2 into your query and check that works - if it does then your report is not successfully getting the value from the url....
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
RoyBaird
Posts: 115
|
| Posted: 12/01/2009, 4:49 PM |
|
If I put a default claim_no, it brings up the records. If I pass it in the URL, it does not. Very odd.....
_________________
Roy |
|
|
|
RoyBaird
Posts: 115
|
| Posted: 12/01/2009, 5:22 PM |
|
can you say FAT FINGER??? src_nrdtl_claim_no should have been src_nrdtl12_claim_no.
_________________
Roy |
|
|
|
damian
Posts: 838
|
| Posted: 12/01/2009, 9:53 PM |
|
FAT FINGER!
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
|
