stanuf
asked on
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.Table s(0).SetDa taSource(D ataSet1)
MsgBox("dataset filled setting parameters")
crOrderList.SetParameterVa lue("Start Date", StartDate)
crOrderList.SetParameterVa lue("EndDa te", EndDAte)
MsgBox("checking for summary")
If Summary = True Then
crOrderList.Section3.Secti onFormat.E nableSuppr ess = True
Else
crOrderList.Section3.Secti onFormat.E nableSuppr ess = False
End If
MsgBox("creating report")
CrystalReportViewer1.Repor tSource = crOrderList
MsgBox("zooming")
Me.CrystalReportViewer1.Zo om(1)
Catch
MsgBox("Unable to Print Order List." & Chr(13) & "Error: " & Err.Number & " - " & Err.Description)
End Try
SQLDisconnect()
Try
MsgBox("starting report")
crOrderList.Database.Table
MsgBox("dataset filled setting parameters")
crOrderList.SetParameterVa
crOrderList.SetParameterVa
MsgBox("checking for summary")
If Summary = True Then
crOrderList.Section3.Secti
Else
crOrderList.Section3.Secti
End If
MsgBox("creating report")
CrystalReportViewer1.Repor
MsgBox("zooming")
Me.CrystalReportViewer1.Zo
Catch
MsgBox("Unable to Print Order List." & Chr(13) & "Error: " & Err.Number & " - " & Err.Description)
End Try
SQLDisconnect()
ASKER
yes it does -- I found something else on the internet that said to put this in the code
crOrderList.SetDatabaseLog on(RegSqlU ser, RegSqlPassword)
I did this and it is now working....
crOrderList.SetDatabaseLog
I did this and it is now working....
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
frodoman
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
Glad it's working
frodoman
ASKER
I posted a question and figured out the answer on my own -- please cancel my questoin and refund me my points....thank you
https://www.experts-exchange.com/questions/21079624/Crystal-Reports-VB-NET-mysql-ODBC-Driver-3-51.html#11697371
https://www.experts-exchange.com/questions/21079624/Crystal-Reports-VB-NET-mysql-ODBC-Driver-3-51.html#11697371
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.
mod - No objection to "Delete & Refund" request.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
frodoman