-
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....
-
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
