Telerik Forums
Reporting Forum
8 answers
529 views
Hello,

In the documentation, I've read the part titled "Creating Master-Detail Reports Using SubReports". This is exactly what I need to do, except that the documentation speaks only of working with a SQL database as datasource. In my case, I'm using a list of objects as datasource.

Here is my requirement
I have a List<House> with a variable number of house objects.
Each House object has a Floors property which is a List<Floor> with a variable number of floor objects.
In turn, each Floor has a property Rooms which is a List<Room> with a variable number of room objects.

I need to build a 3 level master-detail report with the following structure :
House 1
some data about House 1
             (repeat for each Floor of house 1)
              some data about FloorX
                     (repeat for each Room of FloorX)
                      some data about RoomY
House 2
some data about House 2
             (repeat for each Floor of house 2)
              some data about FloorX
                     (repeat for each Room of FloorX)
                      some data about RoomY
  ... and so on for each House.

Can you point me to some documentation or sample about how to do that, in the best way possible ?
This is the last element we need to evaluate before validating that we will acquire the product.
Andrea
Top achievements
Rank 1
 answered on 26 Oct 2018
1 answer
645 views

We let the user choose between single spacing, 1.5x spacing, and double spacing of the report rows.  For the detail rows this is pretty easily accomplished by setting the Height of the detail section to (font size) * (line spacing) * (1.3).  Line spacing is 1, 1.5, or 2. This makes all the detail rows space out correctly. But, we have reports with multiple total rows and these total rows need to be following the same spacing; we have not been able to get this to work. 

For example I have two total rows in the footer section:

Sum       <col 1 sum>    <col 2 sum>

Average <col 1 ave>     <col 2 ave>

When I set the location of the text boxes in the second row to y=0.01 points to y=1.99 points then this second row shows up as "single spaced"; in other words the top row text boxes push the second row down with no additional space added between then.  Like "Sum" would be at (0, 0) and "Average" would be at (0, 1 point).

But as soon as I set the location of the second row text boxes to y=2 points or more the second row get pushed WAY down to basically double spaced (15 pixels between the rendered rows to 29 pixels between the rendered rows). Font size here was 8.25 points. I don't understand what is going on here. My plan was to sec the Y location of the second row to (font size) * (line spacing) * (1.3) which logically seems like it should work; but given this weird behavior I get double spaced all the time (for 1, 1.5 or 2). 

Do I need to add a "spacer row" between these two rows to accomplish this or something similar?  Is the Y component of the text box location interpreted in some weird way?

 

Silviya
Telerik team
 answered on 26 Oct 2018
3 answers
505 views
I have a asp.net application which uses telerik reports to display data from a database. In one of the fields there have been curly braces {} used. This works fine in the application, however when the report attempts to use this data in a textbox I get "An error has occurred while processing Report 'TestReport': Error evaluating embedded expressions: Unexpected token inside an expression at index 12" does any one have idea on how to fix this short of replacing the curly braces when displaying in the report with regular brackets. I tried using an HTMLTextbox to see if it would handle it any better and it did not. Any help with this would be greatly appreciated.

Silviya
Telerik team
 answered on 26 Oct 2018
1 answer
233 views

I have a table in my report that contains 2 rows. I have now merged a couple of cells to create a larger column. I am trying to now conditional format the row in that if a record is null, hide that row.

It is not working as I suspect that it is seeing that the cells to the left and right have been merged. So I end up with the image attached.

Is there a way to accomplish this?

Brian
Top achievements
Rank 1
 answered on 25 Oct 2018
1 answer
75 views

Have a class deriving from Telerik.Reporting.Report.  The report has parameters which have values being passed in.  They are being passed in because I can print out their values on the report.

But I would like to intercept their values at some point in the code to do something with them, but when referencing them they are all null.

Tried referencing them in the constructor of the report, as this.ReportParameters.

Tried adding event handlers to various events of the report object, as well as events of datasource objects within the report.  What event handler needs to be handled where the ReportParameters will be available when they are passed in from outside?

Passing in parameter values from HTML5 viewer using reportSource property as object value set to parameters.

Ivan Hristov
Telerik team
 answered on 25 Oct 2018
10 answers
1.0K+ views

I have a table with several columns. Some of the rows have repeating data in their columns. Using Row Groups, I can group the data like so:

Patter     

Ivan Hristov
Telerik team
 answered on 25 Oct 2018
1 answer
452 views

Hi,

I have created a custom user function for translation where I will get the translations from a .po file and replace the values. The issue is these .po files resides in the same directory where the / file is. But these files are dynamic hence I cannot specify a static path inside my function. Is there a way to get the current path of the opened / file? I have tried 'Directory.GetCurrentDirectory()' and 'Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location' but both returns the path for the Telerik.ReportDesigner.exe 

Silviya
Telerik team
 answered on 25 Oct 2018
1 answer
570 views

I have need for a report whereby the header has to be the same on each page but the contents and footer different.

As an example

  • Header
  • Detail1
  • Footer1
  • Header
  • Detail2
  • Footer2

Is this possible and if so can anyone provide details?

Ivan Hristov
Telerik team
 answered on 25 Oct 2018
2 answers
80 views

Have a table which is bound to a data source.  Would like to filter its rows from page to page based on a field value from the main report's data source.

Is this possible?

Silviya
Telerik team
 answered on 25 Oct 2018
1 answer
783 views

Dear Support,

I have created a table in Report designer and Hide a column dynamically depending on one of the Boolean Control, it works fine in PDF and Excel, however, when exporting to CSV files, the column shows up.

Is there a way to Hide the column in CSV file as well?
This is a 60+ fields table, and change that to Crosstab is not quite working for us as we can't have the title correctly in crosstab and data structure is not the same too.

Kind Regards

Hugo

Peter
Telerik team
 answered on 24 Oct 2018
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?