Hi

We need to source data from a web service for both designing and running reports in the standalone Telerik Report Designer.

We have the web service written and published which exposes all the available methods and their parameters to the user.  When called from the web browser it works fine, returning the requested data in a DataTable in XML format (it is a standard .NET web service).

What we need is for the Report Designer to act in a similar way to the web browser, in that it should dynamically display the web service methods that are available - along with their parameters, and once filled in by the user, they should be invoked and the data made available.  This is needed when designing the report, and should be transparent when running the report.

Given that our end users are not programmers, the selection of the above needs to be simple.

We are often updating the web service and thus need the Report Designer to pick changes up dynamically without the need to distribute anything to the client.

I have created a custom reports datasource (inherits from ObjectDataSource), with config set up and referenced as follows in the Telerik.ReportDesigner.exe.config (per http://www.telerik.com/help/reporting/standalone-report-designer-extending-configuration.html)
:

The above assembly is only a stub but references the webservice, which I take it allows access to the webservice in the Report Designer due to the Report Designer's use of reflection.

I was hopeful the following config would enable direct access to the webservice, but it is used only by the CustomReportsDataSource.  This unfortunately means our webservices are not dynamic and have to be stubbed in statically in the CustomReportsDataSource.dll, thus necessitating the distribution of this dll whenever there's a change to the web service.

To create a report in the Report Designer, I have to do the following (which is also required of a non developer):

1. Click 'New Report'
2. Use the Report Designer Wizard and select the Object Data Source.
3. Click 'Add New Data Source'
4. Select the 2nd available data source type (appended with 'ReportsServiceReference')
5. Select 'ReportsWebServiceSoapClient'
6. Click 'Next' and select 'Choose a data source member'
7. Select the method required, click 'Next'
8. Enter the parameters
9. Select the fields, report type, etc.

Is there a way to simplify this for the end user?  i.e. include our object data source in 'Current Data Sources' and suppress all extraneous methods, displaying only those from the web service?  Ideally, the end user should not have to deal with steps 3-6 above.

Initially, I had an error in the config and at this point would always get the following (very vague and thus difficult and hugely time wasting to resolve) message:

"An error occurred while invoking data retrieval method"

There were no details pertaining to this message in the Telerik.ReportDesigner.log file (log enabled by adding the system.diagnostics section in the config file, per http://www.telerik.com/community/forums/reporting/telerik-report-designer/standalone-report-designer-exe-requirements.aspx).  Further, the webservice was not being called as evidenced by debugging messages not appearing in the server log.

It would've saved me hours and would be appreciated if you could provide more details for this type of error (simply displaying the exception generated would've made the world of difference!).

So my questions are:

1. As above, is there any way to simplify the report creation process for the end user?
2. Is there a way to invoke the webservice dynamically?
3. There was talk of providing an OData data source, any progress/timeframe on that?

hello,

i'm facing seriouse problem , thick borders printed while i'm trying to print textboxs with borders,there no overlapping,every border caused by one textbox

 i'm facing it in bottom borders too , it happens in printing too

Hi

I have a Web Api project with Telerik reporting, and ASP site that hosts the reportviewer.

I have had the following issues.

when i run report  report appear with result but if db changeing some data and re-run same report  , report appear with last result 

and i fetch in this case i found that the report keep caching so i want to remove Caching

i use last report version Q3 2015

from where i can download reporting sp1 of q2 2013.? this version 7.1.13.802

From what I read I don't think it could be possible to pass a field value from datasource1 to be a parameter of datasource2 in a subreport, but could I filter datasource2 based on a field of datasource1.

I don't want to use your product groups example because datasource1 has a lot of fields.
Say I have stores and products and I want to list store information and the products each store carries.
Now I could write 1 query to join products and store, but then I'd be repeating 10 columns of my store data for every product and it would be a very large result set.

say I'd want the report to look like:

StoreID | Store Name| Store Hours| Store Owner| Store Street| Store City| Store State ... ( few more)
  1                MyStore1    8-10               Me     ...
                                                                                                Table Product List MyStore1
                                                                                                       Cookies
                                                                                                        Milk
                                                                                                        Eggs
    2             MyStore2    9-5                Joe     ...
                                                                                                Table ProductList MyStore2
                                                                                                         Steak
                                                                                                          Eggs
                                                                                                          Orange Juice

What would be the best way to accomplish this.  I have a large amount of data, so join the data in 1 query probably isn't ideal.
                                                                                               

Seems like this would be an easy one to configure but I'm not seeing anything in the properties to show the time. All I'm seeing is the date. What am I missing?

Hey,

We found that on some Win XP machines running Adobe Acrobat Pro - text on our Reports can be flipped and mirrored/reserved.
See attached.

One these same machines, if they open it with:
Adobe Acrobat XI (not Pro)
or Gmail PReview
or Google Chrome
.. the reports are fine.

Just with Adobe Acrobat Pro  this issue happens.

Any idea what to do?

One of the important requirements for my project is the ability to automatically generate a report and have them e-mailed nightly as a PDF attachment. Is it possible to do this with Telerik Reporting? If so, could you give me an example or point me to a resource?

Thanks-
David Tosi

Hello together 

Recently, we switched to the HTML 5 report viewer and XML reports which are part of a web site project. Now I wanted to use a custom user function to get a list of recursive nodes for use in an SQL query.
Now, how to access this function inside our web site? I guess, since the reports / report viewer are running inside the web site project, this should be possible?
In which scope is the report / report viewer / report processor running?

When I try to access a function from a separate assembly, this is working. But then I'm unable to access the classes from the web site which are representing the node hierarchy to use.

Thanks for any advice on this!

Hello

we use MVC and Html5 and we use telerik report but our customer want to design report how can i do it??

In your demos isn't it Like StimulSoft

thanks a lot Telerik...

Abbas Mirzaee