Hi, 

I'm sure this is a common request. Do you have an example of how to report on recurring appointments using the recurrence pattern saved with the appointment?

We have many recurring appointments, and our reports need to include these when getting appointments by a range of dates.
We are using Entity Framework so ideally your example uses a partial class approach.

Thanks

Hi,

I have a telerik report with chart.
The chart data source is a default sql query (I set it by design):

select *
from customers

In my ascx page I have a filter box, for example for the customer location with the values - All, France, Italy, Spain.
If the user selected location and pressed "Generate", I want to change the query to:

select *
from customers
where location = '(The selected value)'

if the selected value is all, I want to run the report as is.

Is there a way to change a chart query in run time?

Thanks!

Hi,

Instead of having data in rows horizontally is it easy to list data vertically in columns.

E.g instead of

Name, Age, Country, Profession
Name, Age, Country, Profession
Name, Age, Country, Profession

I want to achieve

Name                    Name                 Name
Age                       Age                    Age
Country                Country              Country
Profession            Profession         Profession

Thanks,

Ronan

I save chemiscal formula into sql2005 (ex: H2O, 2 is subscript by richtextbox format rtf), i want to show this formula in telerik report but i don't know . Can anyone help me?
Thank you

My main goal is to set up Telerik reporting in my Silverlight application with RIA Services. But I can't get it working. Even not the easy bits.
I have been reading and trying and reading and trying without any luck.

What did I do:
- Server side (the same project that contains my services and Entity Model): create a "Reports" directory, create a Telerik report in it
- In my Services directory, create a "ReportingService.svc" that contains one line of code: 


I also updated my web.config file with the proper WCF settings for the ReportService (bindings and endpoints) as explained in the Telerik article.

On my report I set the DataSource to an objectSource with
DataMember = GetBuildings    // this is the name of the method from my DomainService that returns Buildings
DataSource =  ProjectName.Web.Services.BuildingService // full qualified name of my DomainService

My DomainService (BuildingService)

Where BuildingEntities is my EntityModel.

When in the report designer, I can see the fields of my Building entity. But in the preview windows I receive the error "Exception has been thrown by the target of an invocation. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider or not valid."

What am I doing wrong?

I must say that I also tried to create a class library with an new entity model to the database (even using the AdventureWorks db), using the EntityDataSource, and I receive the same errors.

I was hoping that if I had HTML markup in an HtmlTextBox then when it was exported (to an appropriate format) it would be rendered appropriately.

However, it seems that if I export to either PDF or RTF all I get is the HTML markup.

Am I doing it wrong? Or am I to just be disappointed?

-- 
Stuart

I have an app wherein HTML text is saved in the DB (output from a RadEditor) and I have a requirement to print it.

Now, I've had some success with the HtmlTextBox in Reporting, but, by no means, complete success.

I note from a much earlier thread that the HtmlTextBox doesn't support rendering of an <img> tag and, back then, there was no plan to change that. Is this likely to change? If not what are my options?

-- 
Stuart

Using a Silverlight application and Telerik ReportViewer  we're having the following issue.

We have a drop down to pick a client.  That is passed to the report SQL and is all working fine.

If I run a smaller client report (up to about 60 pages or so works fine), it comes back fine.

If I run a larger client report... I get the following message.


Same report... only difference is the volume of data.  I can subsequently pick a smaller client and it reloads and renders just fine.

This error occurs (by me counting) about 40 seconds after the initial call.

I have tried setting the binding as follows (and confirmed the code gets called)


The report is configured using a SqlDataSource object and the CommandTimeout there is set to 900 seconds.  After that SQL text is used with a single parameter.

Again it only fails on large amounts of data... It works fine in Preview mode (design time) as well.  One big one is 1400+ pages which is only about 42,000 rows.

Hi,

I have a long report with 10 sections and it shows all sections on web page

but when I export to RTF it splits to first 3 pages and then it does NOT split to 4th pages but instead it continues on the same page and all other section get hidden due to going out of margin.

Please give any suggestions to fix?
(same happens on word export)

Thanks

Hi,

Image of screen attached.
I have built a cross tab that has a number of row groups.
I have three columns which perform a sum aggregate.
Local Column - marked as 1 on screenshot  (which is a field from the EntityDataSource that the grid is bound to) works fine and simply sums the field values for each group
Columns 2 and 3 are bound to sub reports. The sub reports simply sums all items grouped by id. In isolation this works fine.My plan was that the master report would pass in the Id(s) to the sub report as parameters and the sum would happen. However this is not the case.

Problem
When I put the sub reports into the cells as shown beneath 2 and 3 - no values are returned. The sub reports are passed in the parameter that is meant to represent the current row Id - but it does not appear that these are passed in for every master report item.
So the totals are not calculated.
I also need to sum column 1, 2 and 3. 

Please advise if this can be done and how best to do it. An example would be great. C#.

Thanks
Simon