sqlquery CRREPORT2008 visual basic 2008

[Former Member]

Hello can we define a sql request like in VB6, using the syntax : CRreport.SQLQUERY ?

I 'am working with CR2008 and VB.NET 2008.

Thx in advance.

[Former Member · Accepted solution]

Hi;

You can retrieve the SQL from a report, but you cannot change it.

To retrieve it, see: http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_d...

Changing the selection formula of a report at runtime is possible, and this would have the effect of altering the SQL of the report.

Best Regards,

Jonathan

[Former Member · Accepted solution]

thanx but your link seems to be bad

[Former Member · Accepted solution]

Try: [Link|http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes_boj/sdn_oss_boj_dev/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/scn_bosap/notes%7B6163636573733d36393736354636443646363436353344333933393338323636393736354637333631373036453646373436353733354636453735364436323635373233443330333033303331333233383330333533313335%7D.do]

If that doesn't work search for 1280515

Regards,

Jonathan

[Former Member · Accepted solution]

it doesnt work..

I want to know another think if possible, connect myCR2008 report in my VB2008 application but it seems my reports informations are readlony I cant change them..

Do you have any idea ? thanks in advance

[Former Member · Accepted solution]

What information are you trying to change and how?

Regards,

Jonathan

[Former Member · Accepted solution]

I want to changer the server,login and password like that

myReport.Load("clucre17.rpt")

myReport.DataSourceConnections(0).SetConnection("FFG_DEV", "", "fleole", "pmolik")

myReport.DataSourceConnections(0).SetLogon("fleole", "pmolik")

and other things.. but nothing works

[Former Member · Accepted solution]

Ok its ok for this... thx..

but how can I set a new sql query for my report in VB.NET ?

[Former Member · Accepted solution]

Hi; No, as I mentioned, the SQLQuery cannot be modified at runtime. You can modify the selection formula which is one way you can modify the resulting records that are returned.

Search on recordselectionformula for tips on this.

Regards,

Jonathan

[Former Member · Accepted solution]

ok its ok too..

Last question : its possible to know the number of page like ReportLatestPage ?

thx for all