I am very green with reporting in general.

I am using VS2013 to design a simple report.

- I created a report and a data source.

- I added a report parameter and a data source to show a list of available values.

 

My question:

1) How do I take the report parameter and tie it to my data source?

 

For example the data source is simple "SELECT * FROM BOOKS"

I would like to set up as "SELECT * FROM BOOKS WHERE BOOK_TYPE  = [MY PARAMETER]"

I manually added the following to my SelectCommand for the data source

SELECT * FROM BOOKS WHERE BOOK_TYPE  == Parameters.ReportCodeParam.Value

However that didn't work.

On the data source I also see a Parameters property.  When I go to that property I don't see the parameter that I created on the report.

 

Please advise.

 

Hi,

Is there a way to set the value of a multivalue parameter in the data source wizard for debugging purposes?  The design time property value I mean.

Thanks,
Darren

I have a report with a multivalue parameter. It works fine in preview. But I tried to pass selections from my own multi-select combo box (selection is string type) from jQuery.fn.telerik_ReportViewer, it doesn't work, see below. What's the correct syntax ?

$("#reportViewer1")
                  .telerik_ReportViewer({
                      serviceUrl: "api/Reports/",
                      templateUrl: 'ReportViewer/templates/telerikReportViewerTemplate.html',
                      reportSource: {
                          report: "ReportLibrary.test, ReportLibrary",
                          parameters: {                               
                              para1: " 'test1', 'test2'"                     
                               }
                      },
                      viewMode: telerikReportViewer.ViewModes.INTERACTIVE,
                      scaleMode: telerikReportViewer.ScaleModes.FIT_PAGE_WIDTH,
                      scale: 1.0,
                      ready: function () {
                          //this.refreshReport();
                      }
                  })

I am using a datetime as the control for a group. It seems that the group control does not use the formatted value of the value as the grouping criteria.  So, how can I get a group to only group on the date part and not on the datetime part?

 

Hi, i have only one html text box that shows data of an SQLdatasource column i detail of my report but the data displays in separated rows as below file.

but i want this numbers display next to each other to fill free spaces. how can i do this?

 

 

Dear fellows,

i have created a report with a parameter and standalone this is working as expected.

What i want to do is: add multiple reports (same type) with different parameters to following up pages in a report book

my code:

As a result i am getting two pages with the filter applied to page1. page2 is not shown or simply the parameter does not have effect.

Any suggestions where i am wrong?

Kind regards

Martin

After migration from VS 2010 to VS 2013, my report return javascript error. The installed version is telerik reporting Q1 2012.

SCRIPT5009: 'ToolbarImageButton' is undefined

ReportInterventi.aspx, line 591 character 13
SCRIPT5009: 'ToolbarImageButton' is undefined

ReportInterventi.aspx, line 603 character 13
SCRIPT5009: 'ReportToolbar' is undefined

ReportInterventi.aspx, line 608 character 10

SCRIPT5009: 'ReportViewer' is undefined

ReportInterventi.aspx, line 631 character 7

Does anyone have suggestions?
Thanks for the help
Monic

When a report is huge (> 50 Pages), I always receive an error message : Request Timeout.

I checked my query from backend. It takes only 4 second the get the result.

I have tried to change the SQL select command's Command timeout = 1200.

What setting I can changed to extend the timeout so that report viewer can shows the result?

Thanks

hi.
I have a report that have 1 group, in detail of this group i have 1 textbox that get data from sqldatasource. i want this textbox to show data next to each other but it shows them in seprated rows.
for example this textbox should show all names.
supposed:
Dave     Matt     Nick     Beth
Jack      ......
But result is:
Dave
Matt
Nick
....
How can i solve this?
Regards

Hello Community

 I am working with Reporting using HTML5 Report Viewer. I have designed Custom Report Resolver for showing up the reports. It works like a charm. I am facing issue regarding how to pass custom error message from Report Controller. I have checked some links regarding localization given in forums which says to add JS files but i am not exactly getting how to proceed. Can someone provide code sample?