PROBLEM WITH DRAG & DROP FIELDS TO DATAREPORT

[aggeliki23]

hello everybody!
I have created a sql query in visualdata manager of vb6
"SELECT sum(OrderDetails.ProdSumPrice) as totalSum from orderDetails group by orderID;" saved as sumPriceQry.
It calculates the sum price of all products a customer has ordered. I am trying to create an invoice report with data report. I used DataEnviroment, i added a command button and in the property window of it, in general tab, i set the connection onto connection1 (mydb), in dataObject i selected view and in object name the name of the query sumPriceQry. My problem is that i can not drag and drop totalSum into any section of my data report.
I tried design a RptTextBox but in properties window, in the DataMember there isn't the command1 to select it, to made this to representate the sumPriceQuery. Any ideas please?

Thank you
very much
Aggeliki

 

[johnwm]

aggeliki23

Have a look at faq222-2244. It explains why cross posting is discouraged, and also gives some good ideas on general forum usage. Then have a look at thread222-1338307 where I have answered this question.

all

Please post any other answers in the other thread to keep continuity

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[aggeliki23]

Thank you very much i have post my reply here thread222-1338307