Questions on Reporting Forum

3 answers

792 views

Try to get a TotalRecords count from Table after filter

Good day, I'm doing the below from code behind. Thus far all has been working until I tried to display the Count of records that the Table is show AFTER filters are applied. The count displayed is nowhere near the correct number so I assume I'm doing something incorrectly.

private void report1_NeedDataSource(object sender, EventArgs e)

{

var query = ExtendedData.GetExtendedAgreements(_db, _ProgramAreaID, null);

table1.DataSource = query ToList();

//Setup Column Filters based on Querystring, Proof of concept, to be made Dynamic

//************************

this.table1.Filters.AddRange(new Telerik.Reporting.Filter[] {

new Telerik.Reporting.Filter("=Fields.Province", Telerik.Reporting.FilterOperator.Equal, "Ontario")});

int count = table1.Items.Count();

TotalRecords.Value = Convert.ToString(count);

}

General Discussions

answered on 21 Dec 2012

10 answers

1.3K+ views

[Solved] Hiding the ReportViewer toolbar

I am using a different menu system, and having both my menus and the ReportViewer toolbar is confusing the end-users.

Is it possible to hide the ReportViewer toolbar completely?

If not, is it possible to at least hide the "cancel" button specifically? All the other buttons can be hidden.

General Discussions

answered on 21 Dec 2012

7 answers

651 views

Passing Querystring to SQLDataSource

I know I'm missing something simple. But we are demoing Telerik Reporting and coming from using SSRS on ASP.NET projects.
For our existing locally processed reports, we put together an rdlc, the reportviewer and a datasource such as SQLDataSource.
This datasource connects to a stored proc that has multiple parameters passed in QueryString. We simply add QuerystringParameters to the datasource and we are done - the report host aspx page runs, datasource executes and the rdlc displays results in the ReportViewer.

What I can't figure out is how this works in Telerik Reporting. Its seems Telerik's SQLDataSource is defined in the report and not the 'host page' aspx and doesn't seem to accept QueryStringParameter as a parameter. So guess I need to know, how to pass the querystrings (up to 20) to the SQLDataSource the easiest way possible. We do not need report parameters, just the datasource parameters.

Sample aspx from SSRS local report:

<asp:SqlDataSource ID="SqlDataSourceX" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnDB %>"

SelectCommand="SELECT * FROM [Jobs] WHERE ([DeptID] = @d)">

<SelectParameters>
<asp:QueryStringParameter DefaultValue="2" Name="d" QueryStringField="d" />
</SelectParameters>
</asp:SqlDataSource>
Or, how to just use the asp:SQLDataSource on the aspx page to 'feed' the trdx and the ReportViewer control?
Any help is GREATLY appreciated.

General Discussions

answered on 21 Dec 2012

6 answers

134 views

Rotate DataLabelColumns

How can you rotate the Data Lable Column. I have it displaying a description but they run together, I can see I can rotate differnt lables but can not seem to find the place to rotate the labels on the x axis. I would like to rotate them about 30% so they will fit. Also how do you show the value of the y axis in on the bars of a bar grid. Alos I am show percentage and the y axis is only going to the largest value, how can I set it to go to 100?

General Discussions

answered on 21 Dec 2012

0 answers

139 views

StackedBar100

I see how to stack the StackBar or StackBar100 chart you make each stack a new series. Is there a way to dynamically add a series.
I have a data set theat has date, category, and percentage of Sale. What I would like would be the x be the date, then the y be the Percentage and the series be the calegory. Depeneding on the date tsome categories may or maynot be in the data set. Is ther a way to dynamically at run time to create the series and populate the stacked bar reports?

General Discussions

asked on 20 Dec 2012

0 answers

121 views

Series Appearance

When setting the apperance for the Series is there a way to format the lable. Such as I am showing Percentage and it is out to 6 decimal points but in tfor the label I want only 2 decimal points. Also is there a way to conditionally format so when the value is null nothing is shown?

General Discussions

asked on 20 Dec 2012

7 answers

209 views

[Solved] Use SQL Datasource to populate Charts

Ok I have looked through alot of the documentation and I just don't get it. This should be easy.

I have a sql query that is used in as the datasource for the report. It displays the data in a a cross tab table. I then want to take the percentages, some are in the query others are determined at run time of the report. I want to create a bar chart that has the Categories across the bottom and the percentages as the y.

I would also like to use the same data set to build a pie chart. I can set the datasource to the chart but I can not see any way to set the x and y axis to the fields I want displayed

General Discussions

answered on 20 Dec 2012

1 answer

72 views

Printed X-Axis label has black background

VS 2010, Q2 2012 reports. I have a chart in my report when it is printed the X-axis label (as well as the item labels on both axes) has a black background. The Y axis label which seems to be formatted identically, does not have a black background. This ONLY happens when printing directly to a printer. On the screen and when generating a PDF this black background does not appear.

I have been setting the fills to all use the transparent color to see if that would do anything but no no avail.

Any suggestions?

Thanks,

Matthew

General Discussions

answered on 20 Dec 2012

2 answers

137 views

Report with ObjectDataSource on EF/POCO Objects. Preview Error

Hello

I want to build reports based on ObjectDataSource. As an easy sample, I tried to start with an sample report, based on your video.

In my project, there is a BI-Layer based on EF4/POCO. But when I try to add a Entity Context Object (to populate the List in GetAllProducts()), I get an Error on Report Preview (see Attachment).

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.ComponentModel;

using IW_CCFA_GEKO.Model;

namespace IW_CCFA_GEKO.Report.ReportModels

{

[DataObject]

public class Products

{

protected CCFAGEKOEntities db = new CCFAGEKOEntities();

[DataObjectMethod(DataObjectMethodType.Select)]

public List<Product> GetAllProducts()

{

var products = new List<Product>();

products.Add(new Product() {Name = "Produkt 1", Color = "blau", ListPrice = 2.55, ProductNumber = "654-789"});

products.Add(new Product() {Name = "Produkt 2", Color = "gelb", ListPrice = 1.20, ProductNumber = "345-768"});

products.Add(new Product() {Name = "Produkt 3", Color = "rot", ListPrice = 5.0, ProductNumber = "56-334"});

products.Add(new Product() {Name = "Produkt 4", Color = "grün", ListPrice = 3.9, ProductNumber = "234-159"});

return products;

}

In the same Project, I made a report, directly based on an EntityDataSource, which works, even in Preview. But I need to do some processing in my own Classes before.
What's wrong and how to resolve it?

Thanks, Simon

General Discussions

answered on 20 Dec 2012

1 answer

129 views

Conditional Formatting default style

I have my report's default font set to Times New Roman, 9pt, When I create new conditional formatting on a field, the font is Arial 10.

How can I configure my environment to have a default font for all actions?

Peter

General Discussions

answered on 19 Dec 2012