Solved

Changing image width and height in CR8.5

Posted on 2008-10-07
7
551 Views
Last Modified: 2008-11-15
I have upload in a MSSql server database all the images I need, I have connected the table with CR8.5 (ODBC) and I am displaying images on my report. However, all images are displayed with the original image width & height, resulting in stretching. is there anyway to set the width and height properties of the blob field while printing records?
thank you
0
Comment
Question by:giannisg5
  • 3
  • 2
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 22659645
None that we have found.

The only solution seems to be to put several images boxes on the screen of different sizes and show the one you need for the particular image.

mlmcc
0
 

Author Comment

by:giannisg5
ID: 22659691
How do you know which image box to display? Do you suppress the rest?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22660302
I don't recall the exact solution or how the suppression was done.  

Yes, you use conditional suppression based on a field in the database.  Perhaps the image name?

mlmcc
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:giannisg5
ID: 22667392
I used vb6 and the cr85 designer in order to determine the width and height of the image. I know on which section the OLE object is and which index it is, however I cannot find how to set the width and height. Can you help?

Private Sub sect_Format(ByVal pFormattingInfo As Object)
Dim bmp As StdPicture

With sect.ReportObjects
    Set .Item(2).FormattedPicture = LoadPicture(App.Path & "\111.jpg") 'default
    If FileExists(App.Path & "\" & .Item(1).Value & ".jpg") Then
        If .Item(1).Value <> "" Then
            Set bmp = LoadPicture(App.Path & "\" & .Item(1).Value & ".jpg")
            Set .Item(2).FormattedPicture = bmp
        End If
    End If
End With

End Sub

if the section i want to access is on a subreport, how to you reference that?
thank you
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 22668878
You might try using the Format event of the report or section.

To get at a subreport you open the subreport as a report then reference it as a report.

mlmcc
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22967529
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question