Telerik Forums
Reporting Forum
4 answers
164 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
307 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
96 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
114 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
213 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
85 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
198 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
85 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
4 answers
290 views
hi I have a RadGrid that gets data from an objectdatasource. At runtime I have manipulated the data represented in RadGrid by applying some filters and groups.

Now I want to export the data in RadGrid (with current filters and groupings applied) into a Tererik Report which is placed in a Telerik Report Viewer on an .aspx page.

is there a convenient way to achieve this?

thanks in advance
Bruno
Top achievements
Rank 2
 answered on 06 Sep 2008
1 answer
459 views

what datetime functions does =now() support, i was trying to set a parameter default value to =now().AddDays(-1).Date but now() does not seem to return a true datetime. Is there a way to do this



thanks
kevin
Steve
Telerik team
 answered on 04 Sep 2008
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?