Telerik Forums
Reporting Forum
4 answers
597 views
When no data is returned from the database, we display a no data message. In our application we are used to using the interactive mode as the default when users view reports.

However, when the data source is empty and the report viewer is in interactive mode, no headers are rendered. This means the user simply gets a very cryptic empty page.

The headers are rendered fine if there is data or if the viewer is set to page layout mode.
lse
Top achievements
Rank 1
 answered on 30 Mar 2017
5 answers
547 views

I have a report that has several SqlDataSources. Viewing the Report XML, the markup looks like the following:

<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="This is my report" Width="10.0000012715658in" Name="Detailed Report" xmlns="http://schemas.telerik.com/reporting/2012/4.2">
  <DataSources>
    <SqlDataSource QueryDesignerState="null" ConnectionString="connection_string_here" ProviderName="System.Data.OracleClient" SelectCommand="select statement goes here" Name="a name goes here1">
      <Parameters>
        <SqlDataSourceParameter DbType="String" Name="Work_Week" />
        <SqlDataSourceParameter DbType="String" Name="name" />
      </Parameters>
    </SqlDataSource>
    <SqlDataSource QueryDesignerState="null" ConnectionString="connection_string_here" ProviderName="System.Data.OracleClient" SelectCommand="select statement goes here" Name="a name goes here2" />
    <SqlDataSource QueryDesignerState="null" ConnectionString="connection_string_here" ProviderName="System.Data.OracleClient" SelectCommand="select statement goes here" Name="a name goes here3" />
  </DataSources>
  <Items>
  </Items>
  <PageSettings PaperKind="Letter" Landscape="True" ColumnCount="1" ColumnSpacing="0in" ContinuousPaper="False">
  </PageSettings>
  <StyleSheet>
  <Filters>
  </Filters>
  <Sortings>
  </Sortings>
  <Groups>
  </Groups>
</Report>

 

The problem is when I am try to use this code to change the connection string, it only appears to change the string for the <Report> tag. The 3 SqlDataSources appear to be private members of the object when I look at it while debugging and those connection strings are not modified by the code. I need those modified by code. The only way I have found to do this is to treat the XML as regular XML and replace those node's attributes with the proper strings instead of using the Telerik class properties/methods. This doesn't seem right, so I assume there is a way to set these connection strings properly.

Stef
Telerik team
 answered on 30 Mar 2017
2 answers
368 views

I have a report that gets created dynamically. The report houses a Line Graph. The number of Line Series for this Graph can only be determined at run-time. I am able to add the Line Series to the graph dynamically, however, all the values in the LineGraph are same. Can you tell me how can I create a series and set the 'Y' value of the LineSeries?

In case of Telerik Web UI LineSeries, I can create a CategorySeriesItem, assign it values and then add it to LineSeries. However, no such facility seem to exist for Telerik Reporting LineSeries.

Here is my Reporting Code after InitializeComponent().

foreach(var obj in MyList)
{
Telerik.Reporting.LineSeries ls = new Telerik.Reporting.LineSeries();
ls.Name = obj.Name;
...
...
  foreach(var subObj in obj)
  {
     // How do I assign a series of values such as {100,105,109,..} to ls.Y ????
  }
graph1.Series.Add(ls);
 
}

Stef
Telerik team
 answered on 30 Mar 2017
4 answers
525 views
When the report is displayed showing the following message: "An error has occurred while processing the report. Processing canceled. Check the InnerException for more information. Invalid value of report parameter 'epnServiceConId'."

If you can do so at the very beginning was showing: ITextResources.ReportParametersAreaValidationError ?
Katia
Telerik team
 answered on 30 Mar 2017
5 answers
401 views
I have used textbox and that textbox is splitting into another page and the problem is I have applied alignment justify but in one page it shows line with spacing (for ex. If I have 3 words in a line it shows one work left one centre and last is at right.
I have kept
KeepTogether = true
CanGrow = true
CanShrink = true

I am attaching image of the same.
Please help me out.
Stef
Telerik team
 answered on 30 Mar 2017
9 answers
884 views

I want to inject an interface into my Report instance, using my IOC container.

This interface will be used by the report to get data,

ex:

IQueryHandler<GetMyReportQuery, IEnumerable<MyReportData>> _queryHandler = <injected instance>.

IEnumerable<MyReportData> data = _queryHandler.Handle(new GetMyReportQuery {

param1 = <param1 enterred by user>,

param2 = <param2 enterred by user>,

});

 

I've seen somewhere suggested to use a custom report resolver, and instantiate an InstanceReportSource within, but this is no use as parameters are not available in the custom report resolver.

I've seen also suggested to use an ObjectDataSource, but it doesn't work as it needs a parameter less constructor to instantiate the business object, which prevent me from injecting my dependencies in the constructor.

So I'm a bit clueless how are we supposed inject our dependencies with Telerik reporting.

Please advise, thanks.

Stef
Telerik team
 answered on 29 Mar 2017
19 answers
417 views
Hi there, 

I am upgrading both my WPF and Reporting controls from 2013Q1 to 2014Q1, the entire solution is not built, and if I add the version redirect, the report is not showing anything.My report view is so simple, is there anything I need to code for the 2014Q1 reporting? following is my xaml code:


<Window
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:tr="http://schemas.telerik.com/wpf" xmlns:Report="clr-namespace:LavaBid.WinApp.Report" x:Class="LavaBid.WinApp.View.ReportView"
        Title="Jumbo Loan Strat Report" Width="1200" Height="800">
    <Grid>
        <Label Content="{Binding TestText}" Margin="0,86,-8,-42" Width="{DynamicResource {x:Static SystemParameters.MaximizedPrimaryScreenWidthKey}}"  />

        <tr:ReportViewer HorizontalAlignment="Left" Margin="10,10,0,0" VerticalAlignment="Top" ReportSource="{Binding ReportSource}" Width="1160" Height="700" />
    </Grid>
</Window>
Stef
Telerik team
 answered on 29 Mar 2017
4 answers
182 views

Hi all gurus,

I'm using for the first time ASP.NET ReportViewer in a Web Application. Things work fine, but the visualization of the viewer is screwed up. I walked thru several complaints of the same flavour, and I see my web.config is set up correctly (if it were not, and I tried changing it, visualizazion of the report is not viewable on my reportviewer page). Actually, when I surf thru my Pc (Firefox and Chrome) things are worse than with my smartphone. Report is generated and viewed the right way, but buttons which are virtually unrecognizable (i.e. unfocused and much bigger than the right way).

Any clue? I'd be very grateful if someone could help me anyway.

Saverio Tedeschi

web.config relevant rows:

    <compilation debug="true" strict="false" explicit="true" targetFramework="4.0">
      <assemblies>
        <add assembly="Microsoft.Build.Framework, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
        <add assembly="Telerik.ReportViewer.WebForms, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE" />
        <add assembly="Telerik.Reporting, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=A9D7983DFCC261BE" />
        <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
      </assemblies>
    </compilation>

...

  <system.webServer>
    <modules runAllManagedModulesForAllRequests="true" />
    <handlers>
      <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=7.2.13.1016, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode" />
    </handlers>
    <validation validateIntegratedModeConfiguration="false" />
  </system.webServer>

Stef
Telerik team
 answered on 29 Mar 2017
1 answer
281 views

Hi,

I have relational data in State & City format. Using reports parameters I see these issues.

(1) I can not have parameter having "ALL" in state parameter as selection and based on that cities selected automatically.. if any coding needed I dont know and not interested.

(2) I can not have only single State selection as I must select filtered city or cities to send it to report filter to get data only for the city.. I do not want customer to select multiple states.. as of no use in my case

so here is what I am looking..

By default report launch will ALL data

(1) one parameter for state (combo box) where single selection will be done and based on it applied filter will work on the report data

(2) have two parameters for state (single selection combo box) and City (single selection combo box)..based on selected state.. all cities will be listed and user chooses single city and that will work on different filter ..

is this possible at all? I mean independent parameters working on report data using independent filters?

 

Regards

 

Katia
Telerik team
 answered on 29 Mar 2017
1 answer
353 views

What determines the order when multiple items are docked inside a container?

For example, if I I have 3 items docked to the top of the container, how do I move one item below the other? 

Stef
Telerik team
 answered on 29 Mar 2017
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?