Telerik Forums
Reporting Forum
1 answer
215 views
Pdf report is showing correct format of the dataset, but exporting to excel has too many hidden rows and columns. How to resolve this?
Peter
Telerik team
 answered on 24 Apr 2013
5 answers
441 views
In my report, I have a group footer that contains subtotals for the group. I would like to ensure that it is always printed on the same page as the data in the group, rather than by itself on the following page.

There does not seem to be any option to accomplish this. Basically, what I want is a "keep with previous" option. If the group is printing toward the bottom of a page such that there will not be room for the totals, I would rather have the whole group (or part of it) moved to the next page than to have the totals appear alone at the top of the next page.

Is there any way to do this?

Rick.
Elian
Telerik team
 answered on 24 Apr 2013
1 answer
69 views
Previous

Date line
page1 4/17/2013 1
2
3
page2 4
5
6


I want into this format.

Date line
page1 4/17/2013 1
2
3
page2 4/17/2013 4
5
6


Could you suggest approach.

Thanks in advance.
Peter
Telerik team
 answered on 24 Apr 2013
13 answers
484 views
Hi,

We have recently upgraded to SharePoint 2013 from SharePoint 2010. I have designed a custom ASP solution that uses Telerik Reporting. In SharePoint 2010, this has worked fine, but I am not having any success in 2013.

When I go to generate a report, the ReportViewer screen appears and nothing happens. No "Generating Report, Please Wait" message as there should be.

Currently this issue occurs ONLY in Internet Explorer. The reports generate without issue in Chrome and Firefox.

Using Fiddler and Internet Explorer and Chrome's debugging tools, I have found the following information:

Fiddler:
HTTP/1.1 401 Unauthorized

IE Debugging:
SEC7112: Script from http://xxx/Telerik.ReportViewer.axd?name=Resources.ReportViewer.js&optype=Resource&version=6.2.12.1017 was blocked due to mime type mismatch 

Chrome:
Resource interpreted as Script but transferred with MIME type text/plain: "http://xxx/Telerik.ReportViewer.axd?name=Resources.ReportViewer.js&optype=Resource&version=6.2.12.1017".
SCRIPT5009: 'ReportViewer' is undefined 

I have been through the the help topic located at http://www.telerik.com/community/forums/reporting/telerik-reporting/telerik-reportviewer-missing-in-iis-works-with-dev-webserver.aspx to no avail.

Here are the snippets from my web config file:
<SafeControl Assembly="Telerik.Reporting, Version=6.2.12.1017, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.Reporting" TypeName="*" Safe="True" />
      <SafeControl Assembly="Telerik.ReportViewer.WebForms, Version=6.2.12.1017, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer" TypeName="*" Safe="True" />
      <SafeControl Assembly="Telerik.Web.UI, Version=2012.3.1016.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" Namespace="Telerik.Web.UI" TypeName="*" Safe="True" />

<httpHandlers>
  <add path="Telerik.ReportViewer.axd" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=6.2.12.1017, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" verb="*" validate="false" />
  <add path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource, Telerik.Web.UI, Version=2012.3.1016.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" verb="*" validate="false" />
</httpHandlers>

<system.webServer>
  <handlers>
    <add name="Telerik.ReportViewer.axd_*" path="Telerik.ReportViewer.axd" verb="*" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=6.2.12.1017, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" preCondition="integratedMode" />
    <add name="Telerik_Web_UI_WebResource_axd" verb="*" preCondition="integratedMode,runtimeVersionvv2.0." path="Telerik.Web.UI.WebResource.axd" type="Telerik.Web.UI.WebResource, Telerik.Web.UI, Version=2012.3.1016.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" />
  </handlers>
</system.webServer>

 <location path="Telerik.ReportViewer.axd"
   <system.web>
       <authorization>
         <allow users="*" /> 
       </authorization>
   </system.web>
 </location>
 <location path="Telerik.Web.UI.WebResource.axd"
   <system.web>
       <authorization>
         <allow users="*" /> 
       </authorization>
   </system.web>
 </location>

I have also added a MIME type for .axd in IIS and I have tried running Internet Explorer in compatibility mode with no luck.

Any help with this would be appreciated.

Thanks.
Justin Lee
Top achievements
Rank 1
 answered on 24 Apr 2013
3 answers
355 views
I recently upgraded to Q1 2013.

When I checked my previously created reports (created prior installing Q1 2013) and reports created after I installed Q1 2013, I noticed that the Horizontal lines are not correctly displayed in browser and printed report, while the lines looks fine on Preview tab in Visual Studio.

Attached are these screencaps:
- preview tab.png : this is how the report looks on Preview tab in Visual Studio
- display on browser.png : this is how the report looks when I run the solution and show the report on Google Chrome (and other web browsers). Do take note of the LineWidth of the second line (as highlighted in red box). The lines on the report should have the same same LineWidth.
- print.png : this is how the report looks when I print it out. Do take note of the scattered lines, as highlighted in red boxes.

Could Telerik staffs help me on this?

Thanks.
Iris
Top achievements
Rank 1
 answered on 24 Apr 2013
3 answers
180 views
Hi ,
current user of your controls, considering Telerik Reporting.
However I do not see any place for end users to create reports...is there a web equivalent to Microsoft Report Builder?

Thanks

Stef
Telerik team
 answered on 23 Apr 2013
1 answer
711 views
Hello,

I have updated my solution from q3 2012 to q1 2013. Reports are quite fine exept some little changes I had to do but I noticed that in some reports where before I was succesfully using a background image, now the same doesn't get printed out for header and footer.
The image should cover alone the whole report area (without repeating).
I checked header and footer and they are set to be transparent background color.
What should I do?

Thanks, Giuseppe
Chavdar
Telerik team
 answered on 23 Apr 2013
3 answers
95 views
Hello Guys, 

How I can to make my query to receive a parameter using '%like%'?

I tried this 3 options below but its dont working ( last(5ª) line )

SELECT PSR.NOME, CO.NOME, FU.NOME, CO.ATIVO,CO.ID_PSR
FROM COLABORADOR CO
LEFT OUTER JOIN PSR ON PSR.ID_PSR = CO.ID_PSR
LEFT OUTER JOIN FUNCAO FU ON FU.ID_FUNCAO = CO.ID_FUNCAO
WHERE PSR.NOME LIKE %@Nome_PSR%

SELECT PSR.NOME, CO.NOME, FU.NOME, CO.ATIVO,CO.ID_PSR
FROM COLABORADOR CO
LEFT OUTER JOIN PSR ON PSR.ID_PSR = CO.ID_PSR
LEFT OUTER JOIN FUNCAO FU ON FU.ID_FUNCAO = CO.ID_FUNCAO
WHERE PSR.NOME LIKE '%@Nome_PSR%'

SELECT PSR.NOME, CO.NOME, FU.NOME, CO.ATIVO,CO.ID_PSR
FROM COLABORADOR CO
LEFT OUTER JOIN PSR ON PSR.ID_PSR = CO.ID_PSR
LEFT OUTER JOIN FUNCAO FU ON FU.ID_FUNCAO = CO.ID_FUNCAO
WHERE PSR.NOME LIKE @Nome_PSR


Follow in attachment

IvanY
Telerik team
 answered on 23 Apr 2013
3 answers
315 views
Hello, I am creating a report with telerik report Q1 2012 I have this error when running the application:

Message: Unhandled Error in Silverlight 4 Application
Code: 4004    

Category: ManagedRuntimeError       

Message: System.InvalidCastException: Specified cast is not valid.


   at Telerik.ReportViewer.Silverlight.ZoomConverter.Convert(Object value, Type targetType, Object parameter, CultureInfo culture)
   at System.Windows.Data.BindingExpression.ConvertToTarget(Object value)
   at System.Windows.Data.BindingExpression.UpdateTemporaryValue()
   at System.Windows.Data.BindingExpression.GetValue(DependencyObject d, DependencyProperty dp)
   at System.Windows.DependencyObject.EvaluateExpression(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry)
   at System.Windows.DependencyObject.EvaluateBaseValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, ValueOperation operation)
   at System.Windows.DependencyObject.EvaluateEffectiveValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry newEntry, ValueOperation operation)
   at System.Windows.DependencyObject.UpdateEffectiveValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, ValueOperation operation)
   at System.Windows.DependencyObject.RefreshExpression(DependencyProperty dp)
   at System.Windows.Data.BindingExpression.SendDataToTarget()
   at System.Windows.Data.BindingExpression.SourceAcquired()
   at System.Windows.Data.BindingExpression.System.Windows.IDataContextChangedListener.OnDataContextChanged(Object sender, DataContextChangedEventArgs e)
   at System.Windows.Data.BindingExpression.DataContextChanged(Object sender, DataContextChangedEventArgs e)
   at System.Windows.DataContextChangedEventHandler.Invoke(Object sender, DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnAncestorDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.NotifyDataContextChanged(DataContextChangedEventArgs e)
   at System.Windows.FrameworkElement.OnPropertyChanged(DependencyProperty dp)
   at System.Windows.DependencyObject.RaisePropertyChangeNotifications(DependencyProperty dp, Object oldValue, Object newValue)
   at System.Windows.DependencyObject.UpdateEffectiveValue(DependencyProperty property, EffectiveValueEntry oldEntry, EffectiveValueEntry& newEntry, ValueOperation operation)
   at System.Windows.DependencyObject.SetValueInternal(DependencyProperty dp, Object value, Boolean allowReadOnlySet, Boolean isBindingInStyleSetter)
   at Telerik.ReportViewer.Silverlight.ReportViewer.Initialize()
   at Telerik.ReportViewer.Silverlight.ReportViewer.OnApplyTemplate()
   at System.Windows.FrameworkElement.OnApplyTemplate(IntPtr nativeTarget)     

Line: 121
Char: 5
Code: 0
URI: http://localhost:1133/js/utilitarios.js

I hope someone can help me, is my first application using telerik report
Chavdar
Telerik team
 answered on 23 Apr 2013
1 answer
373 views
Hi,

i'm trying to create a table in telerik reporting.
My problem is that i cannot make manually the same height for every row in the table.
I'm trying to use "make same height" function, but doesn't work (maybe i cannot use it right).
Can u explain me how it works?

Thank u! (sorry for my bad english)
IvanY
Telerik team
 answered on 23 Apr 2013
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
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?