Union query in CR8.5

[branch861]

I'm more familiar with Access and SQL Server. I'm very much a newbie regarding CReports. But I'm hoping you can help! I would like to combine results without linking to a query done in Access of SQL. Can you help with suggestions. Presently I have the results on the same report but one is a subreport. I would like to eliminate the subreport and combine the information within the main report. I know how to accomplish this via alternate means but unfamiliar with how to accomplish within CR. So again, any help would be greatly appreciated!

Thanks!

 

[synapsevampire]

You can make a Union Query in CR.

Go into Database->Show SQL Query and edit it accordingly.

Hopefully that's what you're after.

-k

 

[branch861]

Thank you for your response. I figured this out yesterday morning and neglected to post that I no longer needed assistance. But I truly thank you for your response.