 |
|
 |
Dear friends
I want the image be shown on special point (place) of the report, say , an image place holder is needed in the report, how can I implement it ?
|
|
|
|
 |
|
|
 |
|
|
 |
|
 |
Hi,
My problem is that : my PDF generated from Crystalreport with BlobField from dataset is too lagre.
I think to remplace the blobfield by icroleobject picture but I don't know how...
Maybe an idea ??
Thanks a lot,
|
|
|
|
 |
|
 |
Have you tried to set the following attributes for the IBlobField :
{right-click the IBlobField & select "Format Object"}
1) "Can Grow" should be deselected if you want the size to be finite & not dependant on the size of the image
(if it is selected, the crystal report will adjust the document to be enlarged according to the actual image size )
-------------- a) you could also add conditions for the "Can Grow" property (click on the button with a pen & "X" sign on it) -------------- using the "Formula Workshop - Format Formula Editor - Can Grow" tool to specify those conditions
2) "Close border on page break" should be selected
3) "Keep object together" should be selected
4) In the "Picture" tab, you can set the "Scaling", or the "Crop From" or the "Size" attributes to manipulate your image display in the report
5) you can add a special section for the image by adding subsections in the report (right click on an empty area in the report, Insert -> Section) [OR] (right-click on a section header, "Selection Expert" or "Insert section below") & then control/set the section properties {you can set "Suppress blank section" for the particular section}
Also, attempt other document type conversion (other than PDF : .doc, .rtf, .xls) & see if the same problem occurs. You can attempt to extract to formats which aren't too large & then converting those to pdf either by using macros or plug-ins or active-X components....depends on your application.
-------------Tip: When converting the document it is better using the Crystal Report Viewer; but you can also do
-------------this programmatically to be done @ run-time.
Often the case is that some design elements (from the toolbox) being not properly set cause layout inconsistencies (i had a problem with showing bi-directional text when converting the crystal report into pdf - the non-english text would be at one side & the other english text on the other with space between them in one line to mimic a justified layout but one side wouldn't appear when converted ); these could be fixed by separating elements that are of different types ( in this case creating separate textboxes for each type of text ) or other work-arounds.
For other possible solutions on how to create a blobfield for the image - check out this link: http://www.eggheadcafe.com/community/aspnet/2/10119558/converting-binary-image-to-bitmap-image.aspx
I hope this helps
modified on Tuesday, January 11, 2011 1:45 PM
|
|
|
|
 |
|
 |
i want to save a image in database & reteiv image from data base using code in vb. net
anybody pls help
thanks in advance
|
|
|
|
 |
|
|
 |
|
 |
I'm working with VS2005
how can I insert blob field in CR
Thanls
|
|
|
|
 |
|
 |
kindly read my latest post (Titled: Simple Solution - BlobField - How answered) on how to set the BlobField above - I was using VS2005 as well
modified on Tuesday, January 11, 2011 2:03 PM
|
|
|
|
 |
|
|
 |
|
 |
Hi,
How can I get rid "database login" popup which I think is related to the database definition file .ttx and ?
Thanks
HA
|
|
|
|
 |
|
 |
I found a workaround for the “logon to the data source” popup running the crystal report in case you do not know the “Server/User ID/Password/Database”.
Add 1,2,3
1. DataSet dset = new DataSet();
DataTable dt = new DataTable("idcard"); //
DataRow drow = null;
//Add columns to table collection
dt.Columns.Add("image", System.Type.GetType("System.Byte[]"));
drow = dt.NewRow();
2. dset.Tables.Add(dt);
3. dset.WriteXmlSchema("mydataset.xml");
and run the application, it will create a new XML-file(in my case) "mydataset.xml" in bin/debug and open it and change the element name or add new element name and save.Now go back to Visual Studio and add a new crystal report. If report wizard runs, select blank report.
In Field explorer right click->Database expert->Create New Connection->ADO.NET. In ADO.NET File Path chose in bin/debug/"mydataset.xml” and click finish.You can now use the crystal report without the login-popup.it works fine for me .
Huseyin Altindag
|
|
|
|
 |
|
 |
===============================================================================
'PREVIEW BUTTON --------------------------------
If InStr(Application.StartupPath, "bin") > 0 Then
Path = Application.StartupPath.Substring(0, Len(Application.StartupPath) - 4)
Else
Path = Application.StartupPath
End If
Dim pic As String = gbPictureFolder & removeSign(Me.product.Trim) & ".jpg"
If Not File.Exists(pic) Then
pic = Path & "\Image\noimage.jpg"
End If
Dim ds As New DataSet
Dim dt As DataTable
ds.Tables.Add(ImageTable(pic))
dt = ImageTable(pic)
With crReportDocument
.Load(Path & "\Report\BOMSheet.rpt")
.SetDataSource(reportTable)
pdv.Value = Me.title.Trim
pv.Add(pdv)
.DataDefinition.ParameterFields("ReportName").ApplyCurrentValues(pv)
'SETUP DIRECT DATA SOURCE TO SUBREPORT----------------------------------------
'APPLY BY USE SUB REPORT===================================
Dim srpt As New ReportDocument
srpt = .OpenSubreport("ImgReport.rpt")
srpt.SetDataSource(dt)
End With
With CrystalReportViewer1
.ReportSource = crReportDocument
.Zoom(0)
End With
|
|
|
|
 |
|
 |
How to create blob field in crystal report.
i have made a dataset in which i created a column with System.Byte() data type.But it is not working..
Plz. solve my problem its urgent.
Thanks
|
|
|
|
 |
|
 |
did u get the solutions for this?
|
|
|
|
 |
|
 |
Is there anhyone to solve my problem .its urgent.i have to complete my project with in a week.my rest of all project have completed.i have only problem with dis blob field
|
|
|
|
 |
|
 |
This might be too late but for the solution --- kindly read my latest post (Titled: Simple Solution - BlobField - How answered) on how to set the BlobField above
|
|
|
|
 |
|
 |
where can i get the blob field object? i am using vs net 2005
modified on Wednesday, November 4, 2009 10:30 PM
|
|
|
|
 |
|
 |
kindly read my latest post (Titled: Simple Solution - BlobField - How answered) on how to set the BlobField above - I was using VS2005 as well
|
|
|
|
 |
|
 |
Thank u for this article!
|
|
|
|
 |
|
 |
This is great and awsome. This solves my problem
|
|
|
|
 |
|
 |
your code is good but the lack is that u have to provide the database definition file .ttx
so could u please alert me for this file..
mattrr85@yahoo.com
|
|
|
|
 |
|
 |
for the database definition, kindly read my latest post above(Titled: Simple Solution - BlobField - How answered) on how to set the DB definition in order to create the BlobField - you won't need the .ttx file
Also refer to the post: Image in Crystal Reports without logon to database popup by Huseyin Altindag which has been posted on 15:34 20 Feb '10
|
|
|
|
 |
|
 |
Hi,
I tried the code but it didnt work. I keep getting error message "Missing 10157.jpg or nophoto.jpg in application folder"
Also I notice the database type used for the datasource of the crystal report was field definition file type.
How can I create field definition file type
Please Help
Thanks
|
|
|
|
 |
|
 |
I was told to add the jpg's to the bin folder and it worked for me.
|
|
|
|
 |