473,396 Members | 2,002 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Selecting recordset for DataReport at runtime

I want to create a Data Report in my project. I have created a Data Environment and connect my database to it. I want to select a recordset at runtime and display as the report. So in the 'Command1 Properties' I have created an SQL Statement as the 'Sourse of Data'.I want to give a variable in that SQL Statement. eg. select * from MARK where AdmissionNo=<admno>. (I want to create the Report for the Mark details of a particular student whose Admission No which will be given at the runtime).I have defined the variable 'admno' globally in a code module.Can I do this?
Sep 16 '08 #1
1 1410
debasisdas
8,127 Expert 4TB
you ned to frame the query at runtime and pass to datareport.
Sep 16 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: carrionk | last post by:
Hi I'm trying to export an ADO Recordset generated at Runtime to a txt file. I know that you have two options for exporting Access information: 1) TransferText 2) Reading / Writing Text...
1
Awit
by: Awit | last post by:
Hello, I'm new here... I have a problem, I used DataReport in my program.. The problem is runtime error occur when i run the system, i can't make some modification at the table in database while...
6
by: klove1209 | last post by:
Good afternoon, Can someone please tell me how I can return records from a query. I have text fields that I need to obtain, and have those necessary records sent to MS Word. I need to return the...
5
by: anoopgopal007 | last post by:
Hi, I am using vb6 and datareport. I am updating the tables whle the program running. But the datareport doesnot show the updated information. Its always shows the previous value. But...
3
by: anoopgopal007 | last post by:
Hi, I am using vb6 and msaccess as back end. i want to display some report using datareport. The report printing at first time only. After i updating my table i can't get the updated...
3
by: suresh_punniyakkodi | last post by:
Hello to all, How to pass SQL Query to DataReport at Runtime... Please, Any body help for this Question... Regards, Suresh...
2
by: vishwaskothari | last post by:
when i click on the print button present on the datareport there comes the runtime error. i have checked the printer it is properly installed and working with the other softwares(like MS Word)...
1
by: MaryKJolly | last post by:
I got this sample project from a website. But there is some syntax error in the statement which contains the CDate function. I can't detect the error? Can enybody help me? SUMMARY This article...
0
by: depash | last post by:
hi, I have a data report have created through vb6, I would like to biind it to a recoprdset at runtime so as to display user specific records from the database as opposed to displaying all the...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.