Check these files "CR_URLSamples.exe" and "CR_WebRefresh.zip" on this web site
http://support.crystaldecisions.net/interactive/exclusive/premium.asp
Write Store procedure something like this
PROCEDURE YourStoreProcedure(
CompanyID IN Varchar2;
RecordSet_Cur OUT REF CURSOR
)
AS
Begin
OPEN
RecordSet_Cur
FOR
SELECT *
FROM TableName
Where Company_ID = CompanyID;
End;
Try to connect this type of stored procedure with...
Hi
First, why r you using ODBC for data base connection? You can connect your report directly with Access database(mdb file).
At run time using vb code specify the database path like
CrystalReport.Database="Your database path.mdb"
Accessing the database directly is the fastest way...
For this purpose Use RDC
The Crystal Reports, Report Design Component(RDC) is an in-process ActiveX DLL based on the Component Object Model (COM). Crystal Reports RDC satisfies all of your dynamic reporting needs.
Technical Support reference to the RDC examples contained in the downloadable...
Try this code hope it will work
basePath = Request.ServerVariables("APPL_PHYSICAL_PATH" ) & "\myreport.rpt"
Set session("oRpt") = session("oApp").OpenReport(basePath, 1)
To disables parameter prompting in VB so the user won’t be prompted for a value.
'CRXReport is report object in Report Design Component(RDC)
CRXReport.EnableParameterPrompting = False
We are also facing the same problem with crystal report on web.
Only solution is that don't display your report in Rpt format in report viewer, export it into PDF format then diaplay on browser.
For this purpose Use RDC
The Crystal Reports Report Design Component(RDC) is an in-process ActiveX DLL based on the Component Object Model (COM). Crystal Reports RDC satisfies all of your dynamic reporting needs.
Technical Support reference to the RDC examples contained in the downloadable file...
Try to use code something like this
use your Rpt file as action file,
<FORM METHOD=POST ACTION="YourReport.rpt">
<input type="hidden" name="username" value="yourUser">
<input type="hidden" name="username" value="yourPassword">
You develop report in your machine and set printer that was install in your machine but the same printer is not installed on server.
Install the same printer on server as on development machine then check report on web
If your using RDC for generating Crystal report in your VB appication then use below code
You can put code like this in the General Declarations section.
Dim CRXReport As New CrystalReport1
Dim CRXDatabaseField As CRAXDRT.DatabaseFieldDefinition
Private Sub Form_Load()
Currently there is no...
Yes you can,
Click Export button in you vb generated report, in export diaglog box select Crystal Report(Rpt) format and save your report copy with data.
if you have multiple databases with identical schemas and you are using VB as application to generate report dynamically then its better you develop your reports on Active Data(Field definitions Only) (.ttx file ext.)
In this case you have no need to connect your reports to database server, you...
Don't shade entire section every other row for visual appeal.
Select the field(column) which you want shaded every other row and change its color background only.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.