Showing posts with label embed. Show all posts
Showing posts with label embed. Show all posts

Friday, March 30, 2012

Reporting Services and Barcodes

How do I embed a barcode in my report without using 3rd party software?
Thanks
SmittyOn Sep 14, 8:55 pm, "Willie Smith" <wsmi...@.triad.rr.com> wrote:
> How do I embed a barcode in my report without using 3rd party software?
> Thanks
> Smitty
The closest thing to what you are looking for is probably this add-in.
http://3d2f.com/programs/64-583-reporting-services-barcode-cri-download.shtml
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||If I am not mistaken you can also use one of the various Barcode fonts that
are available to do it.
--
SQL Server Developer Support Engineer
"EMartinez" wrote:
> On Sep 14, 8:55 pm, "Willie Smith" <wsmi...@.triad.rr.com> wrote:
> > How do I embed a barcode in my report without using 3rd party software?
> >
> > Thanks
> >
> > Smitty
>
> The closest thing to what you are looking for is probably this add-in.
> http://3d2f.com/programs/64-583-reporting-services-barcode-cri-download.shtml
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Monday, March 26, 2012

Reporting Services 2005 - Problems displaying a report via a ReportViewer control.

I have a report that displays fine in VS 2005 (in the Preview tab), and if I hit it via a URL in IE as a deployed report. However, when I embed it in a ReportViewer control for display on a web site, I get no data back for the report. I am using an Oracle database for the data source. None of the the logs in reporting services show anything wrong, there are no events in the event viewer to indicate any problems, Oracle logs also show no problems and no errors are returned to the page when the "View Report" button is clicked.

Anyone out there have a clue? I certainly don't.

Mike

The web site is executing the report viewer control with a certain (ASP.NET) user context. Most likely this account does not have any permissions to access the installation of the Oracle client software (or the Oracle client software is not installed at all on the web server).

Check this KB article for more details how to configure directory security: http://support.microsoft.com/?kbid=870668

-- Robert

|||

I thought the same thing at first, but permissions checked out fine. I found out that the problem is a rather esoteric interaction of Div and Table HTML element display characteristics during report generation (at least that's what the MSDN article says at http://msdn2.microsoft.com/en-us/library/ms252090.aspx).

The gist of it is that when you have the ReportViewer control properties set to render Asynchronously and have the height set to a '%' value (I was using 100%), the calculated height passed in the HTML is set to '0' so no report displays. You have the choice of using a fixed height and Asynchronous rendering or a percentage height and synchronous rendering.

Mike

|||

Thanks for posting your findings!

-- Robert

sql