Telerik Forums
Reporting Forum
1 answer
133 views

Hello!

I have a Silverlight application that uses Telerik reporting. Also this application uses Microsoft Prims.
After upgrading from current version of Telerik (6.0.12.215, Q1 2012 Visual Studio 2011 Refresh) to newer (11.1.17.614, R2 2017) issues occurred.
After minor changes in source code (correcting to use right namespaces) solution builds fine, even runs fine, but reports shows nothing useful (no values in parameter-binding fields). So, parameters now do not passes to reports.

This is some source code.

protected void NavigateToPermissionReport()
{
   string navigationSource = AppPages.PermissionReportView + "?" +
   string.Join("&", this.Parameters.Select(parameter => string.Format("{0}={1}", parameter.Key, parameter.Value)));
   this.EventAggregator.GetEvent<NavigateToPageEvent>().Publish(true);
   this.RegionManager.RequestNavigate(AppRegions.NavigationRegion, navigationSource);
}

 

After this piece of code “black magic” happen and execution comes directly to report’s code:

private void OnPermissionItemDataBinding(object sender, EventArgs e)
{   
    this.ItemDataBinding -= this.OnPermissionItemDataBinding;   
    this.BeginGetPermission(this.ReportParameters);
}

private void BeginGetPermission(ReportParameterCollection parameters){
    PermissionViewModel viewModel = new PermissionViewModel();
    viewModel.LoadData(parameters);
    this.DataSource = new ObjectDataSource(viewModel, string.Empty);
}

What happens between these parts of the code I can’t figure out.

So, before upgrading, parameters in ReportParameterCollection had the same values as in navigationSource, but after, parameters became null.

Why this can happen?

Thanks.

Андрей
Top achievements
Rank 1
 answered on 08 Nov 2017
0 answers
143 views

Hello, i have a report made with reporting Q3 2013 and VS 2012. When installing it on the client, it gives error 40: a connection with SQL could not be opened. The report in local is ok. that could be happening? other report in the same app are ok, with de same connection.

I'm using SqldAtaSource with connection defined in web.config.

Thank you

Mariajo
Top achievements
Rank 1
 asked on 07 Nov 2017
2 answers
408 views

Hello,

We are trying to generate the report viewer report in javascript but are having a difficult time trying to figure out what the javascript logic should be.

When we set the report source on the control tag it works flawlessly. 

For example 

<telerik:ReportViewer ID="ReportViewer" runat="server" Width="1240" Height="700" ParameterEditors-SingleSelectEditor="createSingleSelectEditor" >
        <ReportSource Identifier="Reports.Organization_Summary, Reports" IdentifierType="TypeReportSource">
            <Parameters>
                <telerik:Parameter Name="userName" Value="matt" />
            </Parameters>           
        </ReportSource>       
    </telerik:ReportViewer>

 

When we try to set the report source in javascript nothing happens.

Example

<telerik:ReportViewer ID="ReportViewer" runat="server" Width="1240" Height="700" ParameterEditors-SingleSelectEditor="createSingleSelectEditor" />

 

function displayReport()
        {
            var reportViewer = $("ReportViewer").data("telerik_ReportViewer");
            reportViewer.reportSource({
                report: "Reports.Organization_Summary, Reports",
                parameters: { "userName": "matt" },
            });
            reportViewer.refreshReport();
        }

What are we missing for the report to run when the report source is set on the client?

Matt
Top achievements
Rank 1
 answered on 07 Nov 2017
3 answers
1.0K+ views

I have an expression like reportProcessor.RenderReport("XLS", ...) which always throws an exception with message "XLS rendering format is not available" when running in Edge.js via an Electron app, but never throws when running "normally" via a WinForms app. Same assembly, same code, but different behavior.

Stack trace for the exception:

   at Telerik.Reporting.Processing.ReportProcessor.GetExtensionInfo(String format)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo)
   at [my code]

Other details about the environment:

Telerik.Reporting.dll, version 9.2.15.930

Windows 10

Excel 2016

 

What kind of conditions would cause XLS rendering to be unavailable?

It's probably important to note that this same body of code has an expression like reportProcessor.RenderReport("PDF", ...) which works totally correctly with both the Edge.js-based Electron app and the WinForms app. This expression executes a few statements before the one for XLS that fails.

I checked that the app domains of both apps are running with full trust because I suspected there might be a lack of unmanaged code permissions, but that's apparently not the problem. Both domains have full trust.

Katia
Telerik team
 answered on 06 Nov 2017
8 answers
559 views

I have failed to setup a project as instructed here:

https://docs.telerik.com/reporting/html5-report-viewer-asp-net-core-2

I have been over the instructions 10 times, the error message I receive is.

Error registering the viewer with the service.

An error has occurred.
The type initializer for 'Lock' threw an exception.

Project found here:

https://www.dropbox.com/s/8rl4hhanj5gbfc9/WebApplication2.zip?dl=0

Reafidy
Top achievements
Rank 2
Iron
 answered on 06 Nov 2017
0 answers
78 views

Hi,

 

I'm using telerik report viewer in my web application with angular2.I'm able to get the report fine in developing mode but when i try to compile angular2 code using AOT compilation i'm getting following error as attached in screen shot.can any one help me to resolve the issue

 

Thanks&Rds,

Raghu S

victor
Top achievements
Rank 1
 asked on 06 Nov 2017
3 answers
171 views
Hello.  Under IE 11 everything works great.  But on EDGE when I use dropdown list for filter it's difficult to see the list (see attachment).  Any idea?
Louis
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 05 Nov 2017
0 answers
91 views

I am looking for advise as to how to capture if a report was actually printed?

This would then be stored in a SQL database as a true/false.

Which event should I be using? Has anyone done this or have sample code?

Brian
Top achievements
Rank 1
 asked on 03 Nov 2017
0 answers
73 views

I want to display a table with width of details section. I am generating this table from code. It looks like this:

<Table DataSourceName="EquipmentListSource" Width="18.9997994280509cm" Height="1.5cm" Left="0.00010012308478036cm" Top="0.299999848604206cm" Anchoring="Left, Right" Name="table1" StyleName="Normal.TableNormal">
  <Body>
    <Cells>
      <TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
        <ReportItem>
          <TextBox Width="2.57666584246297cm" Height="0.499999970197678cm" Left="0cm" Top="0cm" Value="= Equipment.Name" Format="null" CanGrow="True" CanShrink="True" Name="textBox1" StyleName="Normal.TableBody" />
        </ReportItem>
      </TableCell>
      <TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
        <ReportItem>
          <TextBox Width="1.01970437696535cm" Height="0.499999970197678cm" Left="0cm" Top="0cm" Value="= Equipment.InventoryNumber" Format="null" CanGrow="True" CanShrink="True" Name="textBox2" StyleName="Normal.TableBody" />
        </ReportItem>
      </TableCell>
    </Cells>
    <Columns>
      <Column Width="2.57666555934389cm" />
      <Column Width="1.01970430618558cm" />
    </Columns>
    <Rows>
      <Row Height="0.499999970197678cm" />
    </Rows>
  </Body>
  <Corner />
  <RowGroups>
    <TableGroup Name="Detail">
      <Groupings>
        <Grouping />
      </Groupings>
    </TableGroup>
  </RowGroups>
  <ColumnGroups>
    <TableGroup>
      <ReportItem>
        <TextBox Width="2.57666584246297cm" Height="0.999999940395355cm" Left="0cm" Top="0cm" Value="Nazwa" Name="textBox12" StyleName="Normal.TableHeader" />
      </ReportItem>
    </TableGroup>
    <TableGroup>
      <ReportItem>
        <TextBox Width="1.01970437696535cm" Height="0.999999940395355cm" Left="0cm" Top="0cm" Value="Nr inw." Name="textBox13" StyleName="Normal.TableHeader" />
      </ReportItem>
    </TableGroup>
  </ColumnGroups>
</Table>

 

My real table has 13 columns and their initial width is computed based on initial table width.

When I generate my report as "Portait" table fills all available width. 

When I change page settings to "Landscape" cell width grows to accommodate content and table fills all available width.

But when I change page settings back to "Portait" then cell contents is not shrunk back and my table spans to three pages.

What can I do be able to switch from Portait to Landscape and back without this effect?

 

Lukasz
Top achievements
Rank 1
 asked on 03 Nov 2017
5 answers
310 views

Hi. I need to add some functionality to my application which needs to be triggered on print or export of a report(created in the standalone report designer). I've seen a page in the Telerik documentation stating the following:

"Additionally events can't be used with Standalone Report Designer report documents, because the custom code from events is not serialized in reports."

I've also noticed this behaviour through my own testing.

 

I'm wondering if there is any way that I can capture when a report is printed or exported from the Telerik Winforms Report Viewer without having to reimplement Windows print/export dialogs.

 

Thanks.

James
Top achievements
Rank 1
 answered on 03 Nov 2017
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
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?