Telerik Forums
Reporting Forum
10 answers
1.2K+ views
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.

Steve
Telerik team
 answered on 21 Dec 2012
7 answers
617 views
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.
Peter
Telerik team
 answered on 21 Dec 2012
6 answers
121 views
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?
Eric Klein
Top achievements
Rank 1
 answered on 21 Dec 2012
0 answers
117 views
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?
Eric Klein
Top achievements
Rank 1
 asked on 20 Dec 2012
0 answers
101 views
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?
Eric Klein
Top achievements
Rank 1
 asked on 20 Dec 2012
7 answers
173 views
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
Eric Klein
Top achievements
Rank 1
 answered on 20 Dec 2012
1 answer
57 views
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
Steve
Telerik team
 answered on 20 Dec 2012
2 answers
120 views

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

Mars
Top achievements
Rank 1
 answered on 20 Dec 2012
1 answer
103 views
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
Stef
Telerik team
 answered on 19 Dec 2012
1 answer
184 views
I'm a newbie to reporting, so forgive me for this elementary question.

When designing report, I noticed that sometimes the textBoxes were shifted to the right during preview and debugging. Attached are my report in Designer and its Preview.

In Designer, the Grand Total Textbox (and the textbox next to it) should be only one inch from left margin, but in Preview mode, the textboxes were shifted to far right.

So can anyone tell me what happened and how to fix this? I've tried moving the textboxes around but they are still shifted to far right side of the document.

Thank you.
Steve
Telerik team
 answered on 19 Dec 2012
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?