Telerik Forums
Reporting Forum
7 answers
371 views
How do i localize the text that is written in the bottom when pagination is done in the radgrid. For Example text which displays the page number "Page No. 1 2 3" or text of "Items"
The text in the given quotes need to be in local language selected by the user on the page.
Paul Herzberg
Top achievements
Rank 1
 answered on 20 Aug 2013
1 answer
84 views
I see according to your documentation that references to Telerik.Windows.Controls, Telerik.Windows.Controls.Input, Telerik.Windows.Controls.Navigation, and Telerik.Windows.Data are all needed to use the ReportViewer within an WPF app.

Does that mean that I have to purchase a license for the RadControls in order to develop and ship my app using your Reporting app, or can I use the Trial versions of the RadControls to develop and ship my app?

According to this thread it looks as if I could just use the Trial versions, but that was from 2012 so I'm unclear as to how to proceed.

Thanks in advance.
Peter
Telerik team
 answered on 19 Aug 2013
3 answers
177 views
Is there a way to hide the x-axis line but still show the x-axis labels in the Telerik.Reporting.Chart?

For instance, we have situations where we have to do custom code to reverse the Y-axis to make certain information make sense. Our x-axis is at the top instead of the bottom (yaxis of 0 in the screen shot attached) so we get an odd occurrences where it throws off the set steps (y-axis steps are set to 5 but the intervals are in 4) and the x-axis is drawn on top of the series (shown in screen shot).
I found the option to hide the xaxis but as expected it also hides all of the ticks and labels along with the xaxis line which is not an acceptable solution. In the screenshot attached both major/minorGridLines for the Yaxis are currently off. The only line being shown is the X-Axis.
Stef
Telerik team
 answered on 19 Aug 2013
1 answer
404 views
Hello everyone,
I have a question regarding named connection strings.  I'm sure this question or something similar has been asked, but I'm not finding a clear answer or a best approach documented. There is so much posted out there...it's a lot to wade through.  For the record, I'm using Telerik Report Q2 2013.

Here's my situation.  I'm creating reports for web projects in separate solutions.  Inside a web.config file for a particular web project, I have a connection string named say "MyDBContext".

In my report solution where I create my reports for this particular project.  Let's call it MyReports.  I use the report wizard, I "Add New Data Source", choose "SQL Data Source", give it name or accept the default one, specify the connection string (using SqlClient Data Provider), and I do "Save this connection string with a name that I hope to be used when this report is executed in my web project.  In this example  "MyDBContext" to match the named connection in my web project. 

What I see is that the SqlDataSource in that report actually has the full data source specified in the ConnectionString property rather than just a reference to the connection string that was added to my app.config file.  I can change the connection string to reference the named connection string; however, instead of it being just "MyDBContext", which would work in my WebProject, it is called "MyReports.Properties.Settings.MyDBContext", which of course, will not match the connection string in my web project and so I won't be able to make a successful connection when using the report DLL there as is.   What I am doing is renaming the named connection in my app.config from "MyReports.Properties.Settings.MyDBContext" to just "MyDBContext" and then changing the ConnectionString property in my report's datasource to be just "MyDBContext"

Is this the right approach ?  We are new to using the Telerik reporting product and I would like to start out with best practices.  Unfortunately, there is so much information out there, it's difficult to determine what those best practices are.

Any thoughts or suggestion would be greatly appreciated.

Thank you -- Jeff Gaiche
Peter
Telerik team
 answered on 19 Aug 2013
1 answer
307 views


How to I specify the scope as the report?


I am binding a datasource to the report programmatically.
I am not using a table to display the detail data, only textboxes which display field values using "[=Fields.FieldName]".

Thanks.


I want to get this, i use TextBoxs in my detail.

  A                  X                 Y                   Z  (X-Y accumulative)
  a                10                 2                   8
  b       6                 3                  11
  c                  0                 5                   6
Squall
Top achievements
Rank 1
 answered on 19 Aug 2013
2 answers
138 views
Hello All,

I have a report which works fine and it is set to my report viewer.  I have the SQL select statement hard coded.  I have a dropdown box on the same page and I want to append that user name to the select statement.  I am a bit confounded on how to change the select statement.  Here is the code and I want to dynamically hand in the user id (which is 4 in my hard coded case).  I know how to get the selected item out of the dropdown...it just isn't clear how I get the web page to hand it into the report.  Any thoughts? 
Thank you.
William

public ReportClass()

{

StringBuilder sb = new StringBuilder();

InitializeComponent();

 

sb.Append("select SY.name_system, SE.id_employee, SE.id_system, SE.id_user, SE.date_change").Append(" ");

sb.Append("from Secured SE").Append(" ");

sb.Append("inner join Systems SY on SY.id_system=SE.id_system").Append(" ");

sb.Append("where SE.is_active=1 and SE.id_employee=").Append("4").Append(" ");

sb.Append("Order by SE.date_change DESC");

sqlSource.SelectCommand = sb.ToString();

txtRunDate.Value = DateTime.Today.ToShortDateString();

}



William
Top achievements
Rank 1
 answered on 17 Aug 2013
11 answers
158 views

in the Q1 2012 release of the Silverlight Reporting control the attribute

telerik1:StyleManager.Theme="Windows7"

isn't working anymore.
I get the error:

Fehler 85 A ResourceDictionary '/Telerik.Windows.Themes.Windows7;component/Themes/Telerik.ReportViewer.Silverlight.xaml' cannot be found. Please make sure that references to the needed theme assemblies have been added to the project. C:\Documents and Settings ...

Is it possible that you forgot to implement this style?

Regards
Dirk

Stef
Telerik team
 answered on 16 Aug 2013
1 answer
1.3K+ views
I tried to add a Report in my MVC project and tried to add SQL datasource to the report.
At Configure DataSource Command I have selected Stored Procedure and my selected stored procedure contains two parameters of type datetime.
On ExecuteQuery when I give value "07/01/2013" for parameters of type datetime error occurs saying "Failed to convert parameter value from a string to a DateTime."
Tried giving the above value in following formats but still error persist.
"07/01/2013"
'07/01/2013'
20130701
Please help me out from this and I am new to telerik reporting.

Any help would be appreciated. Thanks in advance.
Ivan Hristov
Telerik team
 answered on 16 Aug 2013
2 answers
185 views
Hi all,

I'm hoping someone could tell me how to implement some custom logic around page breaks & borders in a telerik report.

Please see the attached "output screenshot.png". The issue should be obvious - I need to put a bottom border on the top page, and a bottom border on the middle page, at the point that the page has broken.

I wish to be able to tell from a condition (or property on the report) whether the current row in the DetailSection is the final one on any page so I can insert a horizontal line in places like after point 4.2 (top page in screenshot). Using a page footer is not suitable because of situations like after condition 4.5 (middle page in screenshot), where the subsequent item is long so the page breaks further up the page. Unless, there is a way to tell how much of the page has been cleared by the page break, so I would be able to extend the vertical bars down to the bottom?

At the moment, the vertical bar length in each row is bound to a method, which calculates it based on the length of the text, so it appears as one long continuous vertical bar.

Can anyone tell me how to implement this?
Stef
Telerik team
 answered on 16 Aug 2013
2 answers
209 views
Hi
I have a small test website on the untrusted side of my firewall and I need to know what port telerik uses to pass parameters to a stored procedure.
I can access the db fine when the SQL is embedded in the report but not when it is using a stored procedure.
Thanks
Andy
Hadib Ahmabi
Top achievements
Rank 1
 answered on 16 Aug 2013
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?