DataReport - How to display expression

[GROG]

Hi all... i have a set of record to display in my data report.. and i would like to use the "Select count (*) fromm XXXX " statement to count number of record that i've chosen..
The problem is.. How can i make it appear in my Data report..? Using command1 in property i've coded and tested using SQL Builder.. i paste the data field on to my report.. but it doesnt appear and some error message... e.g "Express 1000 is empty/.."
Can anyone tell me how can i solve this.. Tq

[creative1]

can u telll what you have in coded? and where it prompts you for error

[QVeen72]

Hi,

Place a Label on the datareport and Query from the VB6 Form and pass the value as a passive text..before calling the datareport to show..:

    'Write Code To Open RecordSet RST here...
    DataReport1.Sections(2).Controls("MyLabel1").Caption = (RST(0) & "")
    DataReport1.Refresh
    DataReport1.Show
 

The abive code assuming, there is no Group section, if u have any, change Section Index accordingly..

Regards
Veena

[GROG]

hi.. i have a Dataenvironment consisting a connection, 3 command, (parent, 1st child,2nd child) my aim of my report is to get a set of record based on the two table(i.e parent (group header) and 1st child(details)) .. and it went well.. (based on ur "dynamic Report " write up..thanks again)

so. now i have a set of record and, i want to put in my report , how many record affected when the query executed.. so.. i come up wif another command (2nd child) and from the property, i've selected the source of data from SQL Statement "Select Count (*) from XXXX" .. and i didn't relate it with the first child.. (tried to relate no joy..)

I paste the data field (rptTextbox) on my report.. and run it.. "datafield Command1.express 1000 not found"

[GROG]

veen, thanks, tried.. no joy.. still trying...

[QVeen72]

veen, thanks, tried.. no joy.. still trying...

did u open the connection and recset properly what SQL Query did u use..?

Regards
Veena

[creative1]

If you get count on form try to store it in a variable and then display it on report using code posted by Veena. It might work for you.

[GROG]

Hi all , this is the connection and recset used...

Conn.CursorLocation = adUseClient
Conn.ConnectionString = DEnviroPeribadi.Connection1
Conn.Open

// Query// ( "Select * from XXX where name= xxx ..") <-- this is fine.. but the problem is.. to get the count of how many rows affected.. can i paste the code here? or there's other method..

RS.Open query, Conn, adOpenForwardOnly
Set Peribadi_rpt.DataSource = RS

... did i got the rite idea..?