Associate Datareport with a table at run time
:afrog: I am making a project in which I am entering Serial no. to the records at run time. But since the project has already been started the serial no. at the time of running the datareport is not available. Rather I have to close the project and start it once again to get the serial no. for all my records.Is there any way to associate the table with datareport at run time and also how to get the field values in the datareport. :confused:
thanks.
Re: Associate Datareport with a table at run time
Re: Associate Datareport with a table at run time
Would you care to elaborate? How is the serial no. associated with the DataReport? Is it a field?
Re: Associate Datareport with a table at run time
Actually I have made a field for serial no. and at run time I am entering values to that field.
Re: Associate Datareport with a table at run time
Then those newly entered serial nos. don't show and only the old ones? How are you showing the DataReport? What is its datasource? Try using a client-side cursor...
Re: Associate Datareport with a table at run time
through "datareport.show" I am showing the datareport. Can u please tell me how to take a client-side cursor.
Re: Associate Datareport with a table at run time
datasource - it is taking from a query which I have given in the command of dataenvironment.
Re: Associate Datareport with a table at run time
What datasource are you using?
Re: Associate Datareport with a table at run time
See, I am following this method.
Firstly I have created one dataenvironment - then created one connection -and under that one command and in the properties of that command I am writing my query to take the records from the table.
Re: Associate Datareport with a table at run time
You could try something like this...
VB Code:
DataEnvironment1.rsCommand1.Requery
datareport.show
Re: Associate Datareport with a table at run time
I have just tried. Sorry, it's not working.
Re: Associate Datareport with a table at run time
Would you post your project (zipped)?
Re: Associate Datareport with a table at run time
Moved to reporting section.