Hi friends I need help regarding Crystal Report in VS 2008 using C#
having few questions.
1)I want to know how to use same Crystal Report Viewer for Viewing
different Reports.I had work in VB6.0 so over there I used to do
following thing but I don't have much knowledge of ASP.NET so please
help how to do the same in ASP.NET.In VB6.0 I had made 1 common form
for accepting parameter for different report and accordingly I used to
pass as below in recordselection formula.I want to know how to do the
same in ASP.NET
------------------------------------------------------------------
Set CRrpt = Nothing
Select Case rptname.Name
'**(1) Requisition Letter for Chemical
Analysis***********************************
Case "rptReq_Chem_Analysis_Letter"
Set CRrpt = New rptReq_Chem_Analysis_Letter
CRrpt.DiscardSavedData
If frmrptRange.optsingleno.Value = True Then
CRrpt.RecordSelectionFormula =
"{REQ_CHEMICAL_ANALYSIS.CHEM_REQ_LETTER_NO}='" &
frmrptRange.txtsingleno.text & "'"
ElseIf frmrptRange.optrangeno.Value = True Then
CRrpt.RecordSelectionFormula =
"{REQ_CHEMICAL_ANALYSIS.CHEM_REQ_LETTER_NO}='" &
frmrptRange.txtfrmrangeno.text & "' to '" &
frmrptRange.txttorangeno.text & "'"
End If
CRrpt.Database.Tables.Item(1).SetLogOnInfo strLocalServer,
strLocalDatabase, strLocalUid, strLocalPwd
CRrpt.Database.Tables.Item(2).SetLogOnInfo strLocalServer,
strLocalDatabase, strLocalUid, strLocalPwd
CRViewer1.ReportSource = CRrpt
CRrpt.PaperOrientation = crPortrait
CRrpt.PaperSize = crPaperA4
'*********************************************************************
'**(2) Requisition Letter for Physical
Analysis***********************************
Case "rptReq_Phy_Analysis_Letter"
Set CRrpt = New rptReq_Phy_Analysis_Letter
CRrpt.DiscardSavedData
If frmrptRange.optsingleno.Value = True Then
CRrpt.RecordSelectionFormula =
"{REQ_PHYSICAL_ANALYSIS.PHY_REQ_LETTER_NO}='" &
frmrptRange.txtsingleno.text & "'"
ElseIf frmrptRange.optrangeno.Value = True Then
CRrpt.RecordSelectionFormula =
"{REQ_PHYSICAL_ANALYSIS.PHY_REQ_LETTER_NO}='" &
frmrptRange.txtfrmrangeno.text & "' to '" &
frmrptRange.txttorangeno.text & "'"
End If
CRrpt.Database.Tables.Item(1).SetLogOnInfo strLocalServer,
strLocalDatabase, strLocalUid, strLocalPwd
CRrpt.Database.Tables.Item(2).SetLogOnInfo strLocalServer,
strLocalDatabase, strLocalUid, strLocalPwd
CRViewer1.ReportSource = CRrpt
CRrpt.PaperOrientation = crPortrait
CRrpt.PaperSize = crPaperA4
'*********************************************************************
-----------------------------------------------------------------
2)When I created a report and view in browser the report is been seen
but when I m trying to print it only shows Print Oopion box and on
click of ok it shows PDF also I have read on net regarding Print Mode
either PDF or Activex so for Activex whether I need to install any
Activex only on server or also on each client machine.
Please friend send your suggestions.....
