Vbbeginner07
Last Activity: Dec 4 '08, 04:09 AM
Joined: Dec 10 '07
Location: INDIA
-
but im taking the values while runtime....how can i tbe like?... -
QUICK REPLY PLEASE!!!Crystal Report-sql Server-VB
Hi all,
I have an issue with Crystal report ,i have a sql db connected with the crystal report in vb.....in a list of 100 employees where i want the report to contain only those list of employees say id #.10- id #.15 by presing the report button.....
.........I would like to make my code (vb) simple and precise...I would appreciate suggestions tooo....
SQL SERVER-
... -
Hi,
but i have a crviewer,i have got errors while at runtime......
[vb code:]
Private Sub cmdRpt_Click()
Set report = crystal.OpenRep ort("C:\Program Files\Seagate Software\Crysta l Reports\report. rpt")
Form1.CRViewer1 .DisplayBorder = False
Form1.CRViewer1 .DisplayTabs = False
report.DiscardS avedData
report.Database .SetDataSource rs
ERROR:
...Leave a comment:
-
sorry for not giving the correct infm let me telll u veena,i have done the same as u explaind
.............no w i need to view the report of the employees within a range and individually
by pressing a button.....
im using sql server 7.0
my queries:
1) how do i connect sql with crystal report(7.0).... ..im gettn as a crys.report viewer.
2) is it possible to me to get report as :...Leave a comment:
-
i am after this for a couple of days please help..........
NIKHITA........Leave a comment:
-
yes i able to connect it directly and i have succeded in that,but to view this using vb6....how can i do that.....
i have a kept a "print" command button...please help me to write the code.....i have already done the rept that too directly....
please sugest me the code.
Thanks in advance.
NICK...Leave a comment:
-
that too is not connecting........Leave a comment:
-
CRYSTAL REPORT TO Sql SERVER WITH vb6.0
HI ALL,
i want to know that how to connect crystal report to Sql SERVER with vb6.0
i'm trying to get rid of this probs sine last 2 days but not succeded.
Can someone suggest me a website which does contain method ( i mean the form piccs)to connect or please give me a step by step procedure for connection between crystal report and sql server....
i hope you will help me............. ..... -
....yes i got it.....rs1 was not declared,,,,,,, ,,,,,,,,,,
Active Connection..... .......
Public conn As New ADODB.Connectio n
Public rs As New ADODB.Recordset
Public rs1 As New ADODB.Recordset
Public rsid As New ADODB.Recordset
Public rsnme As New ADODB.Recordset
Public rsdept As New ADODB.Recordset
Public rsdes As New ADODB.Recordset
Public Sub Main()
conn.Open...Leave a comment:
-
ERROR: Object Required
Please check the following code for adding records to a database:
Im getting the error:object required in the following code( which is in bold letters)
kindly go through
[vbcode]
Private Sub cmdAdd_Click()
strdep = cbodep.Text
rs.Open "select departmentno from Departments where departmentname ='" & strdep & "' ", conn, adOpenStatic, adLockOptimisti c
If Not... -
THANK you all!!!
IF I HAVE TO BOUNCE BACK THE LABEL FROM APARTICULAR POINT AND MOVES IN THE OPP.DIRECTION.. ......pLEASE hELP ME!!!
nICKLeave a comment:
-
how to use a timer control in vb6
I have placed a label in a form,i have to move the label from left to right.........h own can i do this uising a timer control........ ..???i need the interval of 1000..........p lease Check.......... ..
NICK........... -
Ok,but im using sql server...the same can be done here too???
NICK...Leave a comment:
-
Veena,i couldnt understand,what u have pointed out and the method suggested"
You can Cross-Check by Actual Querying the data in the Table "
Please explain and the code for adding records are:
[code=vb]
rs.Open "select * from empdetail Where ID='" & txtid.Text & "'", conn, adOpenStatic, adLockOptimisti c
If rs.EOF Then
conn.BeginTrans
conn.Execute "insert into...Leave a comment:
-
rs.requery is not working i have tried this,but i dont think there's a option for refreshing in sql...if any please suggest
NICK...Leave a comment:
-
not two recordsets are opened at the sametime,n tell me how a sql recoredset be refreshed???tel l me the code to refersh
NICK...Leave a comment:
-
Debasis,its not working........ .
Please go through my code n please suggest......
it allows only the first records being added,if we checks form2 that will be displayed,but if we add any records second time it is not displayed...Leave a comment:
-
Debasis not working........ .
Please go through my code n please suggest......
Nick...Leave a comment:
-
Please Check the code
THE FOLLOWING CODE INSERTS A PARTICULAR DATA INTO THE recordset WHICH IS THE FIRST FORM!!!
[code=vb]
rs.Open "select * from empdetail Where ID='" & txtid.Text & "'", conn, adOpenStatic, adLockOptimisti c
If rs.EOF Then
conn.Execute "insert into empdetail(id,na me,whours,rate, otrate) values ('" & txtid & "','" & txtname & "','" & txtwhr & "','"... -
The code displays only the first record.but???
The follwing code is of a listview where i have to a to display the id and the name from a particular table ,empdetail.
This is in the second form,dispalying id and name
[code=vb]
Private Sub Form_Load()
ListView1.View = lvwReport
ListView1.Colum nHeaders.Add , , "NAME"
ListView1.Colum nHeaders.Add , , "ID"
ListView1.Refre sh
rs.Open "select * from empdetail",...
No activity results to display
Leave a comment: