Showing posts with label folder. Show all posts
Showing posts with label folder. Show all posts

Monday, March 19, 2012

Crystal Report with Images

Hi,
I have the images in a folder and the path is stored in a table for each record. Each record in the table is associated with a different image. I'm able to load the images dynamically in the crystal report. But when i create a Package using the Package & Deployment wizard, the images are not being displayed. Instaed the name of the images is displayed in that area.
Actually I use the OLE object to dispaly the image. and below is the code I have written

I'm using VB 6 and Crystal Reports 8.5

Private Sub Section6_Format(ByVal pFormattingInfo As Object)
If Field5.Value <> "" Then Picture1.SetOleLocation Field5.Value
End Sub

where field5 is the Path field placed in the report.

Please help. Its very very very urgent.

Thanks & Regards,
Venkatesh.Rplz tell how did u manage to change the image dynamicaly with cr 8.5....its really very urgent|||Attached is a zip file containing a sample project. Hope this will help you.

Regards,
Venkatesh.R|||Attached is a Sample project as a zip file. Hope this will help you.|||thanx a lot for ur help....i'll give it a try...bye for now..

Thursday, March 8, 2012

Crystal Report and Deployment

I have a winform application that I want to deploy.

It has a password protected Access database in the bin folder where it pulls all its information.
I have set up a crystal report to read the information and all works well when I am debugging it on my machine. Meaning it connects to the password protected database without asking what the server name, database name, or password was.

However when I deploy the application, if I click to view the crystal report, it opens a screen labeled Database Login. Asking for the Server Name, Database, Login ID and Password. However I don't want this box to pop up and just have the crystal report connect to the database deployed with the application.
The problem is that I think it is trying to look in the folder that the database was in on the computer I was developing it on.

I connnect to the database like so for the crystal report

Dim crpt_Attendance As New Attendance
Dim myTable As CrystalDecisions.CrystalReports.Engine.Table

Dim Login As CrystalDecisions.Shared.TableLogOnInfo

For Each myTable In crpt_Attendance.Database.Tables
Login = myTable.LogOnInfo
Login.ConnectionInfo.Password = "RTr@.k"
Login.ConnectionInfo.UserID = ""
myTable.ApplyLogOnInfo(Login)
Next

crptv_Attendance.ReportSource = crpt_Attendance

I have included the Access Database in the Application folder when I deploy it. And before I create the report, I have a datagrid that reads the information from this database. So I don't know why the crystal report is looking at the location from the computer I created it on and not in the application folder.

Any help is greatly appreciated as I am not very familiar with crystal reports!Make sure you don't have the Database Path hardcoded somewhere in VB or Crystal.|||I only have CR 8.5 developer, but in it you have to set the .ReportSource and you can specify the .SetLogOnInfo.
oReport.Database.Tables(1).SetLogOnInfo sServer, sDatabase, sUserName, sUserPwd

Crystal Report 8 with Vb 6.0 [parameters screen]

Hi,
I m using crystal in vb 60. and showing all the reports from a folder in the list and when user double click any report it ask for parameter which i fine

but if user click on the cancel button on paramter screen then it should exit but still it open the crystal report with blank page.

How i can stop this if user click on cancel button or can i can hide the cancel button on the parameter screen?

Thanks In advanceTry posting this question in the Crystal Reports Forum (http://www.dev-archive.com/forum/forumdisplay.php?s=&forumid=64)|||[ Moved to Crystal Report forum ]