I am running a report off a query that is using a LEFT OUTER JOIN to ensure that dates are included even if there is no data for the dates. (See the bottom of this post for the query).


I am displaying the data in a crosstab report, using the dates as columns. The ideal is that if there is no data for the date then each value in the column displays blank.

This is working. The problem is, if the crosstab has one or more blank columns, then a blank row with no header appears as well..

The attached image shows two crosstabs. The range "11 August to 17 August" has no empty dates, so subsequently there are no empty rows.
But the range "18 August to 21 August" happens to have empty dates. The columns are correctly empty, but there is one group row that has no header.

 I can understand why this is so, but how can I make the blank row go away? My guess is that there's some filtering condition along the lines of "if VideoGroupName IS NOT NULL", but I can't seem to find a way to filter away nullness.

Hello All,

I wanted to create table that has 5 rows regardless of number of entries returned from database. For example if there are only two entries in the database, table should display those entries and also display three emptry rows.

I tried to add those rows manually, but it seems very hard and counter intuitive.

Your help would be greatly appreciated, thanks.

Kind regards,
Ben

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

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,

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.

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.

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

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

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();

}