Questions on Reporting Forum

16 answers

3.3K+ views

Dynamically changing report's data source in report viewer

I created a report using the stand alone designer. I am programmatically setting the report's source as such...

Dim uriReportSource As New Telerik.Reporting.UriReportSource()

' Specifying a URL or a file path

Const Directory As String = "~/Custom/"

Dim myPath As String = Server.MapPath(Directory & "41x_44x.trdx")

uriReportSource.Uri = myPath

Me.ReportViewer1.ReportSource = uriReportSource

Me.ReportViewer1.DataBind()

How do I dynamically change the datasource of the report that is already loaded into my report viewer (when clicking a button or other similar event)? More detail: The report already contains it's own data source based on a sql view through the report designer component. Let's say I want to click a button on my page to dynamically switch to another sql view and then rebind the report. I already have my sql data source code, but I can't seem to find a way to attach that data source to an existing report loaded in my report viewer. Is this even possible to do?

General Discussions

answered on 04 May 2015

1 answer

203 views

HTML5 Report Viewer via Web Forms not working

I've gone over the guides here several times and I can not get the HTML5 viewer / REST api to work in a C# .Net 4.5 Web Forms project.

http://www.telerik.com/help/reporting/telerik-reporting-rest-host-http-service-using-web-hosting.html

The error I get in the Report Viewer is "Not Found: undefined"

The error I get from the /api/reports/formats/ page is

<Error><Message>No HTTP resource was found that matches the request URI 'http://localhost:54659/api/reports/formats'.</Message><MessageDetail>No type was found that matches the controller named 'reports'.</MessageDetail></Error>

Please advise on how I can get this to work in a website.

General Discussions

answered on 04 May 2015

2 answers

273 views

How pass multivalues param values to report MVC or HTML5?

Hi

I have create my report and it's bind to an SQL stored procedure - it works fine when I was pass single value - but now I need to pass multivlue (ProductID) as example to get report where ProductID in (1,2,3)

I set the SQL stored procedure to let me get result as i need - but the problem i got is in my report i got err msg in image in attachment

so please how can i make it work in MVC Project or HTML5 Project i can't find that in demo files examples?

Thanks a lot ....

Stored Code:

@MultiVal NVARCHAR(MAX),

@qty INT

AS

SELECT ProductID, ProductName, @qty AS stock FROM Products

CROSS APPLY dbo.NumbersTable(1, @qty, 1)

WHERE ProductID IN (SELECT Val FROM dbo.fn_String_To_Table(@MultiVal,',',1))

fn_String_To_Table FUN :

ALTER FUNCTION [dbo].[fn_String_To_Table] (

            @String VARCHAR(max), /* input string */

   @Delimeter char(1),   /* delimiter */

   @TrimSpace bit )      /* kill whitespace? */

RETURNS @Table TABLE ( [Val] VARCHAR(4000) )

AS

BEGIN

    DECLARE @Val    VARCHAR(4000)

    WHILE LEN(@String) > 0

    BEGIN

        SET @Val    = LEFT(@String,

             ISNULL(NULLIF(CHARINDEX(@Delimeter, @String) - 1, -1),

             LEN(@String)))

        SET @String = SUBSTRING(@String,

             ISNULL(NULLIF(CHARINDEX(@Delimeter, @String), 0),

             LEN(@String)) + 1, LEN(@String))

  IF @TrimSpace = 1 Set @Val = LTRIM(RTRIM(@Val))

    INSERT INTO @Table ( [Val] )

        VALUES ( @Val )

    END

    RETURN

END

General Discussions

answered on 04 May 2015

7 answers

321 views

Change "Generate Report" Message

Hi
How I can change "Generating Report" Message(when report initialaizing) to what message I want For Example: "Generazione di Report"
Thanx

General Discussions

answered on 30 Apr 2015

2 answers

100 views

Style Builder Dialog Visual Studio

Hello everybody,
I have a problem with the style editor in visual studio 2013, he is to small. Is there any possibility to change the size?
Yes, I use the property window in studio to set some styles, but this one is much more confortable...
Thank you for your support.

General Discussions

answered on 30 Apr 2015

8 answers

317 views

Pie Chart Issues

Hi,

I'm trying to build a pie chart, but really have no idea how this is accomplished. I've look at the tutorials and really don't give me enough information.

I created a SQL Source for percentages:
1. Budget Spent
2. Remaining Budget

I just want to plot the pie chart to show this distribution, for example budget spent 25% remaining budget 75%. This is fairly straightforward. I've used Crystal and Infragistics and it wasn't very hard to do. Can someone assist with this please.

Thank You,

General Discussions

answered on 30 Apr 2015

1 answer

229 views

ReportViewer control failed to setup the http handler in the web.config file.

Hello,

I have a problem with the reportViewer.
A few months ago, I have created a project to create invoices.
Now, I have to change some things, but my project is not working annymore.

I could not fix it, zo I diceded to start all over again.

The problem rises when I place a new report viewer. Then I get an error message.
I get this message in every solution I got.

Can someone help me, or direct me in the right direction?

General Discussions

answered on 30 Apr 2015

3 answers

566 views

Section split

Hi,

I think that in your (really good!) reports don't exists a really important feature.

In any section (Details, Header, Footer, Group Header, Group Header...) will be really good the possibility of section split, in example because we want show one of section in certain context and not in other.

You think is possible to add this feature (that exists in example in Crystal Reports) for a future release?

Thanks

marc.

General Discussions

answered on 30 Apr 2015

2 answers

166 views

Report Designer Component for Asp.Net Mvc

Hello,

We are using Telerik reports with our software and standalone report designer to define end user report template. We have provided a custom ADO.Net data provider so that end users can design reports with remote data source that is provided by a WCF service. However, many end users are unwilling to use standalone designer that requires setup for ADO.Net connections albeit the connection stirng is encrypted. What we want to know is the is there any plan in a future to release report designer components for Asp.Net Mvc so that the report designer is incorporated into our application and not having to download and setup to design reports?

Any information is appreciated.

Thanks.

General Discussions