We have a form that includes a radgrid, and a section at the top where users can specify various filtering criteria (NOT filtering in the grid). When the user activates the filter, there is some code that looks at the various filtering items, and builds a filter string based on which ones are populated.

We also have a report designed to contain the same data as this radgrid, so that users can print the data in a formatted report.

I'd like to pass the filtering over to the report, but the filtering is a string that could contain multiplle variables and expressions, for example;

"startdate >= '01/01/2011' and startdate <= '12/31/2011' and ClientID = 3"
or
"CategoryID = 7 and Description like '%test%'"

Let's say my report parameter is called rpFilter, and rpFilter has the value

 "CategoryID = 7 and Description like '%test%'"

...then I'd like to have my filter expression be just the value of rpFilter with no operator and no comparison value. Is there a way to do that? I am trying to avoid having to generate and deal with a bunch of parameters, since this is going to be used from a number of sources.

Hi
I have a problem because when I try to get a subreport in detail, it seems to be out of place, like subreport of page 1 appears in detail of report on page 2 and goes on

I call the subreport in this way in main report and set the pareter in detail_ItemDataBinding event for get a parameter for actual detail for show or hide this subreport :
 

Do you have any suggestions?
Thanks in advance

I have created my my reports for a WPF application we are in the process of creating. Reports run fine and all parameters are visible and usable by the client. They requested a similiar window frame from our app that would encapsulate the the report window. No problem. I added the same custom features(Borders and whatnot) around the window with no problem. Reports ran fine and everything. The problem then comes that the color scheme of the ReportViewer in WPF is gray and it was requested to be black. Though there is a public property to define the background in XAML it does nothing. I went into Blend again and adjusted the template for the ReportViewer (default was No Brush) and was able to change the border background to the desired color gradient scheme.

The REAL problem is that when I change the default template for the ReportViewer to a new DynamicStyle using my new styles all parameters become hidden. All reports with no paramaters run as desired, but any report that uses a parameter(s) hide the Date Calender, or the drop down menu from the user. What needs to be done to change the ReportViewer look and feel and STILL maintain the parameters for usage?

Any info you could provide would be greatly appreciated.

Tom

I have a report which binds to a Dataset.  Dataset loads an xml file which sometimes doesn't contain all elements (if user didnt specify any data for those elements).  If an element such as 'Name' is missing I will receive "An error has occurred while processing TextBox 'Name': The expression contains object 'Name' that is not defined in the current context".  Instead I just want the report to leave the textbox blank if the binding fails.  Is it possible to somehow supress binding errors if the biniding element doesn't exist?
Thanks, Emil.

When i export my report to MS Excel the image i placed in the report header is not visible,
it is visible in MS Word though, any help would be appreciated.

I've tried a million times and I get the same issue. When I try the stepped layout I get a generation error that states "OBJECT WITH NAME 'Country' ALREADY EXISTS. OBJECTS SHOULD HAVE UNIQUE NAMES".  Yet the query IS bringing back unique names. I looked at the designer code generated and sure enough it is creating children with the same name, not sure why.

When I use the save dropdown to save a report in a format such as excel, the drop down data continues to show even after the report has been saved.  The only way to get rid of it is to close the window.

I'd like to subtotal  items based on a boolean field in the datasource that is not being grouped on.  So my subtotal would look like:


if this were indeed the correct syntax.  It doesn't run and the sub-report just shows a a red box.  How would I create a subtotal that filters on another field in the datasource?

Thanks Much

Jonathan

Hello,

I am developing dashboard reports using Telerik Q2 2011 tools. My question here is how to format numbers with commas (,) for easy reading in the axis appearance properties.

When I use 'Number' value format it shows the decimal places and that is ok for the actual decimal values (see Y-axis2 below image) but I also need to format with commas without decimal positions. E.G. 1,000.

Please see the Y-axis below and I need to use commas to format it. Please help. Thanks in advance.


Srilal

Hello,

I'm just starting to work with Telerik Reporting along with OpenAccess and I'm running into some difficultly that I thought would be relatively straight forward using the two products together.  I'm sure I'm just missing something simple, but I just can't seem to figure it out.

I'm using an OpenAccess DataSource to build a report.  I can pull my object properties and the navigation properties representing my foreign key relationships from the Data Explorer to my report just fine.  However, I can't seem to figure out how to get data from the 1:1 or 1:M navigation properties that are represented as collections.  I've tried using the List control and creating a binding to the child object, but the following error shows up on my report when previewing:

"An error has occurred while processing Table 'list1':
The expression contains object 'MyChildObjects' that is not defined in the current context."

I've noticed in the Data Explorer that when I expand the child object none of the properties show up like when I expand an object representing a foreign key relationship.

I'm trying to pull one instance of the child object collection and include it in the report.  This could either be the first instance or based on some other logic (like a where clause).

Thanks for your assistance,

Al