SQL sentences

lunedì 29 gennaio 2007 - 17.47

Elenco Threads

Stanze Forum

Aggiungi ai Preferiti

Cerca nel forum

aleplgr Profilo | Junior Member

51 messaggi | Data Invio: lun 29 gen 2007 - 17:47

Hi! is there a way to write SQL sentences in CR?
I've already have the SQL sentences and I'm trying to write them as Formulas but it's not easy and maybe there's a way to write them directly in SQL.
As I've been reading the only way is to connect to a Universe so you need the Enterprise version, is there another way like a SQL editor?

freeteo Profilo | Guru

6.542 messaggi | Data Invio: lun 29 gen 2007 - 22:26

hi,
i don't know if i understand exactly what u'r looking for, anyway, u can add a comand to the report so u can get all the kind of joint /union group etc... from SQL sintax, and the resultSet (all the field) are available for u in the report.
The only thing u have to do is add a "command" instead of "table" when u bind a database to the report in the wizard.Have a look at this picture:

564x393 83Kb

ciao.

Matteo Raumer
[MCAD .net]
http://blogs.dotnethell.it/freeteo

aleplgr Profilo | Junior Member

51 messaggi | Data Invio: mar 30 gen 2007 - 10:51

Thanks!! that's what i needed

Torna su

Stanze Forum

Elenco Threads

Partecipa anche tu! Registrati!

Hai bisogno di aiuto ?
Perchè non ti registri subito?

Dopo esserti registrato potrai chiedere
aiuto sul nostro Forum oppure aiutare gli altri

Consulta le Stanze disponibili.

Registrati ora !