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

I need to create a report programicly.  if i have a text box and that will be filled with the Text "foobar" at Arial 10 bold.  how do i calculate the length.  Below is what i need to achieve.   is there a way to calculate the length to place in the code below without guessing..  

 

 

new

 

 

Telerik.Reporting.Drawing.Unit(0.800000011920929D, Telerik.Reporting.Drawing.UnitType.Inch)

 

I just upgraded Telerik Reporting to Q3 2009 (version 3.2.9.1211), and now I receive an error whenever I try to open a report in design mode in Visual Studio 2008:

 

Type 'Telerik.Reporting.Drawing.Unit' does not have a constructor with parameters of types Double, UnitType.

 

Granted, I am new to Telerik Reporting, but the code hasn’t changed, and it still works fine with Telerik Reporting Q2 2009.  It looks to me like the new version still does have a constructor with that signature, and my reports do indeed compile and run just fine.  Unfortunately, I can’t open them to edit them.

 

This is the call stack it gives me:

 

at System.ComponentModel.Design.Serialization.DesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer)
at System.ComponentModel.Design.Serialization.DesignerSerializationManager.System.ComponentModel.Design.Serialization.IDesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer)
at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeInstance(IDesignerSerializationManager manager, Type type, Object[] parameters, String name, Boolean addToContainer)
at System.ComponentModel.Design.Serialization.ComponentCodeDomSerializer.DeserializeInstance(IDesignerSerializationManager manager, Type type, Object[] parameters, String name, Boolean addToContainer)
at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeExpression(IDesignerSerializationManager manager, String name, CodeExpression expression)
at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializePropertyAssignStatement(IDesignerSerializationManager manager, CodeAssignStatement statement, CodePropertyReferenceExpression propertyReferenceEx, Boolean reportError)
at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeAssignStatement(IDesignerSerializationManager manager, CodeAssignStatement statement)
at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeStatement(IDesignerSerializationManager manager, CodeStatement statement)

 

I tried the "Ignore and Continue" option, but that just gives me another error.  Does anyone have any clue as to what I may have done wrong, or what I can do to correct this problem?  Thank you very much.

Shaun

Hi,

I have followed the online tutorial/video to create a report and embed it within my Silverlight project. This works fine when running under the Visual Studio Development Server and the report displays (Only displaying static text for now). As soon as I change it run on the local IIS server (IIS 7.5), the report simply displays "Object reference not set to an instance of an object." I am able to access the report service from the web browser and that is working fine.

If I then switch it back to the VSDS, it works again.

Any ideas?

Regards,
Drew

I have an application where we would like to combine several individual reports into one master report.

I created all six of the sub-reports, and they each have specific report header sections which describe the content.

When embedding these reports, I need to suppress the display of the report header.

I am thinking I can either make that section invisible by default, and then change to visible when the report runs all by itself.

Or the opposite, making the header invisible when I detect that the report is contained inside a parent report.

Question #1: is there a way within the sub-port code to determine if there is a "parent"?

Question #2: is there a way to access the sub-report header setting (visibility) from within the code of the master report?

As an example, in another thread I learned how to set properties in the main report. I am lacking in the knowledge of how to dig deeper into the content of the subreports. In effect, "....some kind of cast....some report property.....find something or other inside subreport1..."