I need to use a logo on my reports - a different image needs to be displayed for different reports.

I created a picture object but can't find a way to set the picture at run time. I am using VB.NET and CR10.

Any ideas?

Incase anyone has the same problem this is the solution:

Dim data As New DataSet()
Dim row As DataRow

data.Tables.Add("Images")
data.Tables(0).Columns.Add("img", System.Type.GetType("System.Byte[]"))

Dim fs As New FileStream("C:\test.jpg", FileMode.Open)
Dim br As New BinaryReader(fs)

row = data.Tables(0).NewRow()
row(0) = br.ReadBytes(br.BaseStream.Length)
data.Tables(0).Rows.Add(row)

br.close
fs.close

br = Nothing
fs = Nothing

' CrystalReport1 is a strongly typed report created in Visual Studio.
Dim cr As New CrystalReport1()
cr.SetDataSource(data)
CrystalReportViewer1.ReportSource = cr

you are using a non typed dataset, how you create the report without a typed dataset, I try to do this with a typed ds but the type byte from the typ ds doesnt accept the data

is htere a way to create a cryst r whitout a typed dataset? so you can create a dataset manualy and use it from the report like you are doing?? how you do that?
please be more specific with the cryst r part thanks

CrystalReport1 is an rpt that is embedded in my VB.net project - so i created it by choosing 'add new item' and then selecting 'crystal report'.

I then added another new item - an Xml schema - in the same way. Once the schema is created, right click on it and select add, new element. This is a data table so fill it with column names and data types that you need.

Then attach this data table to your report so that you can do the design work.

Hope this helps

I'm unsure what CrystalReportViewer1 is or how the image actually gets displayed on the report. You set the data to the report with the image in the data, but then how do you display that data?

Hi

CrystalReportViewer1 is a control that you can drop onto a form - to display the report to the user.

This is exactly what i did:

1. Created XSD called 'GeneralSchema'. Created table inside XSD called 'ReportHeader'. Created the element 'Logo' in the table. Logo has the datatype HexBinary.

2. Created rpt and added the 'ReportHeader' table using the Database Expert.

3. At runtime:

Dim ds as Dataset
Dim tbl As DataTable
Dim row As DataRow


Dim path As String = "C:\logos\logo1.jpg"
'i'm actually getting the logo path from a sql table but have put this here for simplicity

'create data table as 'Report Header' table in 'General Schema'
tbl = New GeneralSchema.ReportHeaderDataTable
row = tbl.NewRow()

'set logo
If path <> "" Then
Dim fs As New FileStream(path, FileMode.Open)
Dim br As New BinaryReader(fs)

row("logo") = br.ReadBytes(br.BaseStream.Length)

br.Close()
fs.Close()

br = Nothing
fs = Nothing
Else
row("logo") = ""
End If

'add the table to the dataset
tbl.Rows.Add(row)
ds.Tables.Add(tbl)
rpt.SetDataSource(ds)

Hope this helps

Insert that picture in a seperate section. In the properties of that section, (Right Click->Format Section) check the box that says - underlay following sections.

This puts the section behind all the sections that follow and so the image is displayed in the background as logo.

Gauri

I named a .xsd file "GeneralSchema" and created a table called ReportHeader just like you specified. However, when I type

tbl = New GeneralSchema.ReportHeaderDataTable

the IDE does not even recognize "GeneralSchema" as a valid object - it's not showing up. Is there some public property I have to set so it will be recognized?

Thanks for all your help!

Right click in the xsd schema (not on the table) and make sure the 'Generate Dataset' option is ticked (at bottom of list). If it is ticked then untick it and then tick it again just to recreate the dataset.

Note - if you click 'show all files' at the top of your solution explorer you should find that there is now a VB file under your xsd file.

Now try typing tbl = New GeneralSchema.ReportHeaderDataTable again. If it still doesnt recognise it try closing Visual Studio and then re-opening it.

Hope this helps!

Everything compiled great, except that the picture is not showing up. Is there a control I have to add to the rpt to make the picture appear? The only control I have so far is the CrystalReportViewer on the asp file; ie, I haven't touched the rpt file except teh link the databases. I have a feeling there must be something that needs to be added to the rpt to make the picture appear.

Thanks for your help!