Solved

printing blob field

Posted on 2004-09-29
8
1,041 Views
Last Modified: 2008-01-09
i have a vb.net application with a drawing tool that will be used on tablet pc's. the image is then printed on a crystal report through a dataset and blob field. the problem is that if very little is written in the drawing section of the application, the text displays very very large on the report to fill the size of the box of the blob field. can this be changed? i am also not displaying the report, but am printing it directly so i'm not using the crystal report designer.
0
Comment
Question by:coletteck8
  • 4
  • 4
8 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 12180272
This may be helpful: http://support.businessobjects.com/library/kbase/articles/c2003171.asp

You should be able to apply the AutoSize property.

frodoman
0
 

Author Comment

by:coletteck8
ID: 12180364
i did see that article, but i'm using .net and am Not using the report design component
0
 

Author Comment

by:coletteck8
ID: 12180375
so i wasn't sure how to apply it to my situation or even if i could
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12180518
Assuming you're using Visual Studio you have the RDC as part of the Crystal runtime library and this code will work the same for VB.Net as it does for vb6.

Unfortunately that's the only way to do it - the .Net designer doesn't expose properties for images that will allow you to directly set the size mode - you have to write code to handle it yourself.  

frodoman
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:coletteck8
ID: 12180565
then do you know how i might use that code with my code below? i'm not loading the image directly, but instead am using the array with a dataset.
If Not ipNotes.Image Is Nothing Then
            Image.FromStream(ipNotes.Image).Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg)
            ds.Tables.Add("Images")
            ds.Tables(0).Columns.Add("ImageColumn", GetType(Byte()))
            row1 = ds.Tables(0).NewRow()
            row1(0) = ms.ToArray()
            ds.Tables(0).Rows.Add(row1)
            ds.Tables.Add(dt)
            ds.WriteXmlSchema("c:\PSI\reportschema.xsd")
            cr.SetDataSource(ds)
0
 
LVL 42

Accepted Solution

by:
frodoman earned 250 total points
ID: 12180756
You'd have to use RDC and LoadImage in order to get this to work.  I guess the simple answer is that without re-writing your report code, you can't change the image size - your call if the current format is bad enough to justify the effort of changing all of your code.

frodoman
0
 

Author Comment

by:coletteck8
ID: 12180859
well that's what i was wondering.....if there was any other way around that. unfortunately, i'm loading the image straight from the control and not the db, so i'm not sure what will happen. but thanks for the help.
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12180973
Yea, I doubt it's going to be worthwhile to alter your code but at least you know how if the situation ever arises again...

Good luck!

frodoman
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now