I'm wondering the best way to do this.  Also I'm using silverlight report viewer so I can't give the reports the dataset.

I basically want to make the selectCommand dynamic like
Select a,b,c from tableA where d=1
if @paramter1="Z" then add " and z=1 "  to the query
Select a,b,c from tableA where d=1 and z=1

I could do this by stored procedure, but I'd rather not add another stored procedure to my database.
I could use filters, but I'm going to get too many rows back.

Can I make another SQL DataSource and bind it to my Report based on a parameter I send in?
Can I use iff() in the selectCommand ?

Using a stored procedure will work ok for me.  Just wondering if there's another way.

Hello,

I have a couple of pictureboxes in my report.  I programmatically bind an image file to a picturebox object using the following code.

pictureBox_Specimen1.Value = System.Drawing.

Image.FromFile(sketchpath.Path);

 

Before the report is created/displayed I can modify the image located at sketchpath.path.  After I open the report and then close it, I am no longer able to perform any IO on the image until I restart my application.

How do I have the report release the image resource?

In the report dispose event I have set the picturebox value to null and this does not help.

Any help would be greatly appreciated!

Instead of just generating report we want our customer to design their report layout themselves (just like the telerik report designer add-on for Visual studio 2010). Is it possible for us to get/buy your report designer so that user can drag and drop what they want in Silverlight.

Thank you.

I'm evaluating Telerik Reporting at the moment to see if it fits our needs for our WPF based application and would like to ask a few questions:

- In your "Known Limitations" stickied post you mention that a "search" feature is not implemented yet. Does that mean there is no support for text search (think ctrl+f like search) in the report viewer so that users can search for specific text strings? If true, can you give me an idea when you are planning to implement this feature? This feature is very important for us because we have some large reports where users sometimes look for specific text items and would be lost without a proper search function.

- Is it possible to hide the toolbar in the WPF viewer and implement our own controls for "next page", "print" etc.? Does the WPF report viewer support WPF command bindings for these functions?

- Going a step further from the previous question: In what extend does Telerik Reporting support the WPF binding engine? I mentioned command bindings for the viewer but can you give me some more details on this topic and/or future plans?

Many thanks!

Hi,

I'm using a demo version of telerik reporting 4.1.10.921, the demo is working very well, we have a report with an image inside, we need to change this image for another one.
In my local machine is working, the image was changed, but, when I publish (by the way, I'm using visual studio 2010 with SL4 and WCF services) the image doesn't change, I delete the project completely from the server, I create the project again... and nothing changed, I don't know what to do, and I don't know from where is getting the previous image.
There are no problems of configuration, the report is working well it's just the image that is wrong.

Any idea?
Thanks a lot.

Hi,

I Got some problems with the reportviewer.

Error:


My code ReportViewer.aspx


ReportViewer.aspx.cs

Hi, im trying out telerik reporting and im stuck on a (simple?) problem.

Im using the crosstab and im trying to add a row group with an expression with a custom function, like this.

= MyComparer(Fields.A). That works. My problem is when i want to apply my comparer to "Fields" of that expression. Now = MyComparer(Fields) dosent work, but you understand what im trying to do. But what should i apply my function to?
the global object ReportItem gets me the object that my Detail is bound to, not the one my crosstab is iterating over currently.

Hello

I am trying to evaluate the reporting tools in and ASP.NET (VB) application. I followed the 'Creating a simple report' example in the Help file and I get the following message after I rebuild the application and click on Preview :
'the source of the report definition has not been specified'

Regards
James

Hi Guys (and girls),

I have a super interesting bug.

I'm using the AJAX Telerik Report viewer inside an MVC project.

The parameters of the report are actually set programatically.
I have an AJAX.Form that lets the user set some parameters. This will draw a report by overriding the parameters like so:


It never finishes rendering. it just sits there on "Generating report"

The report it is binding using a sql dataSource.  I've put a trace on the sql server and i can see it endlessly hitting the stored procedure the datasource uses. (It also endlessly calls [sp_procedure_params_100_managed] passing_in_the_SP_name)

any idea what is going on?
Could it be caused by having a table sitting in the details section (this always makes me feel weird).

Regards,

Hi,

I am looking at purchasing telerik reporting I do have one question. Is it possible to implement something so users are able to export specific fields returned in the report e.g. if a report returned first name, last name, age and occupation, let the user select to export only last name and occupation or any other combination?

Thanks,

Jay