Showing posts with label rdl. Show all posts
Showing posts with label rdl. Show all posts

Monday, February 13, 2012

ArgumentException: Font ? cannot be found.] (Asp.net Reports)

Hi guys, i have a scary problem, i have used the rdl files of an already existing reports (sql reporting services)

and succesfully converted them (to rdlc files) to asp.net local report (using reportviewer). and it works very good

on the development server,...However, it does not work completely on test(cert) server:

i actually can load the reports, except one which has graphics in it, on the other hand i can not export any of them

(even those reports that can be loaded to a page), so please help me, the point is that i have to have a pretty much of a good idea

before i go to those test server guys, i dont have access to test server myself. i get 4 exception at once, and i get them when i want to export to pdf, not just the graphic one but also all other reports. Interesting point is that the same reports (i mean the original rdl reports on sql reportingservices)

works wel on the same server (test server), that causes me to question whether it is about lack of some font on the server

i appreciate any help or idea's, and thanks:

[ArgumentException: Font '?' cannot be found.]
System.Drawing.FontFamily.GetGdipGenericSansSerif() +207809
System.Drawing.FontFamily.CreateFontFamily(String name, FontCollection fontCollection) +116
System.Drawing.FontFamily..ctor(String name, Boolean createDefaultOnFail) +13
System.Drawing.Font..ctor(String familyName, Single emSize, FontStyle style) +77
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.CreateFont(String family, Single size, FontStyle style) +54
Microsoft.ReportingServices.Rendering.ImageRenderer.CompositionBase.CreateDefaultFontPens() +33
Microsoft.ReportingServices.Rendering.ImageRenderer.CompositionPDF..ctor(CreateAndRegisterStream createAndRegisterStreamCallback, Report report) +428
Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStreamCallback, Int32 streamPageNumber) +32
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) +29

[ReportRenderingException: An error occurred during rendering of the report.]
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions, CreateAndRegisterStream createAndRegisterStream) +70
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) +1124

[WrapperReportRenderingException: An error occurred during rendering of the report.]
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback) +1681
Microsoft.Reporting.LocalService.RenderWithDataCache(PreviewItemContext itemContext, ParameterInfoCollection reportParameters, IEnumerable dataSources, DatasourceCredentialsCollection credentials, IRenderingExtension renderer, ReportProcessing repProc, CreateAndRegisterStream createStreamCallback, ReportRuntimeSetup runtimeSetup) +1693
Microsoft.Reporting.LocalService.Render(PreviewItemContext itemContext, Boolean allowInternalRenderers, ParameterInfoCollection reportParameters, IEnumerable dataSources, DatasourceCredentialsCollection credentials, CreateAndRegisterStream createStreamCallback, ReportRuntimeSetup runtimeSetup, ProcessingMessageList& warnings) +227
Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) +235

[LocalProcessingException: An error occurred during local report processing.]
Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) +276
Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +189
Microsoft.Reporting.WebForms.LocalReport.Render(String format, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +28
Microsoft.Reporting.WebForms.LocalReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileNameExtension) +52
Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +153
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +202
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

Hi guys,

thanks to all poeple who took some time and read my post, i like to say that for a great

part i found the solution, the problem was that the application didnt have reading right to

the font folder of windows. we gave that right to it and it worked, at least the graphic and export to pdf works now very good, however, very strangely export to excel does not work,

when i find a solution for that too, i will sure let you guys know.

thanks,

ceti

|||

Hi guys again,

today when i started to work, for a reason that i dont know yet, the export to excel was working too..!!!

so i guess i dont know why i didnt work yesterday and why it works today..

thanks

ceti

Thursday, February 9, 2012

Are other vendors buying into this?

Microsoft wants to make its Report Definition Language (RDL) an industry
standard. how's that going? have other vendors bought into this yet?rob <rob@.discussions.microsoft.com> wrote in message news:<D1755B96-8E99-4199-B7CE-BAD5CCD93B47@.microsoft.com>...
> Microsoft wants to make its Report Definition Language (RDL) an industry
> standard. how's that going? have other vendors bought into this yet?
There are a couple of commercial companies that have published
designers / add ins for reporting services (Cizer & ProClarity) but
with Microsoft, there is method to their madness.
MXS bought out ActiveViews in April which I believe has a designer as
well. Look for something to come from this purchase. It is funny but
the ActiveViews web site does not have anywhere on it that tells you
how you can get their product.
Also I think that changing the mindset corportations have with regards
to delivering enterprise level solutions is what Microsoft is ttrying
to do. For instance Microsofts MOM 2005 software utilizes Reporting
Services to report against its database. You don't need to install it,
but you get out of the box reports if you use it. Where I work at
there is another major vendor, I cannot think of at this moment, that
told us that they will be using Reporting Serives in their next
release. You can expect a lot of vendors going that route. The only
question I have is that since this is only for SQL Server, what will
the
software publishers that write against Oracle, SAP, Informix etc. do.
Business Objects will be loosing some market share to Microsoft in the
SQL Server market. I know there are a lot of vendors now that pay
Business Objects to include Crystal Reports in their product. Look for
more and more of the enterprise level applications come out with
Reporting services support and reports built in.