Telerik Forums
Reporting Forum
3 answers
607 views
1 page report with drill down.
Runs just fine locally. On the server I get:

[ExternalException (0x80004005): A generic error occurred in GDI+.]
   System.Drawing.Image.Save(Stream stream, ImageCodecInfo encoder, EncoderParameters encoderParams) +811673
   Telerik.Reporting.Processing.Imaging.ImageUtils.ResolveImage(Image image) +200
   Telerik.Reporting.Processing.Imaging.ImageUtils.GetImageData(Object value) +63

[InvalidOperationException: Invalid image data.]
   Telerik.Reporting.Processing.Imaging.ImageUtils.GetImageData(Object value) +353
   Telerik.Reporting.Processing.Imaging.ImageContainer..ctor(Object value) +17
   Telerik.Reporting.Html5Rendering.Writers.Html.Element.CreateToggleAdorner(IAdornerAction adornerAction, IInteractiveItem item, ElementPageInfo pageInfo) +975
   Telerik.Reporting.Html5Rendering.JavaScriptActionsWriter.WriteAction(IAction action, XmlElement xmlElement, Func`1 getToggleVisibilityElement) +867
   Telerik.Reporting.Html5Rendering.Writers.Html.Element.Begin(LayoutElement element, ElementPageInfo pageInfo) +720
   Telerik.Reporting.Html5Rendering.Writers.Html.TextBox.Begin(LayoutElement element, ElementPageInfo pageInfo) +279
   Telerik.Reporting.Html5Rendering.Writers.Report.WriteStartElement(LayoutElement element, ElementPageInfo pageInfo) +208
   Telerik.Reporting.Paging.PageElementLayer.AddToPage(IPageHandler handler) +91
   Telerik.Reporting.Paging.PageElementManager.AddToPage(IPageHandler handler) +42
   Telerik.Reporting.Paging.PageCompositionBase.SendPhysicalPages() +66
   Telerik.Reporting.Paging.PageCompositionBase.OutputPage() +576
   Telerik.Reporting.Paging.PageCompositionBase.CreatePages() +564
   Telerik.Reporting.BaseRendering.RenderingExtensionBase.Render(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback) +595
   Telerik.Reporting.Processing.ReportProcessor.RenderCore(ExtensionInfo extensionInfo, IList`1 reports, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback) +1348
   Telerik.ReportViewer.WebForms.ReportPageOperation.RenderReport(String format, IList`1 processingReports, Hashtable deviceInfo, IRenderingContext renderingContext) +100
   Telerik.ReportViewer.WebForms.ReportRenderOperation.PerformOperationOverride() +361
   Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context) +218
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +913
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +165
Stef
Telerik team
 answered on 20 May 2015
1 answer
229 views

Hi there

I want to add a combobox into the Reportviewer Toolbar so that i can change the size (A0,A1,A2 ....) from the Report which is displayed.

Until now i have added the following into the Telerik.ReportViewer.Wpf.xaml

<telerikInput:RadComboBox x:Name="PapersizeCb" 
                          ItemsSource="{Binding PaperSizeList}" 
                          SelectedItem="{Binding SelectedPaperSize}">
</telerikInput:RadComboBox>

My Problem is that i don't know how i can modify the Viewmodel of the Reportviewer to bind my Properties.

 

The version of Telerik I'm using is Q3 2014 SP1.

 Regards

 

Stef
Telerik team
 answered on 20 May 2015
5 answers
198 views

I am using MVC Telerik Reporting. I have added parameter using Report Source, when I see html page it seems parameter are added but when I try to access it on code side in NeedDataSource Event, that time I get Paramter Collection is NULL.

 

1.) Add this Report Source in Report Viwer

var reportSource = new TypeReportSource() { TypeName = typeof(MBOProReportBook).AssemblyQualifiedName };
reportSource.Parameters.Add(new Telerik.Reporting.Parameter("OrganizationID", SessionHelper.LastSelectedOrganization.OrganizationID));
reportSource.Parameters.Add(new Telerik.Reporting.Parameter("Organization", SessionHelper.LastSelectedOrganization));

 

2.) Use Following to access parameters but getting NULL in parameter collections

private void IssueReport_NeedDataSource(object sender, EventArgs e)
{
Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
            Organization organization = (Organization)report.Parameters["Organization"].Value;
           string organizationid = (string)report.Parameters["OrganizationID"].Value;

}

Stef
Telerik team
 answered on 19 May 2015
1 answer
646 views

I have this in a text box on the page footer of a very simple 1 page report to count the rows displayed.

RowCount: {Count(Fields.AccountNo)}

Why is it always returning 0, not sure what I am missing. Is there somewhere I can look to see a working example. 

 

Stef
Telerik team
 answered on 19 May 2015
3 answers
83 views

We are in the process of adapting our Winform application into a MVC Web Application and we have Telerik Reports that we use to generate Invoices and Statements which we attach to emails.

 

Ideally we would call a stored procedure while passing an Id, from there we would call the sp_send_dbmail stored procedure and pass it the file attachments and other data gathered using the Id which would make our sp call look like this:

    EXEC msdb..sp_send_DBMail
    @profile_name ='Profile'
    ,@subject = @Subject
    ,@body = @Body
    ,@recipients= @Recipients
    ,@body_format = 'HTML'
    ,@reply_to = @ReplyTo
    ,@file_attachments = 'C:\Report\Invoice 123'

Nasko
Telerik team
 answered on 19 May 2015
1 answer
524 views

I have a Report based on a database table. I have interger fields in the table (0 for false and -1 for true). These fields should be represented in report as checkboxes.
How can I bind the columns for checkbox state (checked/unchecked).

I am using following expression for the Value property of the checkbox, but the checkstate is not changing.
= IIf(Fields.col1< 0, True, False).

Or.......should I put this in the properties: "Truevalue" or "FalseValue"=

What am I missing?

 Thanks!

 

J. David

Nasko
Telerik team
 answered on 19 May 2015
14 answers
427 views
With the ASP.Net report viewer, the date picker for a date parameter has no styles, it's just using the ugly default browser fonts.  I tried setting the skin of the reportviewer control, but didn't affect it.  Is this a bug?  Seems like it should look exactly the same as the RadDateInput date picker.
Will this be fixed, or is there anything we can do about it?
Stef
Telerik team
 answered on 19 May 2015
1 answer
320 views

Hi

I'm stuck.

Here are my steps:

1 Open Report Designer

2. New Report; Pick tabular

3. Choose a datasource > Add New Data Source... Pick Open Access Data Source... OK

4. Choose data connection> (I add a new sql connection and test that I can connect)

5. I save the connection

6. Choose an Object Connection.

The context is empty

The message says ' make sure your current project is built for the types to show up in the list'.

How do I "build the project" from Report Designer, or from within the wizard?  

 

Thanks

 

 

 

Stef
Telerik team
 answered on 19 May 2015
2 answers
80 views

Hi,

I am trying to do some simple math for a report and it works fine in vs2012 and in the Telerik Reporting SQLDataSource when I execute the query.

However I cannot access the results because the Data Explores gives me the following error.

System.Data.SqlClient.SqlException (0x80131904): Operand data type nvarchar is invalid for subtract operator.

Here is the code:

SELECT
  CASE
    WHEN (@RowsTotal IS NULL OR
      @RowsTotal = 0) THEN 0
    ELSE ((@Rows1 + @Rows2 + @Rows4) * 1.0/ (@RowsTotal - @Rows8)) * 1.0
  END AS 'Permanency Discharges %'
, CASE
    WHEN (@RowsTotal IS NULL OR
      @RowsTotal = 0) THEN 0
    ELSE ((@Rows6 + @Rows7) *1.0 / (@RowsTotal) *1.0)
  END AS 'Insufficient Resources %'

All of the variables are initiated as a float in SQL but as a double in Telerik Reporting.

The values of the variables are:

@Rows1 = 5

@Rows2 = 11

@Rows4 = 12

@Rows6 = 2

@Rows7 = 7

@Rows8 = 2

@RowsTotal = 47

If I replace the variables in the SQL with their values it works in Telerik Reporting.

Any help is greatly appreciated.

Andy

andy
Top achievements
Rank 1
 answered on 18 May 2015
1 answer
289 views

How do I programmatically set the datasource for a graph? I've created the NeedDataSource event handler and it gets called but I cannot work out how to cast the sender in order to set the datasource:

void graph1_NeedDataSource(object sender, EventArgs e)
{
                (sender as Telerik.Reporting.Processing.?).DataSource = GetGraphData();

I've tried casting to a Telerik.Reporting.Processing.Chart and a Telerik.Reporting.Processing.DataItem both of which do not work. The object appears to be a Telerik.Reporting.Processing.Graph but that is not accessible.

 

TIA

Nic

 

Nasko
Telerik team
 answered on 18 May 2015
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?