De Environment

As with Joda (prev posted topic)

I'm also having difficulty using or changing a commandtext value (or SQL String)of a grouped command object under connection1 within the DataEvironment(DE) during runtime for a given dataReport...

Does anyone have any example code that dynamically changes the SQL for a given dataEnvironment?

If the answer remains to use the ADO Recordset then how can I group items in the select so that I may perform page breaks on group items?

I have been successful in listing in the detail area of a datareport but have not had luck with getting the group header defined in a datareport for a given recordset...


Thanks for any ideas...
Stuck,
Marc

Still waiting

Just want to be able to change the commandtext during run-time for a given DEcommand within a connection definition in the DataEnvironment...

HHHEEEEELLLLLLPPPPP....

Anyone from MS want to tell me why this DE object is so unsupported?


Marc


On the other hand how can I list the following in a datareport...

fields:

item1 item2 item3 item4 item5

I want to sort by items 1,2,3 as well as break new page on them...


I want to list items 4 and 5 in the detail section and use 1,2,3 as page headers...

item1 item2 item3
_________________
item4 and item5
item4 and item5
item4 and item5
item4 and item5
item4 and item5
item4 and item5
item4 and item5
item4 and item5


item1 item2 item 3
__________________
item4 and item5
item4 and item5
item4 and item5
item4 and item5
item4 and item5
item4 and item5
item4 and item5
item4 and item5

Please help....

[Clunietp]

I don't know about the other guys here, but I don't use the DE so I can't help much, I use ADO Objects, which are much more efficient and easier to deploy than the designer run-times. Why do you use the designer instead of the objects?

Tom

From most feed back , I finding that the best way to handle this is to return to the ADO Objects... I have painted myself into a corner and thought the DE had a clean simplistic way of handling reports...

If you have any ideas on creating page breaks in datareports while using a SQL statement in the following code , I'd be greatfull...


Dim conCD As New ADODB.Connection
Dim rsCD As ADODB.Recordset
conCD.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=o:\shared\sst\access\training\training.mdb;Mode=Read|Write|Share Deny Write"
conCD.Open
Set rsCD = New ADODB.Recordset
rsCD.Open "SELECT * From LineCheck ORDER BY LineCheck.EQP, LineCheck.Base, LineCheck.ClassName ", conCD, adOpenDynamic, adLockPessimistic, adCmdText
Set DataReport2.DataSource = rsCD
DataReport2.Show


Thanks,
Marc