|
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
|
|
|
|
|
Hi,
i am using DataReport in my VB6 applicaiton. I want to add a field giving sl no of (1,2,3..) for all records which is possible in a report created by MSACESS Report by assigning ControlSource = 1 over the group or as on whole. but no such option is avaialble in datareport of vb6 to knowledge of mine.
Kindly help me to do the above in vb6
thank you
|
|
|
|
|
Dear Sir/Madam
I am MCA Students and Working on My Project , I am Developing a Project in Visual Basic 6 and Backend SQL Server Database , some Problem is How to Write the Print code and what code i will write for DataGrid Data Printing ,I am Fetching a Problem When I am Using DataGrid in Vb Program , I want to take print out of Data Display in Grid using DataGrid ,I done Using DataGrid to Dispaly data from database using DataEnvironment , But Data is coming in DataGrid but plz write me code and tell me in detail how i can take print out of Data in Grid Format which Data is coming in Grid , I request you to Kindly Help me ,
Plz Help me ,
Regards,
Arman Ali
armanmallick@gmail.com
|
|
|
|
|
Hi All,
I merge fields from two relational tables into one command, sqlTable, in a data environment using SQL statement. Table1: cCode, Name & PhoneNumber & Table2: cCode, Paid, Date & RecieveBy. And I bound my datareport to the command, sqlTable, but the problem is, the cCode, Name & PhoneNumber are repeating on the datareport at every payment made by the same person in Table2. Anybody with idea(s) should pls help. Thx in advance.
|
|
|
|
|
hello,
I am new to VB. My question is, can I make my software such that the end users can design their own reports using a data report designer kind of interface? does Data report support that kind of a thing ?
best regards,
kane
"Some guys hack just to get themselves a girlfriend.What a pathetic reason huh ?"
|
|
|
|
|
error will occur saying that "FAILED GETTING ROWS FORM THE DATASOURCE
|
|
|
|
|
Hi,
Can anyone tell how to call VB Data Reports through ASP.NET application.
I have a VB application which have some Data Reports. At present i am calling these reports through a window application developed in VB6.0 but now i want to make these reports available online. SO what is the way out for this. Can i call these reports as it is through .net application. If yes what do i need to do for this?
Thanks
|
|
|
|
|
|
In the data report if i want to add the first field as the number series i.e. sequence number for each record, then how is it possible in project with front-end as VB6 and back-end as MS Access ?
|
|
|
|
|
place a button on the form and onclick of the button place the following code
Dim rs1 As New ADODB.Recordset
Set rs1 = CreateReport()
With DataReport1
Set .DataSource = rs1
.DataMember = rs1.DataMember
.Show
'.WindowState = 2
End With
place the below funtion in the form.
Private Function CreateReport() As ADODB.Recordset
Dim i As Integer
Dim rs1 As New ADODB.Recordset
i = 0
With rs1
.Fields.Append "SNO", adVarChar, 12
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open
for i = 1 to 10
.AddNew
![SNO] = i
.Update
next i
End With
Set CreateReport = rs1
End Function
add data report.
add textbox control in the detail(section1) of the data report
change the datafield properties of the text box to SNO
run the form.click the button.can see the s.no on the report
|
|
|
|
|
If the recordset is created from a data store, what is to be done ?
|
|
|
|
|
I have created a project whcih has reports also. The report simply works fine on my machine but not on any machine where visual studio is not installed.
Please help.
Thanks & Regards
Ashish
|
|
|
|
|
I am using vb data report
|
|
|
|
|
Hello
I want to put inside my VB6 DataReport some strings from VB code. I don't know how to do it.
In example. I want to put two dates, like the dates between I did the SQL query.
How can I do it?
Thanks in advance.
Jose A. Martin
|
|
|
|
|
i ve had a problem with the report generation in vb. What i need to do is to make a summary of data entered during a specified period. The structure is as follows;
.............................................................................
REPORT FOR DATA CAPTURED BETWEEN "DATE1" AND "DATE2"
(date1 and date2 are selected by the user)
PROVINCE No. OF RECORDS
1. xxxxxxx 99
TOTAL RECORDS: 99
.............................................................................
PLEASE TAKE NOTE THAT THE NUMBER OF PROVINCES IS MORE THAN 5.
hoping for quicker responses.
vb guru
|
|
|
|
|
Pass the dates as the parameters for the record set in the database.u write query as select * from Table where Date1>xxx and xxx>Date2.
|
|
|
|