Telerik Forums
Reporting Forum
4 answers
222 views
I have a 300 pixel pie chart that I'm trying to render on a web page. I have the width of the report viewer set to 300 pixels, but I still get a horizontal scrollbar. The table with id of 'Diskspace' is getting a hard-coded width of 624px. The nested table with the class s0 has a table-layout:fixed attribute that needs to go away as well and this will solve my problem. Is there any way to set a template for the report viewer or a way to override these hard-coded values?

Here is the rendered html of the iframe:

<body id="ReportBody" class="bodycenter" style="overflow: auto; margin: 0px; vertical-align: center;" onclick='BodyClickHandler();'>
 
<div id='ReportDiv' style='overflow:auto; width: 100%; height: 100%;'>
<table id='Diskspace' style='padding-left:0in;padding-right:0in;padding-top:0in;padding-bottom:0in;background-color:White;color:Black;font-family:Arial;font-size:10pt;font-weight:normal;font-style:normal;text-decoration:none;text-align:left;vertical-align:top;border-left-style:None;border-top-style:None;border-right-style:None;border-bottom-style:None;border-left-color:Black;border-top-color:Black;border-right-color:Black;border-bottom-color:Black;border-left-width:1pt;border-top-width:1pt;border-right-width:1pt;border-bottom-width:1pt;overflow:auto;word-wrap:break-normal;width:624px;margin-left: auto; margin-right: auto; overflow: hidden' cellspacing='0' cellpadding='0'>
<tr><td>
</td></tr>
 
<tr><td>
  <table cellspacing="0" cellpadding="0" border="0" style="width:100%;  table-layout: fixed;" class="s0">
  <colgroup>
    <col width="300px" />
    <col width="324px" />
  </colgroup>
  <tr valign="top" style="height:101px;"><td colspan="1" rowspan="1">
    <img alt="Chart" src="/Telerik.ReportViewer.axd?instanceid=2a15e0ff56534318865a798efc566a35&optype=ReportImage&StreamID=0qgrrjphoom" /></td>
    <td colspan="1" rowspan="1">
 
    </td>
  </tr>
</table>
</td></tr>
<tr><td>
</td></tr>
<tr><td>
</td></tr>
</table></div>
<script type="text/javascript">
     
var PageInfo = [0, 1];
var BookmarksOnPage = new Array();
 
</script></body>
Eric Wallace
Top achievements
Rank 1
 answered on 05 Nov 2010
1 answer
130 views
Hi,

I have a SQL statment which when run as a SQL script on the SQL managment studio works in 10scs. When run through Telerik as a report SQL datasource it times out.

when investigating the problem i have found this is todo with sp_executesql.

for example if i run my Script:

sp_executesql N' MySQL'.N'@Paramn varchar(20)',@Param ='Value'

then this takes 3mins.

if i run:

sp_executesql N' Declare @LocalParam as varchar(20)
                            Set @LocalParam = @Param
                            MySQL'.N'@Param',@Param ='Value'

this runs in 10scs.

my problem is when i try and do this in telerik it add the localParam into the sp_executesql Paramiter list like:

sp_executesql N' Declare @LocalParam as varchar(20)
                            Set @LocalParam = @Param
                            MySQL'.N' @LocalParam nvarchar(20) @Param nvarchar(20)',@Param ='Value'

because of this i get LocalParam is already declared if i remove the declare it then adds its own @LocalParam as a nvarchar(4000) and again it times out.

Steve
Telerik team
 answered on 05 Nov 2010
1 answer
94 views
I created 2 cascading parameters that are drop down boxes per the sample in the Learning Guide. In Preview, the parameters appear as expected. However, when I use the ReportViewer control on a web form, the parameters appear "behind" the form. This happens in IE and Firefox. See attached png.

I am using Reporting Q3/Q4 2009 ...



Steve
Telerik team
 answered on 05 Nov 2010
1 answer
362 views
Hi,

We are evaluating Telerik Reporting control but are facing problems in creating report pages. The problem is as follows:
We want to create a report whose data comes from stored procedure in database. The sp has 2 parameters which changes based on the drop-down controls on the report page. Now we have developed an report.aspx page and put a ReportViewer control in that page. Then we had created a Telerik Report using designer and then added this report to the ReportViewer control in report.aspx page.
Now where do we specify the parameters for the report? And then how do we bind the data after changing parameters?

The report is very similar to http://demos.telerik.com/reporting/employee-sales-summary/demo.aspx But on the demo page video is not available. Please let us know how to build such kind of reports. We have already spent lot of time in doing own. Your reponse will help us in making a decision to buy the product.

Thanks,
Dilip
Steve
Telerik team
 answered on 05 Nov 2010
1 answer
103 views
Hi

We have a application which is using radgrid dll 3.0.0 version . when we are trying the export the excel report from the web its working in MS office 2003, It is not working in MS Office 2010. Please give me te solution for this...Otherwise I have to change to some other method. My client is giving pressure...Please give the anaswer ASAP.

Regards
Pradeep 
Steve
Telerik team
 answered on 05 Nov 2010
1 answer
189 views
Hello,

I try to add a Telerik Report Q2 2010 in my Silverlight project and I got this error :

The assembly reference "Telerick.Reporting, Version=4.1.10.921, Culture= neutral..." could not be added to the project...

Any idea? 
Steve
Telerik team
 answered on 05 Nov 2010
4 answers
239 views
Hi, telerik team.
I can't solve the problem. Now we report export to excel file. But we can't many report export to one excel file's separated sheets. Help me?
Tsend Boris
Top achievements
Rank 1
 answered on 05 Nov 2010
3 answers
248 views
i want to set the height of chart dynamically depending upon the size of rows. here is the code
  void chart1_NeedDataSource(object sender, System.EventArgs e)
    {
        Telerik.Reporting.Processing.Chart chart =
            (Telerik.Reporting.Processing.Chart)sender;
        Telerik.Reporting.Chart chartDefinition = (Telerik.Reporting.Chart)chart.ItemDefinition;
        chartDefinition.Height = new Telerik.Reporting.Drawing.Unit(50, Telerik.Reporting.Drawing.UnitType.Inch);
        
        
        //SqlDataAdapter adapter = new SqlDataAdapter(sqlDataSource1.SelectCommand,sqlDataSource1.ConnectionString);
        //DataSet dataSet = new DataSet();
        
          //  adapter.Fill(dataSet);
        //if (dataSet.Tables[0].Rows.Count != 0)
        {
            chartDefinition.Height = new Telerik.Reporting.Drawing.Unit(this.tableTopEmployees.Items.Count, Telerik.Reporting.Drawing.UnitType.Inch);
        }

        
        
    }
private void chart1_NeedDataSource(object sender, System.EventArgs e)
    {
        Telerik.Reporting.Processing.Chart chart =
            (Telerik.Reporting.Processing.Chart)sender;
        Telerik.Reporting.Chart chartDefinition = (Telerik.Reporting.Chart)chart.ItemDefinition;
        chartDefinition.Height = new Telerik.Reporting.Drawing.Unit(50, Telerik.Reporting.Drawing.UnitType.Inch);
         
         
        //SqlDataAdapter adapter = new SqlDataAdapter(sqlDataSource1.SelectCommand,sqlDataSource1.ConnectionString);
        //DataSet dataSet = new DataSet();
         
          //  adapter.Fill(dataSet);
        //if (dataSet.Tables[0].Rows.Count != 0)
        {
            chartDefinition.Height = new Telerik.Reporting.Drawing.Unit(this.tableTopEmployees.Items.Count, Telerik.Reporting.Drawing.UnitType.Inch);
        }
 
         
         
    }
     
        
private void chart1_NeedDataSource(object sender, System.EventArgs e)
    {
        Telerik.Reporting.Processing.Chart chart =
            (Telerik.Reporting.Processing.Chart)sender;
        Telerik.Reporting.Chart chartDefinition = (Telerik.Reporting.Chart)chart.ItemDefinition;
        chartDefinition.Height = new Telerik.Reporting.Drawing.Unit(50, Telerik.Reporting.Drawing.UnitType.Inch);
      chartDefinition.Height = new Telerik.Reporting.Drawing.Unit(6, Telerik.Reporting.Drawing.UnitType.Inch);
            //chartDefinition.Height = new Telerik.Reporting.Drawing.Unit(this.tableTopEmployees.Items.Count, Telerik.Reporting.Drawing.UnitType.Inch);
        
    }
   But height remain the same as it was initialize which is zero.

Thank,
-Saqib
Steve
Telerik team
 answered on 04 Nov 2010
1 answer
98 views

Hi

In our application we are using Reports.
In that we've using sub reports. In Sub Report  while exporting to excel its works fine
but when we merge that report in Main report ,then export to excel its Showing error - "Error.Png".

We are Using Telerik Reporting Q2 2010, Version  4.1.10.921

Pls have a glance on the attached snapshots and provide me some solution.


Thanks & Regards
Karthik
Steve
Telerik team
 answered on 04 Nov 2010
3 answers
165 views
I have been using Telerik Q1 2009 for some time now, and was forced to upgrade to Q2 2010 due to a performance issue when exporting to Excel large datasets from a report using a Table control

I have got the new reporting version Q2 2010 up and running, however when I run a long report, the "Your report is loading" progress message and animated gif do not display anymore, which makes the page appear to be doing nothing and the report appears to be empty as it shows the toolbar. However, after a few seconds all of a sudden the report appears in the report viewer.  

Does anyone know how to get this working again so that it displays a progress message - I have checked the property in the Report Viewer and the text is there for the ProgressText property.

Thanks!
Peter
Telerik team
 answered on 04 Nov 2010
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?