Telerik Forums
Reporting Forum
2 answers
142 views
Hi there,

I'm adding cascading parameters programmaticaly and code works fine in Visual Studio 2008 ( Q2 2009 SP1, WebForms.ReportViewer), but in 2010 all parameters disappear when value of main parameter is choosed.

How can I make it work?
Cheers,
Yana

private void addParameters()
        {
            // Create prm Bearer
            Telerik.Reporting.ReportParameter Bearer = new Telerik.Reporting.ReportParameter();

            Bearer.Name = "Bearer";
            Bearer.Type = Telerik.Reporting.ReportParameterType.Integer;
            Bearer.UI.Visible = true;

            Bearer.UI.AvailableValues.DataSource = new int[] { 1, 2, 3, 4 };
            Bearer.UI.AvailableValues.ValueMember = "Item";
            Bearer.Value = 0;

            // Create prm Metric
            Telerik.Reporting.ReportParameter Metrix = new Telerik.Reporting.ReportParameter();
            Metrix.Name = "Metrix";
            Metrix.Type = Telerik.Reporting.ReportParameterType.Integer;

            Metrix.UI.AvailableValues.DataSource = new int[] { 1, 111, 1111, 2, 22, 222, 2222, 3 };
            Metrix.UI.AvailableValues.ValueMember = "Item";
            Metrix.UI.Visible = true;

            string filterExpression = Metrix.UI.AvailableValues.ValueMember;
            Metrix.UI.AvailableValues.Filters.Add(
            "=" + filterExpression, Telerik.Reporting.Data.FilterOperator.In, "=GetBearer(Parameters.Bearer)");

            this.ReportParameters.Add(Bearer);
            this.ReportParameters.Add(Metrix);
        }
        public static int[] GetBearer(int bearer)
        {
            switch (bearer)
            {
                case 1:
                    return new int[] { 1, 11, 111, 1111 };    
                case 2:
                    return new int[] { 2, 22, 222, 2222 };
                default:
                    return new int[] {};

            }
        }
yana roze
Top achievements
Rank 1
 answered on 01 Nov 2010
2 answers
165 views
I have a report that has textboxes and subreports on the detail line

I am trying to make all these boxes the same height, I have a textbox where the data will wrap and i want to make all the other items on the detail line the same height as this box. the main problem that i'm having is setting the height on the textboxes on the sub reports. The sub report also includes a cross tab table.

at runtime when on the Item databound the height of the item is only giving the default value not the height it has growen to during the wrap.

is there any way to get the actual height from the textbox?

Thanks
David
Top achievements
Rank 2
 answered on 01 Nov 2010
2 answers
79 views

Hello,

 

I am trying to create a textbox that reads APPLICATION NAME from a table and displays it in the footer of the report.

 

I have created a class with following code:


Public Class CVA_Rpt
  
Public Shared Function Get_Config_Item(ByVal Item_name As String) As String
  
Dim mySelectQuery As String = "SELECT Constant_Value from tbl_CVA_Config Where Constant_Name='" & Item_name & "'"
  
Dim myConnString As String = ConfigurationManager.ConnectionStrings("CVA_Reporting").ToString()
  
Dim myConnection As New SqlClient.SqlConnection(myConnString)
  
Dim myCommand As New SqlClient.SqlCommand(mySelectQuery, myConnection)
  
myConnection.Open()
  
Dim myReader As SqlClient.SqlDataReader
  
myReader = myCommand.ExecuteReader()
  
' Always call Read before accessing data.
  
Get_Config_Item = ""
  
While myReader.Read()
  
Get_Config_Item = myReader.GetString(0)
  
End While
  
' always call Close when done reading.
  
myReader.Close()
  
' Close the connection when done with it.
  
myConnection.Close()
  
End Function
  
Public Shared Function Application_Name() As String
  
Application_Name = Get_Config_Item("APPLICATION_NAME")
  
'Application_Name = "CVA Reports"
  
End Function
  
End Class


During design time, I enter the following in a textbox of the footer:
= CVA_Reports.CVA_Rpt.Application_Name()

I get the following error when previewing the report:
An error has occurred while processing TextBox 'txtApp_Db_Name':
An error has occurred while executing function App_name(). Check InnerException for further information.
------------- InnerException -------------
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
Object reference not set to an instance of an object.

Note: I testing the CVA_Reports.CVA_Rpt.Application_Name() using a ASP page and it returns the desired value.

How can fix this error ?  I have looked everywhere on how to fix this error.  I have no clue. Please help.  THANK YOU!

Massimiliano Bassili
Top achievements
Rank 1
 answered on 01 Nov 2010
1 answer
140 views
Hi!

I'm very pleased to see that XML Report Serialization will be included in the upcoming Q3 2010 release.
Would you please tell me if existing reports made prior to the Q3 release can be converted to XML report definitions?

Thank You!
Sverre
Steve
Telerik team
 answered on 01 Nov 2010
0 answers
555 views
Nevermind. Math helps.
Eric Wallace
Top achievements
Rank 1
 asked on 30 Oct 2010
1 answer
144 views
I have a report with the following grouping sections: ( groupHeaderSection1 > groupHeaderSection2 > labelsGroupHeader )
The values ot groupHeaderSection1.DocumentMapText  and groupHeaderSection1.DocumentMapText have been set to different field values and display in the UI.  However they are at the same level under the report entery.  The expected result would be that the values would be nested in groups.  
imo - The documentation on the DocumentMapText is very limited on this and could be expanded to include more detail.  
Peter
Telerik team
 answered on 29 Oct 2010
1 answer
132 views
I am using the telerik report control. On my local machine it runs fine, but when I publish to the website using VS2008 i get this error when I am trying to run it.

Server Error in '/' Application.
--------------------------------------------------------------------------------
  
Configuration Error 
Description: An error occurred during the processing of a configuration file required to
service this request. Please review the specific error details below and modify your configuration
file appropriately. 
  
Parser Error Message: Could not load file or assembly 'Telerik.ReportViewer.WebForms, Version=4.1.10.921,
Culture=neutral, PublicKeyToken=a9d7983dfcc261be' or one of its dependencies.
The system cannot find the file specified. (C:\Inetpub\CEMM\web.config line 45) (C:\Inetpub\CEMM\web.config line 114)
  
Source Error: 
  
  
Line 112:    <httpModules>
Line 113:      <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
Line 114:      <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" />
Line 115:      <add name="RadCompression" type="Telerik.Web.UI.RadCompression" />
Line 116:    </httpModules>
   
  
Source File: C:\Inetpub\CEMM\web.config    Line: 114 
  
  
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3615; ASP.NET Version:2.0.50727.3618

Line 114:      <add name="RadUploadModule" type="Telerik.Web.UI.RadUploadHttpModule" />

Is there a dll file I can physically move to fix this problem and if so what is it called?
Peter
Telerik team
 answered on 29 Oct 2010
1 answer
118 views
So everything I've read says that the HTML reports will be paged based on the 'PageSettings' fields. Can you elaborate on this? When I place my report in a ReportViewer on a web page, I always get 2 pages: 1 with all of the records, the other is blank with only a footer. 

It seems to me like there are two issues, but I cannot find any further documentation on the PageSettings for HTML output paging, and I also cannot figure out why that second page is printing. I've checked that the margins + padding + table width do not add up to more than the report width. Anything else to check for?

Your help is appreciated.

~Scott McNeany
Steve
Telerik team
 answered on 29 Oct 2010
1 answer
376 views
I have a MySQL data source that I want to use with Telerik.  Using the Data Source configuration wizard, I was able to point to my database, and access the stored procedures.  One thing I am not able to do though, is to get telerik to pick up my parameters in my query (whether it is in a stored procedure or if I enter the query in the wizard.  I tried a sql server data source, and it seems to pick up @ parameters just fine.  Is this a limitation of Telerik, or is there something special you have to do in this scenario?

Thanks,
Sasan
Steve
Telerik team
 answered on 29 Oct 2010
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?