I generate an Excel file using Telerik reporting Q2 and I want to have a single cell with colored text, e.g., one part of the text to be green, the other blue. Is this possible to be accomplished?

 

Hi, I am new to Telerik and am wondering where the best resources for using the Standalone Report Designer with .trdx files are.

The information at http://www.telerik.com/help/reporting/standalone-report-designer.html shows very different screenshots than what I see, and http://www.telerik.com/help/reporting/quick-start-create-simple-report.html is helpful but only as a brief introduction to setting up a connection.

I have attached a screenshot of what I see in the Report Designer. I am particularly interested in any information on the controls found under the Insert tab.


Thank you for your time,

Ian

I want to only show data that appears between the first and last days of last month, how might I do this?

My attempt (not working) is to use "between" logic and the C# methods AddMonths() and AddDays() in an "IIf" expression, showing another field if true and otherwise showing nothing if false:

Is it possible to dynamically produce charts in a ReportViewer? (bar, pie, and line charts)
I managed to make RadCharts in a User Control, but I can't seem to produce anything inside a ReportViewer.
My data source (for the chart) is an array, and I'm using WPF.

Hi,

I'm getting this message error when I' try to export the report from my report viewer.



could somebody give me a hand with this please?

Regards.

I have a stand-alone HTML page based on the Report Viewer samples. This page calls the api/reports API. When my report is not parameterized, the Report Viewer works great and my report appears. I am now trying to add parameters to my report. 

Here is my Report Viewer script that passes the parameter:

Here is the parameter JSON being passed into '/api/reports/clients/085707-b6ce/parameters':
[{"name":"LastName","type":"System.String","text":"Last Name","multivalue":false,"allowNull":false,"allowBlank":true,"isVisible":false,"autoRefresh":false,"hasChildParameters":false,"childParameters":null,"availableValues":null,"value":"McGuy","id":"LastName","label":"McGuy"}]

So it appears to be passing the parameter. In fact, I added a text box that prints the LastName parameter, and when the report loads, it shows "McGuy", which is the value I am passing. But the report does not return any rows. Here is my report SQL:


When I go through the "Configure SQL Data Source" dialogues in the stand alone Report Builder, it returns records based on my parameter, when I preview.

I am not sure what I am doing wrong. Any help would be great.

I'm designing a couple of reports in a class library. Suddenly I keep getting the following error, printed in the report itself, when I try to preview the report:


After I completely restart Visual Studio, I can generate the report again, without a problem. However, when I make a change, the error comes back.

This restarting is getting tedious. What is wrong? Is there a way to solve this? Or when this happens, is there a quicker way of making the report run again?

Thanks in advance,
   Herre

We are working on a crosstab report where there is a row group (Category) and two column groups (Location and Gender),  and we are showing total hours as the value. What we'd like to do is to show the hours as a percentage of the total for that Category and Location. The attached screenshot shows what we want, and also what the report designer gives us.

Basically if we have Category 1 and Location 1, we'd like to show the percentage of females for that category and location only. We are using an expression like

= Sum(Fields.TotalHours)/ exec("Gender1",Sum(Fields.TotalHours))

However this EXEC statement returns the total for the whole Gender group. We've tried the other groups, with similar results.

Is there a way to sum only across the current range of values?

On occasion our report viewer will receive a "Report is unavailable or session has expired." when opened in a new window on an ASP.NET 2.0 application.  This started when pushed to our production environment which is load balanced using round robin.  Production is also HTTPS.  Also, the images on the report never show.  Everything worked great on our test server which is not load balanced and is not HTTPS.

Any help is greatly appreciated.

Thanks,

Warren

Hello All,

I wanted to post this so no one else has to go through what I went through trying to figure out how to dynamically change the connection string when using .trdx files as the urisource in the windows forms report viewer and having each customer with their own database being able to run the canned reports that we make for our software.

First, when you design the report, give the SQL Datasource a Name and check the box to save it in the configuration file (I did this from the Telerik Standalone Report Designer. This will not expose your connection information to end users and allow them to create alternative reports for your canned reports without letting them see the connection password.

Second, add a line into your [appname].exe.config file for the connection string and leave the connection string value BLANK. It should look something like this (put this right under <configSections> and I think the casing matters on <connectionStrings>:

<connectionStrings>
    <add name="Marketplace" providerName="System.Data.SqlClient" connectionString="" />
  </connectionStrings>

Next, if you have a connection string either encrypted (we encrypt our connection password only and read it into memory on login to our application and assign it to a global variable called ADOnet), you will want to set the named connectionstring in memory and have it refresh. In VB.Net, this can be done by using the following code:

Dim config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None)
Dim connectionStringsSection = DirectCast(config.GetSection("connectionStrings"), ConnectionStringsSection)
connectionStringsSection.ConnectionStrings("Marketplace").ConnectionString = ADONet
config.Save()
ConfigurationManager.RefreshSection("connectionStrings")

In order to get ConfigurationManager to show up under System.Configuration you need to add System.Configuration explictily to your references in your project (just imports or using will not give you configuration manager)

Anyway, this will update your settings for your named connection in your reports in memory while in runtime.

Hope this helps you to not spend the 5 hours of research and testing it took me to find this solution.

Philip Carter
http://emanageone.com