Questions on Reporting Forum

1 answer

285 views

Hi

I make Report with multi column. When i add report header in report its width is also column width how i can make report header section width equal to report width. please see the attached screenshot of report design. in blue circle is a table which is in report header section Refer to datasource1

Red circle include the table in detail section refer to datasource2

in this section when table reach at the end of the page i want to show vertically on the same page.

How can I do this?

Report Designer (standalone)

answered on 05 May 2015

1 answer

94 views

Displaying Collections from an ObjectSource object

I have a report bound to an ObjectDataSource. 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?

General Discussions

answered on 05 May 2015

4 answers

314 views

How to use ReportBook with asp.net mvc 5 ?

Hi,

For an app i'm developing, the user can print several invoices selected in a list.

The invoice report works just fine for one item. I decided to reuse this code and include them in a ReportBook object. What I can't figure is how to send the ReportBook object to the view with a ReportViewerViewModel object.

public ActionResult Invoices(IEnumerable<int> ids)
{

     var book = new ReportBook();
     ids.ForEach(id =>
      {
         var invoiceReport = new ReportDefinitions.Invoice();
         book.Reports.Add(invoiceReport);

});
     var source = new InstanceReportSource {ReportDocument = book};
     var viewer = new ReportViewerViewModel();

return ?
}

If my way of doing is right, how can I pass the book to the Index view which use a ReportViewerViewModel model or resolve the report ?

General Discussions

answered on 05 May 2015

1 answer

205 views

Parent/child POCO object

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

63 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

350 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

411 views

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.2K+ 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

191 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

258 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