|
i have only 4 fields to work with
but i have made a 4 tables in one db (access database )
now i want a report on user requirements
for eg.
display materials of a particular type ?
in data environment we can see whole data on report but how to get filtered data
and that is on forms in may be a sheet form or grid form
like user can search by material no./ description /date like that
pls reply me if naybody having soln.
thanks in advance
regards kiran B.
|
|
|
|
|
I have to design a report by combining 4 related tables from the same access database.
Now the challenge is that the report is to be made user defined.....
Got confused?? Lemme put it in a simpler way..There will be a visual basic form in which user would be asked to select the fields (limited to 12 fields). When the user submits, the report containing these 12 fields will be generated along with images, header and footer.
The challenge doubles when the requirement is that after selecting the fields in the vb form, he also applies the filters for all the fields. And then the report should be generated accordingly
Does anybody has solutions on this...Ur ideas are very much welcome...
Regards
|
|
|
|
|
Hi ppl,
Firstly, I want to print an enrollment form in a certain format with some images, header and footer on it. The form should be printed once the details of enrollment are filled in a VB form and the form is submited. (The dimensions of the report would be A4 size in this case)
Also, before the form is printed in the above format, I need to display print preview in a seperate window.........
Secondly, I need to print receipts on a payroll with a logo, header and footer. The print paper would be a paper roll on a dot matrix printer
Please help me out with the solution...........
Regards
|
|
|
|
|
I have created two seperate applications in VB for a small institution having two branches. Now I have to combine them and I am facing problems in datareport/dataenvironment.
Actually I want that the same(one) datareport should display the data from two diffetent database. In codding of datareport I have tried by changing datasource and datamember properties, I have also tried creating different connection for different database but it did't work.
In runtime the datareport shows errors like Datamember not found or Failed to getting row(s).
Wating for reply.
|
|
|
|
|
I am developing a customised software for collection of students' fee. How can I create a report based on the user entery definition. I want the user to view report such as daily, weekly, monthly and yearly. I want the report to display when the user enters the date on which he want to view.
Please can someone help me explain how to create such report for the user.
Thank You.
Ifeanyi
|
|
|
|
|
hi im vasanth im also need of such type of creating data report in vb as u mentioned
help me if u got the code
thank u
my id:choco4mevas@gmail.com
|
|
|
|
|
I have created an application that uses access table as the back end. i need to search for records in the tables and then display them as a report in .txt or .xls form.( like exporting data from the access table to a excel file) this has to be done using vb code. can someone help me? PLEASE.
signing off is preci
|
|
|
|
|
your source code for data report project is of no help
because THERE IS NO DATABASE included in it!!!!!
|
|
|
|
|
"
For this project, I have used the biblio database that comes with VB6, so make sure that the biblio database is available on your machine in the directory where VB is installed.
"
|
|
|
|
|
How to update the data or add data in database using data environment? because it say run time error 3251...
"Current recordset does not support updating. this may be the limitation of the provider, or of the selected locktype"
|
|
|
|
|
i am try to develop small program bu i can not use line control on data report whern draw line in datareport but i can not modeified it's width and hight , it's thikness is not bold please help me how to bold it lines width and hight in run time or desgine time
trimurari isngh
|
|
|
|
|
Use the rptshape control u can control height and width at runtime. play a little with it's props.
use this template to control in code..
DRproduagen.Sections.Item("ReportHeader").Controls.Item(9).Caption = Format(Now, "hh:mm AM/PM")
in this case control is a rptlabel... - >Controls.Item(9).Caption ..
...
|
|
|
|
|
Thanks a lot. It help me much
|
|
|
|
|
;Pis there a way that i can connect my dataenvironment and datereport connection using code.. so that i can set app.path command to the location of the table..
thanks in advance..
kindly email me here vhinzhientt2001@yahoo.com
vhinzhiett
|
|
|
|
|
hi! i am suffered to accept input from user and print the result by data report. so,i'm happy if you send me the code you write"data report connection through coding" today.
|
|
|
|
|
Hi, this is arun,
I am developing an application which includes Datareports in VB with Access. I am getting the report on user input like daily,weekly and monthly. How to compute columnwise total in my data report?
example
Please give the code.
Urgent Please...
Thanx in advance
Arunkumar A
|
|
|
|
|
Hi,
how can I set the number of records per page that I want ?
Thanks.
|
|
|
|
|
how can set the printer to print two copies of datareport in sinle page,it means if first copy is completed on half of the page then how can i print the second copy below half of printed page
thank you
|
|
|
|
|
Hi, this is chandu,
I am developing an application which includes Datareports in VB with Access. I am getting the report on user input for the first time. But when i am trying to get another record it is giving the error message like
Msgbox "Operation can't process asthe object is already open"
How to solve this problem.
Please give the code.
Urgent Please...
Thank you
Jayachandra.c
-- modified at 6:12 Monday 2nd October, 2006
|
|
|
|
|
hi chandu
try to not opening your database while running your codes
|
|
|
|
|
my email address is "miniibrahim@gmail.com"
|
|
|
|
|
Invalid data source - ERROR
Somebody help me with my data report. I had my data environment done, created a layout for my report, then inserted a code in a button that will print preview the report. But everytime i press the button, It says it has an error: Invalid data source.
Did i miss something. I have an MSAccess database with the complete tables, then used OLE JET 3.51 and 4.0 for the connectivity but still i have this kind of error. Someone please be my savior!!!!!!!!! I need this code urgently!!!! Thanks
|
|
|
|
|
hello guys..
how to eliminiate duplicates records in combo box while retriving datas from database..help me..for ex..if i have dats in db as in country field like this
--------------
india
usa
usa
india
australia
germany
germany
----------------
i need only..india,usa,australia,germany..
plz help me..
Anamika
|
|
|
|
|
Read a little on this subject "SELECT DISTINCT ".. will save your life...
|
|
|
|
|
Hi
all my B'Gates Friends,
Plese do help me to know how to get to crystal report into my vb application.
Great ThNx in adv.
durgesh_par_sharma_123@yahoomail.com
|
|
|
|