Showing posts with label accessing. Show all posts
Showing posts with label accessing. Show all posts

Thursday, March 22, 2012

Crystal Reports over network

Hi all,

I have received the following error message when tring to load a report which is accessing data over a network from sql server.

The table " could not be found.

Here is the code to try and access a number of reports;

Any help is much appreciated.
Thanks

Private Sub btnRunReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRunReport.Click

Try

MyBase.Cursor = Cursors.WaitCursor

If Me.cboReports.SelectedIndex = 0 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\1.rpt"
ElseIf Me.cboReports.SelectedIndex = 1 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\2.rpt"
ElseIf Me.cboReports.SelectedIndex = 2 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\L3.rpt"
ElseIf Me.cboReports.SelectedIndex = 3 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\4.rpt"
ElseIf Me.cboReports.SelectedIndex = 4 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\5.rpt"
ElseIf Me.cboReports.SelectedIndex = 5 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\6.rpt"
ElseIf Me.cboReports.SelectedIndex = 6 Then
crvReports.ReportSource = DataAccess.getLevyDirectory & "\7.rpt"

End If


'MsgBox("Please load pre-printed stationary into the printer.")

crvReports.PrintReport()
crvReports.RefreshReport()

MyBase.Cursor = Cursors.Arrow

Catch ex As Exception
MsgBox(ex.Message)
End Try


End Sub


End ClassOpen the report and do verify database and make sure it is pointing to the correct databasesql

Wednesday, March 7, 2012

Crystal Design view

Hi,
How can prevent regular crystal report users from accessing the design view of my reports?
Your help is appreciated
Thanks
SayedOne way is to use front end application like vb and show the report from there