Insert SQL directly into CR11 2

[drgsolutions]

Is there anyway to insert SQL directly into CR11 and by pass having to create it by using the CR experts?

Thanks

 

[Turkbear]

Hi,
What version CR? What Database and Connection method?

You can use a Command Object and create your own sql..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Directly below the data source in the Database->Database Expert you'll see Add Command.

Place the SQL there in lieu of using tables.

The downside is that youcannot use multi-value parameters, as onemight expect from stored procedures and SQL in general.

-k