Telerik Forums
Reporting Forum
1 answer
159 views
Hi Team,$0Can you please mention the maximum number of nested sub-reports or rather we can say levels of sub-reports that we can have in the reporting control?$0$0$0$0$0Thanks in advance.$0$0Vinay$0
Steve
Telerik team
 answered on 09 Sep 2008
11 answers
1.1K+ views
Hi, do you have any information on the 'The handle is invalid' error being generated by a Telerik.Reporting.Processing.ReportProcessor.Print call.  I use default settings in the PrintDocument Object.  The call only fails on a Windows 2003 machine, working flawlessly on a Windows XP machine.  I'm not sure what other info I can provide.

Geoff
Issa
Top achievements
Rank 1
 answered on 09 Sep 2008
4 answers
208 views
I have a ReportViewer on a web page that is set up to view a specific report.   The report has a DocumentName of

= "ReportName-" + Format("{0:yyyy-MM-dd}", Now())

It returns something like ReportName-2008-09-08 when the report is exported.  If I do this on the page with the ReportViewer:

Page.Title = ReportViewer1.Report.DocumentName;

the page's title is set to the expression and not the expression after it is evaluated.  Is there any way to get the evaluated version of that expression in the page codebehind?  Is this a place where I should use a public user-defined function instead?  I'm new to playing with the
Steve
Telerik team
 answered on 09 Sep 2008
10 answers
353 views
I have the problem that the alignment in the design view doesnt match the alignment in the report itself, what could be the issue?

Craig
Top achievements
Rank 2
 answered on 09 Sep 2008
1 answer
118 views
Hi,

I would like to know that if it is possible that in 1 reporting textbox, can I put in data as well as text in it?

For example is in the textbox I want to put something like this.

ex: Thank you [=Fields.name] for coming. We have received your mail from [=Fields.email].

Is this possible to be done in 1 textbox rather than multiple textboxes?

Thanks.

Regards,
Eugene
Steve
Telerik team
 answered on 09 Sep 2008
2 answers
135 views
Hi,

My questions are how to apply the telerik Reporting with this Scenario.

  • We are developing the web application
  • We have 2 database servers development Database server and Production Database server
  • During development we will use the development database server when we deploy to Production will copy the website and change the connection string in web.config
  • Our developer able to design the report and preview in design time with the correct layout
  • After deploy the web application our developer don't have to change the database connection in the report manually it will use the connection string in web.config


After we try we got the problems below;

  • we can't preview the report if we using the connection string from the web.config have to use the wizard to generate the connection for us
  • if we use the wizard we don't know how to change the connection string manual at runtime
  • we need to recompile everything after change the connection string in the report when want to deploy to production server

The current solution

  • we are manual create the connection string by hardcode "see Code #1" it's give us the preview on design time

  • At runtime we rebind the data manual by take the connection string from web.config "see Code #2"  it's give us don't have to recompile the project when deploy to the server





below are the current source code we are using for the moment

    public partial class Report1 : Telerik.Reporting.Report  
    {  
        public Report1()  
        {  
            /// <summary> 
            /// Required for telerik Reporting designer support  
            /// </summary> 
            InitializeComponent();  
 
            sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();  
            sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();  
            sqlConnection1 = new System.Data.SqlClient.SqlConnection();  
            sqlConnection1.ConnectionString =  
                "Data Source=Develop_telerik;Initial Catalog=insurance;Persist Security Info=True;User ID=sa;Password=rYnI@6%33$3kdnOOk";  
              
            sqlSelectCommand1.CommandText = "SELECT * FROM TelerikReport";  
            sqlSelectCommand1.Connection = sqlConnection1;  
            sqlDataAdapter1.SelectCommand = sqlSelectCommand1;  
            this.DataSource = sqlDataAdapter1;  
 
        }  
    }  

[Code #1]


above the code inside the report
It's gave us the preview in design time


         System.Data.SqlClient.SqlCommand sqlSelectCommand1;  
         System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;  
         System.Data.SqlClient.SqlConnection sqlConnection1;  
         Report1 _report1 = new Report1();  
 
         sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();  
         sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();  
         sqlConnection1 = new System.Data.SqlClient.SqlConnection();  
         sqlConnection1.ConnectionString = ConfigurationManager.ConnectionStrings["TelerikConnectionString"].ToString();  
 
         sqlSelectCommand1.CommandText = "SELECT * FROM TelerikReport";  
         sqlSelectCommand1.Connection = sqlConnection1;  
         sqlDataAdapter1.SelectCommand = sqlSelectCommand1;  
 
         _report1.DataSource = sqlDataAdapter1;  
 
         ReportViewer1.Report = new Report1(); 

[Code #2]


above are the code in the ReportView page








Any ideas, to improve the development time or anyone has the sample project like this.

Kind Regards,
Kwan

Thevodka
Top achievements
Rank 2
 answered on 08 Sep 2008
3 answers
254 views
Hi,

I have downloaded the Trial version of TelerikReporting Q2 2008 today.
I have launched the setup. It ask me to specify a Sql server instance. But what this mean : do I have necessarily Sql Server 2005 installed on my machine for run Telerik reporting ? (I have a server Windows 2003 with Sql Server 2000).
I have try to do this:

1. I have try to run setup installing "Examples" but at the end of the setup it gives me this error :
Error -2147217865 : failed to execute SQL string...
So the software is not installed (a rolling back is done)

2.  I have try to run setup without installing "Examples" (so the setup don't ask me the sql server instance name), but at the end of the setup it gives me this error :
H2reg.exe
MS help 2.x runtime files are not installed on this pc
At the and of the setup process a windows shows that the Setup is completed, the checkbox "Launch Telerik Reporting" is selected, then I press "Finish" but the software don't start (it seems that the software is not installed on my pc).In fact, if I open :
Start->Programs->Telerik->Reporting Q2 2008->
I only see the entry "Uninstall".
Can you help me please?

Thanks,
regards,
Maurizio
Steve
Telerik team
 answered on 08 Sep 2008
2 answers
99 views
Hi all,

I'm new to telerik reporting and telerik controls in general, but did a lot .NET the last years.

I just made my first report. I have enabled the localizable property, and I have two cultures. The default and German.

I the designer i shows fine, but when I preview it through the reportviewer control on a webform and changes the culture and uiculture in the thread, when I select the german culture, it increases the font.
It's really weird.

The only difference between the two resx files is one textbox values text. I'm just testing it right now.

The localization part works perfectly. Really smooth approach! I hope this last part can be solved easily too.

Any ideas what this could be?

Kind regards,

Morten, Denmark
Morten Louw
Top achievements
Rank 1
 answered on 08 Sep 2008
1 answer
251 views
I glanced briefly at the telerik solution for grouping a report by month by using a custom DateTime object. I then decided to just try adding a column to my select command that would would return the month/year as a string as in:

RIGHT('00' + CAST(DATEPART(mm, TestDate) AS varchar(2)), 2) + CAST(DATEPART(yyyy, TestDate) AS varchar(4))

example: 092008

I then grouped by this and seems to work fine.
Chris Gillies
Top achievements
Rank 1
 answered on 08 Sep 2008
2 answers
116 views
I was going along fine working on my report in the designer and everything was working. Then I attempted to change the fill query on my report XSD. Now I kee running into connection issues. Whenever I try to change anything I get the following error:

An attempt to attach an auto-named database for file ...... Database1.mdf failed.

Ifound found all kinds of posts all over the net with frustrated developers. I am not using asp.net. This is a standard win forms app using the latest Telerik Reporting component. The report and xsd are in a separate project as per the documentation.

Any ideas?
Steve
Telerik team
 answered on 08 Sep 2008
Top users last month
Simon
Top achievements
Rank 2
Iron
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Marco
Top achievements
Rank 4
Iron
Iron
Iron
Grant
Top achievements
Rank 3
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?