Updating proc name in crystal reports

Posted by / 07-Oct-2017 19:47

Updating proc name in crystal reports

I don't have this problem wherever I used tables in the rpt instead of procedure. There is no problem with the procedure at all, this executes fine on DB and even in crystal if I don't change those properties.

--Boundary_(ID_Aj MM9in HAsw5k Vtrc Z/A8w) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT we are doing a project in VB6 sqlserver 2000 crystal reports 8.5 we setup sql for windows authentication we have designed crystal reports inside vb6 by selecting the tables from current connection the reports work fine, but if we change the server name or the database name at run time we start getting errors the following things were tried out 1.

Proc(Sp Issue To Provider Staff Kaiko)" my database name is take2 and stored procedure name is Sp Issue To Provider Staff Kaiko if you are retrieving report directly form a table you can use cr Table.location=dbo.table "databaseowner.tablename" i think the above will solve your problem Regards Ravi Shanker" id="ctl00_m_m_i_ctl00_gr_ctl05_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="414235" / DEAR ameya, cr Table.location = "take2.

The first step in creating a report is always to identify a data source.Connection 'ADO Connection User the following at run time Anyconnection.servername="current server Name" Anyconnection.databasename="your dbname" Anyconnection.uid= "window user" Anyconnection.pwd="his password" Dim cr Table As CRAXDRT. Proc(Sp Issue To Provider Staff Kaiko)" This may help you all the above line are in patches and you can understand where to use it if any doubt send mail so that i can give u reply Ravi Shanker Inaganti Senior Software Engineer Nu Net Technologies Private Limited 4th & 5th Floors, Isnar Khazana Towers Dwarakanagar, Visakhapatnam-530 016, India.Database Table 'refers to the table used for generating the report Set cr Table = rp. good morning thanks for ur reply we understood all the lines in ur reply accept the following cr Table.location = "take2.Proc(Sp Issue To Provider Staff Kaiko)" does crtable.location need the actual directory\drive location what is the meaning of 'take2.proc(Sp Issue To Provider Staff Kaiko)' pls give details regards" id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="414198" / ravi shanker good morning thanks for ur reply we understood all the lines in ur reply accept the following cr Table.location = "take2.Proc(Sp Issue To Provider Staff Kaiko)" does crtable.location need the actual directory\drive location what is the meaning of 'take2.proc(Sp Issue To Provider Staff Kaiko)' pls give details regards cr Table.location = "take2.

updating proc name in crystal reports-47updating proc name in crystal reports-88updating proc name in crystal reports-29

what we did is as follows: our report was designed on server called "XYZ" database "Accounts",connecting crystal thru current connections with SQL setup as windows Authentication we tried to change the database by the following method (as u specified) public report as new CRAXDRT.report dim crtable as CRAXDRT. Report Objects For Each o Report Object In o Report Objects If o Report Object.

One thought on “updating proc name in crystal reports”

  1. Right now you can get a 3 Day Free Trial and I suggest you take it and use it wisely! They have webcam chatrooms dedicated to specific ages and niches such as teen, adult and senior chat and religion, gay and singles chat.