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();
            }
             

Hello everybody,

I want to pass a dynamic DataSet which has been generated by
an outside code (request) to telerik's report.

Exemple



and after, the result is going to be a report with the dataSetReport's data...

I searched everywhere but i found nothing...

Can someone help me?

Thanks...
Daniel Botero Correa

In my application, I have List of fields ,related binding fields,Width alignment etc configuration in On Table in DB.On Silverlight application UI user can select fields those he want to display in report(Not all which are exist in table).So I want to create Report's design and binding Dynamically.For that I need to pass List<T> to report which contains Field related configuration(width,Label,Binding Field,Width etc).If I can do that,I will be able to bind data with that table using dynamic Stored Procedure.But in Silverlight,I do not have reference of Report into Silverlight application,as it is in class library.I am not able to get that Report's Object.Please suggest me what to do in such case?

How to hide Refresh button ?

How to add a “Bookmarks” label above the report bookmark list?

My developers are constructing a stacked bar chart, and have included a datatable to show the values of the stacked elements. The user has also asked to see the total value for each stacked bar. There are references to changing the label of the last series to show the total, using STSUM, but it appears this also changes the display in the datatable (so that the last series shows the total in the datatable as well).

Any suggestions on including BOTH the datatable and a stacked bar total, either in the datatable or as a label on the bar?

Alternatively is it possible to have a bar value which shows in the datatable but NOT in the chart?

TIA