Telerik Forums
Reporting Forum
3 answers
115 views
I am running a label report. How do you adjust the vertical gap after you run the wizard ?
Steve
Telerik team
 answered on 22 Sep 2009
1 answer
630 views
I am trying to pull data from a database with a stored procedure that takes an integer for the parameter. I used the video http://tv.telerik.com/reporting/video/telerik-reporting-+-design-time-support-for-parameterized-queries as a guide but cannot get the report to work properly.

If I put a value in the Collection Editor for the parameter, I get data returned, but only for the parameter that is hard coded. If I remove that value, I get an error saying 'Failed to convert parameter value from a String to a Int32.

Here is the code for my button. I have created the getter/setter on my ReportViewer object for the parameter OrderIDParam as per the video's instructions. I ran it through debug and the value being passed to the setter is correct.

 

protected void btnRun_Click(object sender, EventArgs e)

 

{

(ReportViewer1.Report

as ReportViewer).OrderIDParam = int.Parse(txtOrderID.Text);

 

ReportViewer1.RefreshReport();

}

Any help would be appreciated. Thanks.

Mike Theos
Top achievements
Rank 1
 answered on 21 Sep 2009
1 answer
89 views
hi,

I want to display data on table by use table control (on header section). My table (only) has two rows, one for title and one for data item.
Row for data item has value like:  = Fields.CustomerName . And as a result, data didn't display on table's row. How can i display ?
I don't use datasource for table because i don't want the table automatically create a raw. My goal is use a table with two row to display a tittle and one row data.

Why i put "= Fields.CustomerName" on value field. Table didn't display data ?

Gersh
Top achievements
Rank 2
 answered on 21 Sep 2009
3 answers
94 views
Here's my scenario. I have an ArrayList of HashTables (a table of rows, if you will), and I want to populate a report with its data.
-The Report Wizard has a business object, I was wondering if it were possible to point it to a class that conatins my data in said form
- If not, can I be pointed to a tutorial that states how a List works
-Ideally, I would like to treat said data structure as reports work when you have a sql table (Fields.colname)
Gersh
Top achievements
Rank 2
 answered on 21 Sep 2009
0 answers
108 views

Hi
I want to bind a picturebox Dynamically to an image field in database.
I use this code (I'm Using Northwind Database):

            using (DataClasses1DataContext dc=new DataClasses1DataContext())  
            {  
                var a = from p in dc.Products  
                        join c in dc.Categories  
                         on p.CategoryID equals c.CategoryID  
                        select new 
                        {  
                            ProductName=p.ProductName,  
                            UnitPrice=p.UnitPrice,  
                            UnitInStock=p.UnitsInStock,  
                            CatName=c.CategoryName,  
                            CatPic=c.Picture  
                        };  
                this.DataSource = a.ToList();  
            } 

And when I set Value of picturebox to "=Fields.CatPic" Nothing display.
How I can do that
Thanx
Nima Nima
Top achievements
Rank 1
 asked on 21 Sep 2009
2 answers
109 views
I'm looking for some advice on how to protect reports that are ultimately displayed in ASPX pages.  I have developed a Silverlight 3 application.  Within the application, I am able to execute a report, and display this report in an HtmlPlaceholder or a seperate browser window.  Because this report is embedded within an ASPX page, anyone can simply type in the URL for the report (www.MyWebSite.com/MyReport.aspx) and cause the report to be generated.  These reports contain sensitive data, so I want to make sure that the pages are authenticated appropriately before they can be accessed.  Any suggestions on how to accomplish this?

My environment is IIS 7, my Silverlight 3 application, plus the reports (each embedded in its own ASPX page).  These are anonymous users that must log into my Silverlight 3 application.  I do not wnat users to be able to access the ASPX pages without going through the SL3 app.
GEB
Top achievements
Rank 1
 answered on 19 Sep 2009
1 answer
164 views
We are using R.A.D Grid 2006 and Telerik reporting 2009 in our project.

the rad grid has the ability for the user to edit update and delete. Also we rename the column headers in the item_binding.  the user has the ability for paging and sorting. now we want the datagrid snapshot(data) to be fed to the telerik reporting as the data source.

The usual way of telerik reporting is to be bind a datasource and get the reports. In this case as the user has changed paging and sorting in the rad grid, we want to have them remembered and fed to the reports.

Second question:

simply stated how can pass on the rad grid data as a data source to the telerik report including the paging and sorting state.

Any suggestion would be of great help.
Schlurk
Top achievements
Rank 2
 answered on 18 Sep 2009
3 answers
252 views
I have a report with a simple bar chart. I am using report parameters to filter the queries. When i edit the parameter values and hit preview, the chart needdatasource event fires but the chart is not getting updated in the report.
 
below is the code in the  chart needdatasource event. I am populating the recordCount collection in the Report NeedDatasource event.
 private void chart1_NeedDataSource(object sender, EventArgs e)
        {

            Telerik.Reporting.Processing.Chart procChart = (Telerik.Reporting.Processing.Chart)sender;
            Telerik.Reporting.Chart defChart = (Telerik.Reporting.Chart)procChart.ItemDefinition;
            
            procChart.DataSource = null;
            procChart.DataSource = recordCount;
            
                     

            defChart.Series[1].DataYColumn = "Status";
            defChart.PlotArea.XAxis.DataLabelsColumn = "chartlbl";

            //defChart.PlotArea.XAxis.LayoutMode = Telerik.Reporting.Charting.Styles.ChartAxisLayoutMode.Inside;
            defChart.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Font = new System.Drawing.Font("Ariel", 8);

            
        }


Could you please let me know if I am doing anything wrong above.

Thanks
Steve
Telerik team
 answered on 18 Sep 2009
5 answers
159 views
Hi Telerik Team,

I have a problem - again :-(.

Since the other one is still not solved I'm confrontated with another problem now.
I have a chart in my report which shows a StackedBar. There are 52 bars. One for every week of the year. So the Xaxis doesn't really look nice because the shown week numbers overlap. So I decided to use the LabelStep property. But whenever I use a value greater than 1 the DocumentBytes of the RenderingResult coming from the RenderReport Method is NULL. When using the value 1 everything is fine.

I have installed the latest version of Telerik Reporting shown in web.config as Version 3.1.9.807.

What do I have to regard when using the LabelStep Property?

Thank you for your help!
Steve
Telerik team
 answered on 18 Sep 2009
1 answer
138 views
I have a report that has a parameter called prmMeetingDate
The data source for prmMeeting contains two columns: [id] and [date]

The value is derived from the [id] column and the displaymember is derived from the [date] column.

On the report header, I want to display the [date] of the selected prmMeetingDate. I know that I can display the value of the parameter on the header but that will not work since it will display the [id] which is of no use to the end user.

How do I do this? Thanks.
Steve
Telerik team
 answered on 18 Sep 2009
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
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?