Anyone here any good at report builder?
I have a sub-report that needs to run a DISTINCT Query and loop over its
output and run another query to get more info from the DISTINCT values from
the first. Easy to do on CFM page and in many different ways. But I can't
seem to get it to work in Report Builder.
Under ReportQuery's Advanced area I have the following.
The BillReview ID is passed in the URL String..
<cfquery name="QryGet" datasource="#App_DataSource#">
SELECT DISTINCT tblBillItems.ReasonCode
FROM tblBillItems
WHERE tblBillItems.BillHeaderID = '#BillReviewID#'
</cfquery>
<cfset Output = "">
<cfloop query="QryGet">
<cfquery name="QryGetDesc" datasource="#App_DataSource#">
SELECT BillItemReasonDescription
FROM tblBillItemReasons
WHERE BillItemReasonCode = '#ReasonCode#'
</cfquery>
<cfset OutPut = "#OutPut#<br>
#ReasonCode# #QryGetDesc.BillItemReasonDescription#">
</cfloop>
Any ideas? I have looked all through many sites and see know help on
advanced abilities of Report Builder.
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332875
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
