I need to expose a tif image as part of my report. Anyone know if
 this is possible and if so how to do it?
 Thanks,
 JasonI didn't get an answer so I did the next best thing. I converted the
tiffs to gifs and replaced my result set:
 Protected Sub butSubmit_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles butSubmit.Click
 ' Get the table adapter
 Dim exceptionAdapter As New
Automated_BillingTableAdapters.vw_GetExceptionsWithChargesTableAdapter
 ' Get the Table
 Dim ExceptionTable As
Automated_Billing.vw_GetExceptionsWithChargesDataTable = _
exceptionAdapter.GetExceptionsByTypeandDate(ddlExceptionTypes.SelectedValue,
tbExceptioBegin.Text, tbExceptionEnd.Text)
 ' Start a new table to handle the results with the altered
image path
 Dim NewExceptionTable As New
Automated_Billing.vw_GetExceptionsWithChargesDataTable
 ' Process the rows from the original table
 For Each row As
Automated_Billing.vw_GetExceptionsWithChargesRow In ExceptionTable
 ' Get the original image path
 Dim FilePath As String = row("ImagePath").ToString
 ' Check to see if file exists
 If My.Computer.FileSystem.FileExists(FilePath) Then
 ' File exists
 ' Get the image
 Dim imageFile As Image
 imageFile = Image.FromFile(FilePath)
 ' Get the pages
 Dim frameDimensions As FrameDimension = New
FrameDimension(imageFile.FrameDimensionsList(0))
 Dim NumberOfFrames As Integer =imageFile.GetFrameCount(frameDimensions)
 ' Process the pages
 For intFrame As Integer = 0 To NumberOfFrames - 1
 imageFile.SelectActiveFrame(frameDimensions,
intFrame)
 ' Create a path for the new file for the page
 Dim sPath As String
 sPath = FilePath.Remove(FilePath.Length - 4, 4) &
"-" & intFrame.ToString() + ".gif"
 ' Check to see if the image already exists for the
page
 If Not My.Computer.FileSystem.FileExists(sPath)
Then
 ' Image does not exist
 ' Create page image
 Dim bmp As System.Drawing.Bitmap = New
System.Drawing.Bitmap(imageFile, 493, 639)
 bmp.Save(sPath, ImageFormat.Gif)
 bmp.Dispose()
 End If
 ' Create a new row for the page
 Dim NewRow As
Automated_Billing.vw_GetExceptionsWithChargesRow =NewExceptionTable.NewRow()
 ' Copy the orginal row info to the new row
 NewRow.ChargeCode = row.ChargeCode
 NewRow.ChargeCodeMod1 = row.ChargeCodeMod1
 NewRow.ChargeCodeMod2 = row.ChargeCodeMod2
 NewRow.ChargeID = row.ChargeID
 NewRow.CodedDate = row.CodedDate
 NewRow.Coder = row.Coder
 NewRow.DxCode = row.DxCode
 NewRow.DxID = row.DxID
 NewRow.ExamDate = row.ExamDate
 NewRow.ExceptionDate = row.ExceptionDate
 NewRow.ExceptionType = row.ExceptionType
 NewRow.ExceptionTypeID = row.ExceptionTypeID
 NewRow.Patient = row.Patient
 NewRow.PlaceOfService = row.PlaceOfService
 NewRow.ReportID = row.ReportID
 NewRow.ReportStatus = row.ReportStatus
 NewExceptionTable.Rows.Add(NewRow)
 ' Set the new row's image path to the new file
 NewRow.ImagePath = "file://" & sPath
 Next
 ' Clean up
 imageFile.Dispose()
 End If
 Next
 ' Replace the datasource for report viewer
 ReportViewer1.LocalReport.DataSources.Clear()
 ReportViewer1.LocalReport.DataSources.Add(New
Microsoft.Reporting.WebForms.ReportDataSource("Automated_Billing_vw_GetExceptionsWithCharges",
NewExceptionTable))
 ReportViewer1.LocalReport.Refresh()
 End Subsql
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment