CF Report Builder - multiple queries

Question

I am a CF developer who has worked a fair bit with coding
reports manually. Have taken the plunge with report builder and
generally like what I see, BUT am quite disappointed with an
apparent lack of documentation or tutorials on complex reporting
techniques.

I need to do a report which ideally requires two queries, the
results of which the report's purpose is to compare.

The problem is, from what I can tell, a .CFR can only have
ONE query (which I find odd). Can anyone suggest a way of being
able to have more than one query result set passed into a .CFR.

I am starting to wonder that CF Report Builder might be great
for fairly basic, single data set reports, but no good for large
complex reports. I would be interested in hearing others opinions
on this.

Many Thanks in Advance.

jjay · Answer

Thanks tmschmitt. You are right in that I am (was) stuck on passing in multiple queries. What I have managed to do is use the Advanced option of the query builder to write my two seperate queries, then combine them into one recordset by doing a Query on the Queries. Not sure if this is the best way around it, but it seems to be working fine. Problem now is that I need to manually craete 500+ "Query Fields" (yuk).

I haven't really delved into the sub-reports yet, but have a feeling they won't meet my current needs. Basically i have 253 columns of demographic data. I need one recordset (A) with this data from one geographic location with a recordset from a different location (B). I then need to lay out the data with each field from B beside it's corresponding field from A. In short, it is a comparitive report whereby the reader can compare a given value (e.g. avg income) from one area with that from another. This would be fairly straightforward in a scripted report, but with Report Builder appears to be quite cumbersome and potentially unmanagable as I need to handle each field explicitly (rather than looping over recordsets and structures to generate the different sections of the report).

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded