Hi,

We've been using Telerik reporting for a while and now out data has gone bigger. Our telerik report appears to be timing out on our stored procedures. I've set a timeout value on the SqlCommand withing the report but it still seems to timeout ~60 seconds.

Is there any other way of configuring the timeout? I'm guessing since it's WCF based, it can be done within the config file.

Thanks,

Hi, 

I have a Line Chart Setup and it is working great with one ChartSeries. However when I add two sets of data my legend overlaps my labels. Is there any way to prevent this ? My Chart could have 1 set of data or 5 sets of data and my legend should be able to accomdate that. Any help would be appreciated. 

Thanks, 

Stefen 

Is a have a report created which shows a basic shape and a textbox with the value of [= Parameters.SomeParameter.Value].

I have code in my Silverlight client which passes the param as  in the RenderBegin event.  This code fires off, but I just receive an error from the Silverlight Report Viewer of:

One or more parameters are not set or have invalid values.

Can I bind to just report parameters?  I am doing this because it is ungodly hard to pass over my objects for the report from the Silverlight client.

How do I set up gridlines so it looks like the data is in a table with lines. Like Excel. I've search the docs and forums but cant find what I'm looking for.

Long week, sorry if this doesn't make sense.

Andy

I have a fairly basic tabular report. If I export the report to excel and then try to sort it I get an error that it can't sort because the merged cells are not all sized the same. I don't need or want merged cells in the excel file. How can I get the excel export to not merge cells?

Hello 

I need to create (reporting) chart on aspx codebehind programmaticaly. I couldnt find out how to do it .  All  programmaticaly examples which i ve seen were creatiıng programmaticaly chart on report.cs instead of aspx.cs.

Im waitin for ur helps.

Thanks..


 

Hi,

I'm trying to set height of table element in report. Whatever I enter as value height in pdf reportheight is always bigger. I want to set for example height to 0,4 cm but in report its more then 1 cm. I try to set cangrow to false but no use. I aslo try to set value to 11 cm and then height is like that.

Paddings are all set to 0 and I dont know why row height cannot be like I set in designer (0,4 cm). You can see in pictures what I'm talking about.

Marko

Recentelly Installed 5.0.11.316 version of Telerik.ReportViewer.Silverlight
But I am getting attach error please let me know how we can resolve it!

Thanks,
Ed

 Hello,

I have report datasource like the following:

SELECT

 

 

 

 

,firstname

 

 

 

,lastname

 

 

 

,email

 

 

 

,amount

 

 

 

,dcomments

 

 

 

 

 

FROM

 

[donation]

WHERE

 

firstname LIKE '%'+@firstname+'%'

 

OR

 

lastname LIKE '%'+@lastname+'%'

 

How do i pass @firstname parameter value from report. I am trying to display textbox where user can key in but i could not. I can do dropdown for firstname but i am trying to do textbox.

Do you have any example for my issue?
Thanks,

Hi
I have placed a Textbox in Report header section and name it prm2
i set its value in Report_NeedDatasource event but its value are not displayed when preview the report
For other non cross tab reports it works fine 

Here is my code

 private void crosstab1_NeedDataSource(object sender, EventArgs e)
        {
            SqlConnection CN = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
            SqlDataAdapter adp;
            try
            {
                string strQuery = "", strWhere = "";
                //--- Criteria
                string vToDate = sftParser.NullToVal(prm["toDate"]);
                string vFromDate = sftParser.NullToVal(prm["fromDate"]);
                if (vFromDate.Equals(""))
                    vFromDate = common.registry.getOpeningDate();
                if (vToDate.Equals(""))
                    vToDate = "2050-12-12";
                 //-----------------------------------------------------------------------
                strQuery = @"Select ExternalCode,ProductName,PackingName,WareHouseId,WareHouseTitle,Type,SUM(Qty) as Qty
                    FROM         StockTransaction ST 
                    WHERE    ST.TransactionDate>=@FromDate And ST.TransactionDate<=@ToDate
                    Group by Pro.ExternalCode,Pro.ProductName,PP.PackingName,WH.WareHouseId, WH.WareHouseTitle,Type";

                cmd.CommandText = strQuery; cmd.Connection = CN;
                cmd.Parameters.AddWithValue("@FromDate", vFromDate);
                cmd.Parameters.AddWithValue("@ToDate", vToDate.Equals("") ? null : vToDate);
                
                //passing null value to parameters not supplied
                foreach (SqlParameter Parameter in cmd.Parameters)
                {
                    if (Parameter.Value == null)
                        Parameter.Value = DBNull.Value;
                }
                adp = new SqlDataAdapter(cmd);
                
                DataTable tbl = new DataTable();
                adp.Fill(tbl);
                adp.Dispose();




                Telerik.Reporting.Processing.Table table = (Telerik.Reporting.Processing.Table)sender;
                table.DataSource = tbl;
                //-------------------------------------------------------------------------
                vToDate = sftParser.NullToVal(prm["toDate"]);
                this.prm2.Value = "From: " + String.Format("{0:dd/MM/yyyy}", Convert.ToDateTime(vFromDate)) + " To: " + (vToDate.Equals("") ? " All " : String.Format("{0:dd/MM/yyyy}", Convert.ToDateTime(vToDate)));

               // or apply this did not work
 Telerik.Reporting.TextBox txt = this.Items.Find("prm2", true)[0] as Telerik.Reporting.TextBox;
                txt.Value = "From: " + String.Format("{0:dd/MM/yyyy}", Convert.ToDateTime(vFromDate)) + " To: " + (vToDate.Equals("") ? " All " : String.Format("{0:dd/MM/yyyy}", Convert.ToDateTime(vToDate)));
               
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                cmd.Dispose();
                CN.Close(); CN.Dispose();
            }