• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1283
  • Last Modified:

Crystal Reports - VB.NET - mysql ODBC Driver 3.51

Hi I have a crystal report in vb.net that works fine on my computer and one other computer in my office.  Both have the full vb.net installed.  The other computer that it doesn't work only has the framework.  What happens is all of my code is implemented and the view is set it then pops up a window asking for database connection information.  No matter what I enter in this box it still will not show the report.  I don't want this window to show....has anyone any ideas.  Here is my code to show the report  all message boxes display:

        Try
            MsgBox("starting report")
            crOrderList.Database.Tables(0).SetDataSource(DataSet1)
            MsgBox("dataset filled setting parameters")
            crOrderList.SetParameterValue("StartDate", StartDate)
            crOrderList.SetParameterValue("EndDate", EndDAte)
            MsgBox("checking for summary")
            If Summary = True Then
                crOrderList.Section3.SectionFormat.EnableSuppress = True
            Else
                crOrderList.Section3.SectionFormat.EnableSuppress = False
            End If
            MsgBox("creating report")
            CrystalReportViewer1.ReportSource = crOrderList
            MsgBox("zooming")
            Me.CrystalReportViewer1.Zoom(1)
        Catch
            MsgBox("Unable to Print Order List." & Chr(13) & "Error: " & Err.Number & " - " & Err.Description)
        End Try
        SQLDisconnect()
0
stanuf
Asked:
stanuf
  • 4
  • 2
1 Solution
 
frodomanCommented:
It looks like you're using an ado dataset as your datasource, right?  Does the other computer (non-working) have crdb_adoplus.dll on it?

frodoman
0
 
stanufAuthor Commented:
yes it does -- I found something else on the internet that said to put this in the code

            crOrderList.SetDatabaseLogon(RegSqlUser, RegSqlPassword)

I did this and it is now working....
0
 
frodomanCommented:
Also have you made sure that the other computer has access to the database and that the dataset is correctly populated?  (Maybe attach same dataset to a datagrid?)  You could be seeing a blank report because you're passing an empty dataset to the report.

frodoman
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
frodomanCommented:
Looks like we posted at the same time...   My 2nd posting was on target - because you didn't have logon credentials you were sending a blank dataset to crystal.  

Glad it's working

frodoman
0
 
stanufAuthor Commented:
I posted a question and figured out the answer on my own -- please cancel my questoin and refund me my points....thank you

http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21079624.html#11697371
0
 
frodomanCommented:
stanuf - You should post this request in the Community Support topic area (still include the link to this question though).


mod - No objection to "Delete & Refund" request.
0
 
moduloCommented:
Closed, 485 points refunded.

modulo
Community Support Moderator
Experts Exchange
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now