Questions on Reporting Forum

3 answers

902 views

counting with condition

sample query result:

ID level [...]

--------------------------------

00a level 1, [...]

00b level 3, [...]

00d level 2, [...]

00e level 1, [...]

00f level 2, [...]

00e level 1, [...]

it should display: (PLEASE refer to the attached screenshot)

level 1: 2 level 2: 2 level 3: 1

So I'm trying to count the number of unique ID for each level.

My attempt:

Group them by level, then do a CountDistinct on the ID:

For level1 [=CountDistinct(IFF(Fields.level = "level 1", Fields.ID, 0)) - 1]

For level2 [=CountDistinct(IFF(Fields.level = "level 2", Fields.ID, 0)) - 1]

-1 is for all the 'false' count

However this didnt work, it will always return 0.

Any advice?

Report Designer (standalone)

answered on 13 Jan 2017

5 answers

338 views

Incorrect culture used in binding

Hi,

I have a teport, designed with standalone report designer with a text box in it, with binding on Style.BorderWidth.Bottom = Format("{0:0.0}pt",Fields.BottomBorderWidth)

Fields.BottomBorderWidth's type is double.

After upgrading to latest version, this stopped working when partial values are used for Fields.BottomBorderWidth.

For example, on the previous version if Fields.BottomBorderWidth's value was 0.5, this resulted in correct 0.5pt border, but in the last version it results in 5pt border.

The culture of my computer is "bg-BG", and this behavior depends on it on the latest version end does not depend on it in the previous version. It doesn't matter what culture I select for the report or for the textbox - the format function always uses the system setting, but the renderer always uses either invariant culture or "en-US" when trying to read the binding value and apply it to the style of the text box. So, when I set my system's culture to "en-US", everything is OK in both versions, and when I set my system's culture to "bg-BG", this only works in R2 2016, but not in the latest version.

General Discussions

answered on 13 Jan 2017

2 answers

280 views

Offsetting the Y-axis 0 Line to the bottom of the chart

I setup a chart to plot a linear regression, but I'm having problems getting the axes to display as I want them.

I've attached a screenshot. On the left is the report\chart I've created in Telerik Report Designer, on the right is the chart I'm trying to design.

I'm trying to move or offset the "0 line" on the Y-axis to the bottom, but I can't seem to find a way to do this. Is this something that is possible?

Report Designer (standalone)

answered on 13 Jan 2017

8 answers

317 views

Html5 Report Viewer Print Issue on 2nd print

Hello,

I have an issue with print and that is with print command on 2nd time.Here is the simple scenario..
I initialized report viewer of html5. On a button click i refresh report with new data source and added "viewer.commands.print.exec()" for print. It works for the first time. But Second time report is refreshed but is not printed.Here is my Refresh Codeviewer =

$("#reportViewer").data("telerik_ReportViewer");viewer.reportSource({
report: reportPrms
});
viewer.refreshReport();viewer.commands.print.exec();

What can be the issue. I am using Q3_2014 v 8.2

Regards
Salik

General Discussions

answered on 12 Jan 2017

2 answers

141 views

Trial of the .Net Core version

Hello,

how can i do a trial of the Reporting version for .Net Core please ?

According to the doc the only way to use it is to get the nuget package, however it can be fetch only with a paid version isn't it ?

Thanks

General Discussions

answered on 12 Jan 2017

1 answer

375 views

High memory report in server

Hi everyone,

I've tried it a thousand ways and there's no way.
When I load a large report, it consumes 1GB of memory in sever.
This memory is never released(liberate).

In a day can get to occupy 23gb.
I tried in the html5 report viewer, with all type of cache and nothing.
Is there something for when I close the report, free this report memory?

Thank you

General Discussions

answered on 12 Jan 2017

1 answer

399 views

Telerik Reporting Parameter Field not Showing

Hello, I have been using Telerik Reporting with an MVC application for a couple of years now, but noticed that the parameter field is not showing up if I do not send a parameter value to the report. My situation is there are 2 parameters, both are set to visible and both can be null. However, if I do not pass in a value for one of the parameters, the parameter window/field is not displaying, even though both parameter's are set to visible. If I do pass in a value to one of the parameters, then it'll show up.

When the page is first loaded, there are no values sent to it, which is intentional, but the user cannot enter in a value for one of the parameter's, because they are not showing up unless I send an initial value when the report loads (which I am not allowed to do).

General Discussions

answered on 12 Jan 2017

1 answer

432 views

Reduce the White Spaces Between all Rows

Hello,

In Table, i need to reduce the white spaces between all row. Even i have reduced the font size to 3pt but still white space exists. I have attached the screen shot for the better explanation. Please clarify.

Thanks & Regards,

Mano

General Discussions

answered on 12 Jan 2017

10 answers

397 views

HTML viewer has no 'word' export

Hi,

I noticed that the 'word document' export option is missing from the HTML report viewer's export options - is there something I need to do to enable this?

(see screenshot)

General Discussions

answered on 12 Jan 2017

1 answer

438 views

Picture not displaying

Hi all, our application has telerik report displaying built into it. It uses what appears to be 3.8 (2015 version).

I am building reports in the standalone designer that we then setup in our application as a report. I am working on reports that require logos for our different clients. I use the picture box option, then set the value to the logo (jpg or png) that I would like to use. Previewing the report in the designer works great.

I learned that TRDX files appear to be XML files so viewing the xml file shows that the logo appears to be embedded in the file (think you call it "serialized").

However, when I preview the report from within our application as a report, the logo does not display or print. There is no warning...just empty white space.

I have also attempted to set the path to the logo file with the same result (designer shows the logo, our application rendering the report does not). The strange thing, is that if I set a field in my query to be the URL to the picture file, this works.

Any suggestions on this? I am just the report writer, but if it our program that displays the reports that is the issue, I would love the feedback so I can pass it on to my development team.

Here are the lines from my TRDX showing the 2 cases that don't appear to work.

and

Report Designer (standalone)