Telerik Forums
Reporting Forum
27 answers
3.0K+ views
Hi,
     I have been evaluating Telerik reports for a few days now. I like what I have seen so far. I need to know one thing before I make a final decision. We have a requirement to merge different reports and export them in PDF format. The number of reports and type of reports vary depending on users search criteria.
    I know we can add sub report items programmatically. Is there a limit on the number of sub report items you can add programmaitcally. If so what is the limit. Also do you have any samples in C# that will show me how to add sub report items programmatically.
       I created a small sample that creates sub report items programmatically. In the report viewer it's showing okay. But when I export it to PDF format the sub report items are overlapping. 

Thanks
Bhaskar
Peter
Telerik team
 answered on 21 Aug 2013
4 answers
129 views
Please see the attached pie chart - I've 14 possible different series in this chart - but there are chances that some of the series can have "0" as their value.  On the graph I don't want to show 0.00%.  Can you please help me achieve this - I used the graph wizard to generate this graph.

Thanks,
Neepa
Top achievements
Rank 1
 answered on 20 Aug 2013
7 answers
440 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
105 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
228 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
461 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
396 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
178 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
188 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.4K+ 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
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?