Hello.  I set up a few Telerik reports a couple of years ago, and now I'm trying to remind myself how they work.  :-)

I am creating a new report that has a dynamic datasource here:


The report works fine when I build the project and view it through the report viewer, however, I cannot get the data to run in the Preview version of the report, and the designer does not recognize that any fields are available for the report.

I tried using a SqlDataSource stored procedure, but I have been unable to successfully pass in the date parameters when trying to run the stored procedure. 

So, my question is:  how to I get the report to recognize that data fields are available for creating the report when I have a dynamic data source?  Thanks!!

just out of curiosity do you gusy have any plans to implement a runtime designer so my users can create ad hoc reports or is that out side the scope of what Telerik Reporting is supposed to do?

We are currently trying to decide between this and Crystal as our report engine, but the main advantage Crystal has currently is they do have a report designer I can give my end users so I don't end up having to write all the reports.

Thanks!

Hi,
We wanted to find out if it is possible to allow users to dynamically group data in a Telerik Reporting Report (the users are used to the group by features from the Telerik RadGrid/RadGridView).  The users want to be able to select 1 or more columns in the report to group the data by, is this possible?  Some times they will just let the report generate without adding grouping.

I have a chart that works fine. The problem is the chart may have 7 items on the X axis or 700. If there are 7 it looks great, if there are 700 it is unreadable.

How can I print the 700 so it is readable.

The two solutions I have been looking into (I am open to other solutions) are:

1) Determine the number of elements in the result set and change the height of the report to be a multiple of the data set.
2) Duplicate the chart as many times as needed based on the results limiting each chart to 20 records.

Option 2 is probably the preferred option. I have not been able to work my way through how to do either of these.

Is there a way to do what I need to do? I don't want to filter the data, I need to show it all.

Hello,

I need to vary the color of the Bars in bar chart in silverlight telerik report.

I have attached the screen shot which provide more idea what i need.

Thanks,
Hiren

Does Telerik reporting change the report size paperkind automatically based off of the users printer settings?  For example, if I design the report using letter paperkind, and a user in Europe goes to export the report to PDF, does the reporting engine know to convert it to A4 if that is what thier default printer uses?

Essentially, the problem I am facing is I designed the report based on one measurement (letter), but when Europeans export the document to PDF, its in the A4 measurement.  So the margins are wider in the A4 measurement.

Any best practices when designing reports for multiple users who use different paper sizes.  All reports are always viewed in PDF.

 

Hello,
 

We are using version Q2 2011 of telerik reporting.

I am using the Silverlight report viewer in my application and we are using our own controls outside of the viewer to feed in report parameters. This has worked well so far and the BeginRender event is working fine.

However we now have a requirement for a report that drills through to another report and I need to update our criteria selectors to reflect the new parameter values that are used. When the drill through report starts to load the BeginRender event fires on the client so I know that they have drilled through, but the args that are passed do not contain the parameters that were used.

If there any way to get the parameter values? Will this be addressed in a future release?

Any help would be appreciated.

Thanks,

Travis

Hi,

I have created a report using table. 
At present:I am getting

column1  column2  column3
-----------------------------
fruit         apple         red
fruit        banana       green
fruit        mango       yellow
car         toyota       black
car         nissan        silver

What I want is:

column1  column2  column3
-----------------------------
fruit         apple         red
              banana       green
              mango       yellow
car         toyota       black
              nissan        silver

So as you can see, grouped column is getting repeated for all grouped rows. However I want it to appear only once.
Heres my code :


 Any suggestions ?

Hello All,
    I am creating a bar chart. The datasource is a datatable having values. The X-Axis has the date and the Y-Axis has values. When done this way the Datapoints are being displayed on top of each bar. I do not want to display the Datapoint value. How do I disable this? I had check the example they had given "chartSeries.Appearance.LabelAppearance.Visible = false;"(doesnot support). Is there any way the I can remove the datapoints.
    Any how I am able to disable if I create series and populate by giving " chart1.Series[1].Appearance.LabelAppearance.Visible = false;" but the problem in this is that I am not able to populate the X-axis with date it asks for a double " item1.XValue = Convert.ToDateTime(TableValues.Rows[i]["StartTime"]).ToOADate();" in this the displayvalue in the chart comes as year 1899, the value passed was “TableValues.Rows[i]["StartTime"]= 2011-11-10 17:10:00". How do I plot values for relevant date?

 

Code:

Telerik.Reporting.Charting.ChartSeries chartSeries1 = new Telerik.Reporting.Charting.ChartSeries();

            for (int i = 0; i < TableValues.Rows.Count; i++)

            {

                Telerik.Reporting.Charting.ChartSeriesItem item1 = new Telerik.Reporting.Charting.ChartSeriesItem();

                item1.YValue = Convert.ToDouble(TableValues.Rows[i]["AlarmCount"]);

                item1.XValue = Convert.ToDateTime(TableValues.Rows[i]["StartTime"]).ToOADate();

 

                chartSeries1.Items.Add(item1);

            }

 

            this.InitiatedChart.Series.AddRange(new Telerik.Reporting.Charting.ChartSeries[] {

            chartSeries1});

 

       The other is that what is the max number of values the graph can hold. The graph does not display for 16,000 points.

I am using visual studio 2010, Telerik Reporting (licensed -TV446243)

Hi there,

I have a report with 2 groups and want to use a count from the inner group in the grouping of the outer group.

For example, the raw data is like this:

Customer          Order ID
Customer A        Order 1
Customer B        Order 2
Customer B        Order 3
Customer C        Order 4
Customer C        Order 5
Customer D        Order 6
Customer D        Order 7
Customer D        Order 8

I can group by customer and use the COUNT aggregate function to get the following:

Customer          Order Count
Customer A        1 order
Customer B        2 orders
Customer C        2 orders
Customer D        3 orders           

However, I want to add another group outside this where the grouping is based on the Order Count from the inner group:

Order Count        Customer Count
1 order                    1 customer
2 orders                  2 customers
3 orders                  1 customer

But you can't use an aggregate function in the grouping field when you set a group up.

Do you know of any work arounds?

Thanks, Jon