Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help - sub query question?

Status
Not open for further replies.

kgreer

MIS
Jul 18, 2003
155
US
I am using CR Developer V9. I am creating a web page in ASP to produce a report that displays a Bill of Material. Within the report I need to run another report within each line being printed to get some other information. The report works fine, but I just don't know how to do a call another query when writing out each line. I am using SQL. Any comments will be helpful.
 
You would do this within SQL by using a subquery, or within Crystal by using a subreport at the detail level.

A subquery would be much faster.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top