Questions on Reporting Forum

1 answer

229 views

I am trying to create a parent/child report for a single item, a Job, which contains Parts.

I want to present the Job object, containing the Parts, to the Report. However, when I try to access the Parts, defined as List<Part>, I cannot access it's attributes, only the attributes of the List itself (Capacity and Count).

What am I doing wrong?

Thanks Larzeb

public class Job

{

public Job()

{

PartList = new List<JobPart>();

}

public int Id { get; set; }

public string JobNumber { get; set; }

public string Name { get; set; }

public List<JobPart> PartList { get; set; }

public DateTime ServiceDate { get; set; }

public decimal SalesTaxRate { get; set; }

public string Comments { get; set; }

}

General Discussions

answered on 05 May 2015

1 answer

76 views

Best Reporting .net api for windows application

Hi,

I need best reporting .net api for windows application which having report facility which allow me to change the different properties at runtime like setting background color of fields and lot more and also provide me different charting facility.

If any one know please suggest me..

Thank You..

General Discussions

answered on 05 May 2015

1 answer

389 views

Displaying ObjectSource Collections

I have a report bound to an ObjectDataSource. These among the properties these objects have, one is itself a collection of objects. I want to display the individual values with these collections as well. I assume some combination of creating a group and a crosstab would work, but I am not seeing anything.

If the property is Fields.Collection and I create a group based on that, how do I refer to the Collection's properties in the detail panel? Fields.Collection.Property or just Fields.Property?

Report Designer (standalone)

answered on 05 May 2015

2 answers

441 views

[Solved] HTML5 Report Viewer - How to set dropdownlist to be multiselect with checkbox for custom parameter editor ?

Hi

i have use this link http://www.telerik.com/help/reporting/html5-report-viewer-howto-custom-parameter-editor.html to create dropdownlist for my param - it works fine if param not multivalues - but now i set param to be mutivalues but i can't get dropdownlist again i got is as list as image

so please how can i set it to let me view it as kendo dropdownlist with checkbox to let me chose more than one value ?

<div id="reportViewer1" style="height:1241px;">

loading...

</div>

<script>

$(document).ready(function () {

$("#reportViewer1")

.telerik_ReportViewer({

serviceUrl: "/api/reports",

templateUrl: '/ReportViewer/templates/telerikReportViewerTemplate-9.0.15.324.html',

parameterEditors: [

{

match: function (parameter) {

return Boolean(parameter.availableValues) && !parameter.multivalue;

},

createEditor: function (placeholder, options) {

var dropDownElement = $(placeholder).html('<div></div>'),

parameter,

valueChangedCallback = options.parameterChanged,

dropDownList;

function onChange() {

var val = dropDownList.value();

valueChangedCallback(parameter, val);

}

return {

beginEdit: function (param) {

parameter = param;

$(dropDownElement).kendoDropDownList({

dataTextField: "name",

dataValueField: "value",

value: parameter.value,

dataSource: parameter.availableValues,

change: onChange,

//optionLabel: "إختر الصنف ...",

});

dropDownList = $(dropDownElement).data("kendoDropDownList");

}

};

}

}],

reportSource: {

report: "Hemdan.Views.kinds.Select_Stock_BarCode, Hemdan",

},

viewMode: telerikReportViewer.ViewModes.INTERACTIVE,

scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,

scale: 1.0,

});

</script>

General Discussions

answered on 04 May 2015

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

223 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

287 views

[Solved] 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

326 views

[Solved] 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

106 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

328 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