Telerik Forums
Reporting Forum
2 answers
173 views
Hi everyone

I need to set my crosstab position programmatically, because it has different number of columns based on user options. So I want to show it in the center (horizontally) of page every time.

I used of location (x , y) based on dimension of page and number of crosstab columns for it in my c# code, but it is not effective at all.

Thanks for your guides
Ken Lewis
Top achievements
Rank 1
 answered on 20 Nov 2012
5 answers
398 views
I am trying to create a bar chart in a Telerik Report. I have a SQL stored procedure that gathers the data and returns the number of items that are different colors. My items can be one of six color (Green, Gray, Orange, Yellow, Black, or Red). I then need the bar chart to display the x-axis label with the color name and the to color that bar with the color represented. I have tried two different stored procedures that return the data in two different formats. One method returns two columns one for the name of the color and the second for the count of items with that count. There a total of six rows returned, one row per color. The second method returns just one row and six columns, each column name is the colorname and has the count. Method one lets me set the X-Axis labels to the color name and shows the proper count but I cannot find a way to change the color of each bar on the chart. I can only set one color for all bars. If I try the second method of data, I can set up a custom palette and create a series with enough items to patch but I cannot put the color names under each bar on the chart. Any assistance or suggestions would be greatly appreciated.
Steve
Telerik team
 answered on 20 Nov 2012
1 answer
230 views
When I click the preview button my report auto loads, but I have a string parameter I would like to fill in. My query is such that an empty string will load an unfiltered list, which can take some time. I really need it to wait for me to enter my parameter and click preview before it tries to load the report. Is there any way to do this? and why does this happen anyways, shouldn't it just wait for my parameter like SSRS does?

P.S. If I choose to not allow blank strings for that parameter, the preview then fails, but won't let me reload the report after I put in a valid parameter... seems like a bug.
Steve
Telerik team
 answered on 20 Nov 2012
1 answer
102 views
Hello,


I'm new to the forum, so thanks in advance, I hope someone can help me. I have an strange error with Telerik Reporting.

I am using the Telerik Reporting Q1 2012 (ver. 6.0.12.215) and Visual Studio 2010, framework 4.0, and works perfectly in PROD, TEST and in one DEV environment...

MY applications is SL4 and show the reports inside a ReportsViewer.

But now I am trying to setup a new Dev environment and i have an error:

a:InternalServiceFaultError loading extension type with name .A null or zero length string does not represent a valid Type. at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName) at System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.Type.GetType(String typeName, Boolean throwOnError) at Telerik.Reporting.Processing.ExtensionManagerBase.CreateExtensionInfo(String typeName, String extensionName)System.TypeLoadExceptionError loading extension type with name . at Telerik.Reporting.Processing.ExtensionManagerBase.CreateExtensionInfo(String typeName, String extensionName) at Telerik.Reporting.Processing.ExtensionManagerBase.Config(ExtensionInfoCollection extensions, ReportingConfigurationSection section) at Telerik.Reporting.Processing.ExtensionManagerBase..ctor(IEnumerable`1 extensionTypeNames, ReportingConfigurationSection section) at Telerik.Reporting.Processing.ExtensionManager..ctor(IEnumerable`1 extensionTypeNames, ReportingConfigurationSection reportingSection) at Telerik.Reporting.Processing.ExtensionManager.get_Instance() at Telerik.Reporting.Processing.ExtensionManager.ListExtensions(Type extensionType) at Telerik.Reporting.Processing.ReportProcessor.ListRenderingExtensions() at Telerik.Reporting.Service.ReportServiceBase.Telerik.Reporting.Service.IReportService.ListRenderingExtensions() at SyncInvokeListRenderingExtensions(Object , Object[] , Object[] ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)Telerik.Reporting.Interfaces.ExtensionManagerException

My application needs to work with SSL, and works fine, but in this new Dev environment i have this error... 

I read all articles, and I have reviewed the DLLs, and the web.config settings

Any ideas?

Thanks!


Steve
Telerik team
 answered on 20 Nov 2012
6 answers
160 views
We are having an issue with the Telerik reporting components running inside Sharepoint 2010.  We are running version 6.1.12.120.  On a local development machine, the reports run fine, but when deployed on a remote Sharepoint server, the reports "spin" endlessly and don't return.  However, it does not seem to be consistent -- with very small amounts of data (1-5 rows), the report will return, but with more data, it just sits and spins.  What I have noticed is that I get a 403 error on one of the calls to the ReportViewer.axd, specifically the item appendChild <frame> call.  We have verified that the SQL calls returns quickly, we have stepped through the code in the debugger and verified that it databinds the data, but the report won't render.

Are there specific permissions required for Telerik report rendering in Sharepoint 2010?  Has anyone run across this issue where the reports run inconsistently, especially with data of any consequence, within Sharepoint?  What other things should we try to troubleshoot these reports?  Thanks!

I have attached a screenshot of the 403 error call.
Rico
Top achievements
Rank 1
 answered on 19 Nov 2012
1 answer
168 views
Hi,

I hope there is an easy way to do this...  Basically, we have a perfectly running site which is built with many Telerik tools (love your products!)...  We just renew our annual subscription.

The Problem:  Our developed site, with extensive reporting and page richness thanks to Telerik, works super on IIS6 and IIS7.  All very nice.  We're sailing through a rebranding storm and have a new brand-related animated Gif for "Please Wait" which is now used throughout the site except for one place. That one last place to change is the Reportviewer for when it's processing data before the report displays.

So I came across a very nice thread on your site (http://www.telerik.com/community/code-library/reporting/general/applying-custom-skin-to-the-web-report-viewer.aspx) which explains: "You can do this by implementing a custom skin for the ReportViewer.".  So I did the following:

- I downloaded the Zip file in that thread and extacted the Skins folder and it's two sub-folders (Custom and Orange).

- In the "Custom" sub-folder, I replaced the Loading.Gif with my own Gif and then I copied that Skins folder to my project..

- I updated the properties in the page where the Reportviewer was happily living the past few years: SkinsPath="~/Skins" Skin="Custom"

- I hit the "Run" button and all was good in the world as it worked just as the thread said it would be.

So, then I copied the site to one of our servers (IIS7) and when you run a report at the site, it pauses a moment (new) when it's about to process the report and there's no font any more for the "Processing..." text and the animated gif is a box with a red x in it.  Then, the report processes and looks perfect, however, the toolbar is filled with those boxes with red X's in it and looks quite unhappy.

First, I thought it may be some IIS7 challenge the universe was throwing me, but I had the same results when I copied the site to a server running IIS6.

Then, I checked for the Skins folder on the servers and yes it was there with the right files in it.

Then, I removed the Reportviewer properties for SkinsPath="~/Skins" Skin="Custom" and I recompiled the site and reposted it (an automatic batch process) to both servers and both looked good again without any issue.

When the paramedics revived me, I found another thread on your site which talked about "the styles of the web report viewer's toolbar are all messed up" (http://www.telerik.com/support/kb/reporting/report-viewers/the-styles-of-the-web-report-viewer-s-toolbar-are-messed-up.aspx) and I meticulously went through every item in that solution path to no avail.

All that I need to do is to replace the animated Loading.Gif and I'm done but I've hit a wall here and hope you can bail me out like you have every time I hit walls in the past.

We're using: 

ASP.Net 4.0
VS 2010
Telerik Reports – Q3-2012
Telerik AJAX Controls – Q3-2012 

Please advise, thanks,
Steve    
Steve
Top achievements
Rank 1
 answered on 19 Nov 2012
2 answers
166 views
Is there a way to dynamically instantiate the proper report class and add it to the ReportViewer? For example I have a pre-existing DLL with a single report class in it. Now I add a second report class to that same DLL and replace it on my web server. Let's say I want to use my database to store the names of the report classes, so I can easily add an entry and have it immediately added to a dropdown list. And when I select from the list it will reload an iFrame that has my ReportViewer in it (I actually already have this reloading piece), but is there a way I can code that ReportViewer page to instantiate the class name I have passed to it?

Basically I want to be able to create a new report and just drop the updated DLL onto my server, and with a quick database change have access to the report (i.e. without having to code anything into my report selection or report viewer pages, and possible re-compile etc.)
Xorcist
Top achievements
Rank 1
 answered on 19 Nov 2012
1 answer
149 views
I have a list which contains one textbox in it.

Basically what it does is get some results and display them one above the other.
The problem occures when I have a result that is multiline. The result then tends to "overflow" over everything under it.

The structure of the portion is

Group 1
    Question 1
         Result 1
         Result 2
         ...
         Result N

Group 2
     Question 1
          Result 1
          Result 2
          ...
          Result N

If for example Result 1 is multiline it will overflow onver Result 2/3/4 or even over the next group...
How can I make the list which contains Results expand as the textbox for the results expand as well (TextBox.CanGrow = true for textboxes holding results. I can't find anything similar for lists)

Edit: I have solved the problem by using "Regex.Replace(string,"\r", " ") and having it all in one line and wrapping but I would really like to keep the formating if possible
Peter
Telerik team
 answered on 19 Nov 2012
0 answers
127 views
I have report with several parameters, all of them are optional, but if all parameters are null the report runs very long time. On the page report viewer starts automatically an it takes a lot, before user  can select values for the parameters. 
This question already was asked at the forum, but there is no solution (the solution provided by Telerik team does not work)
Lily
Top achievements
Rank 1
 asked on 16 Nov 2012
2 answers
230 views
I tried to convert my code to the recommended "ElementTreeHelper.GetChildElements method, however the Report Processing GroupSection does not have this object.  What is the correct way to do this?  I have searched forums but no satisfactory answer.  Here is my code.
Imports Processing = Telerik.Reporting.Processing
 
Dim section As Processing.GroupSection = DirectCast(sender, Processing.GroupSection)
Dim dataobject As Processing.IDataObject = DirectCast(section.DataObject, Processing.IDataObject)
 Dim txtbxSumV48 = DirectCast(section.ChildElements.Find("txtSumV48", True)(0), Telerik.Reporting.Processing.TextBox)
Chuck Harrington
Top achievements
Rank 1
 answered on 16 Nov 2012
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?