Questions on Reporting Forum

14 answers

2.0K+ views

I'm trying to find documentation on creating a Report Book. There seems to be very little. Can assist me in creating a Report Book from scratch?
Examples, videos, etc would all be helpful.

General Discussions

answered on 12 Apr 2021

1 answer

759 views

Maps issue, (418) blocked

I have a problem with the map control. I get an error (418) Blocked.

General Discussions

answered on 08 Apr 2021

3 answers

588 views

Sorting the Detail section

The last thing I need to make this report usable is to be able to sort the contents of the detail section by line number (which is an integer). The Group Explorer has a column called Sorting, but it seems that the Detail section cannot be sorted. How do I sort that section according to the line number on the sales order. Right now, when I print, I get line numbers in a random order instead of 1, 2, 3, etc.

Report Designer (standalone)

answered on 08 Apr 2021

3 answers

831 views

Images not showing in report viewer

I am using report viewer in a Blazor project.

The images in report do not show up in the report. However, they do appear when i try to print or export the report.

Please advise ?

General Discussions

answered on 07 Apr 2021

6 answers

163 views

display errors when calculating totals in my report

Hello,

I created a report to display values and totals.
I have a problem with the Bordereau N ° 212319
it shows me the total of "Nombre de Plis" in just "DD" column (1 233) while it should appears to display (897 in "DD" and 316 in "TF") as the capture that I have attached. Same problem in "Poids Total"

I am sharing my sample with you online via Dropbox. please check this and advise me any way to address this requirement.

https://www.dropbox.com/s/zts6gyiefp5qdce/myReport.trdp?dl=0
Thanks in advance.

Report Designer (standalone)

answered on 07 Apr 2021

1 answer

251 views

.NET 5 Acessing Oracle

Hello!

I am evaluating the tool for my company.
I am creating a .NET 5 application that accesses an Oracle database.
Through the designer, I managed to assemble the report and managed to view the information through the Preview.
When I try to run the report and export a PDF I get the following message:
"Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application. "

Is there a document on how to export a report as PDF using .NET 5 and accessing the Oracle database?

General Discussions

answered on 06 Apr 2021

7 answers

2.5K+ views

Configuration appsettings.json

I'm using Telerik Reporting R1 2019 for ASP.NET Core where the Reporting Services and the HTML5 viewer is at the same project.

Can you direct me to the correct documentation regarding how to set the connection string in this project ?
As I cannot seem to make it work. When it moves to "netcoreapp2.2" does it still need "App.config" to store the connection string ?

I keep getting the unable to connect to database.

General Discussions

answered on 06 Apr 2021

1 answer

125 views

How to Set Telerik RadGrid Child Row Height

Dear Telerik Team

Pls give any suggestions for this?

General Discussions

answered on 02 Apr 2021

1 answer

7.5K+ views

How to pass multi-value parameters to a Stored Procedure datasource

Today I came across the stumbling block of passing multi-value parameters to a Stored Procedure. After some trial and error, I have discovered a way to do this. I'm posting it here as I don't see any solutions for this problem in the forum already and the Telerik documentation here states it is not possible.

The key is to pass the parameter's multiple values as a comma (or other character) delimited string. To do this, configure your parameter (using a parameter named @department as an example) in the "Configure data source parameters" step of the data source configuration wizard to join the selected values together using the syntax:

=Join(",",Parameters.Department.Value)

Now we need a table-valued function in the database to convert the comma delimited list string to a table of values. Here is what I used:

CREATE FUNCTION splitstring ( @stringToSplit VARCHAR(8000) )

RETURNS

@returnList TABLE ([Param] [nvarchar] (500))

AS

BEGIN

DECLARE @name NVARCHAR(255)

DECLARE @pos INT

WHILE CHARINDEX(',', @stringToSplit) > 0

BEGIN

SELECT @pos = CHARINDEX(',', @stringToSplit)

SELECT @name = SUBSTRING(@stringToSplit, 1, @pos-1)

INSERT INTO @returnList

SELECT @name

SELECT @stringToSplit = SUBSTRING(@stringToSplit, @pos+1, LEN(@stringToSplit)-@pos)

END

INSERT INTO @returnList

SELECT @stringToSplit

RETURN

END

Now you can utilize the passed parameter in your main report data source SQL query by using the following syntax in your WHERE clause:

WHERE

@department IS NULL OR

@department='' OR

@department='All' OR

salesman.department IN (SELECT [Param] FROM splitstring(@department))

In my example I'm allowing for a supplied NULL, empty string or 'All' value top denote selecting all departments.

Hope this helps some of you out.

General Discussions

answered on 01 Apr 2021

2 answers

300 views

SVG images does not render marker-end correct

Hello.

when trying to display this SVG in a picturebox the marker-end shows up with some added artifacts.

Also when using polygon as marker, nothing shows up. Just the artifacts.

<svg viewBox="0 0 240 200" id="drawing">

<defs>

<marker id="arrowheadSmall" markerWidth="13" markerHeight="13" fill="black" refX="7" refY="6" orient="auto">

<path d="M2,2 L2,11 L10,6 L2,2" style="fill: #000000;"></path>

</marker>

<pattern id="wallFill" width="4" height="10" fill="#E6E6E6" patternTransform="rotate(45 0 0)"

patternUnits="userSpaceOnUse">

<line x1="0" y1="0" x2="0" y2="10" style="stroke:#ABABAB; stroke-width:1"></line>

</pattern>

</defs>

<rect x="10" y="90" width="90" height="10" style="stroke:grey;stroke-width:1" fill="url(#wallFill)"></rect>

<rect x="10" y="180" width="180" height="10" style="stroke:grey;stroke-width:1" fill="url(#wallFill)"></rect>

<line x1="190" y1="190" x2="190" y2="70" style="stroke:grey;stroke-width:1"></line>

<line x1="190" y1="70" x2="70" y2="10" style="stroke:grey;stroke-width:1"></line>

<text fill="black" font-size="12px" dominant-baseline="middle" transform="translate(90,186)"

text-anchor="middle">Gulv</text>

<text fill="black" font-size="12px" dominant-baseline="middle" transform="translate(140,40) rotate(27)"

text-anchor="middle">Skråtak</text>

<line x1="200" y1="118" x2="200" y2="73" style="stroke:black" marker-end="url(#arrowheadSmall)"></line>

<line x1="200" y1="130" x2="200" y2="177" style="stroke:black" marker-end="url(#arrowheadSmall)"></line>

<line x1="100" y1="62" x2="100" y2="87" style="stroke:black" marker-end="url(#arrowheadSmall)"></line>

<line x1="100" y1="48" x2="100" y2="28" style="stroke:black" marker-end="url(#arrowheadSmall)"></line>

<text x="40" y="140" fill="black" font-size="12px" dominant-baseline="middle" text-anchor="middle">2380</text>

<line x1="40" y1="133" x2="40" y2="103" style="stroke:black" marker-end="url(#arrowheadSmall)"></line>

<line x1="40" y1="145" x2="40" y2="177" style="stroke:black" marker-end="url(#arrowheadSmall)"></line>

<text x="110" y="140" fill="black" font-size="12px" dominant-baseline="middle" text-anchor="middle">2690</text>

<line x1="110" y1="133" x2="110" y2="93" style="stroke:black" marker-end="url(#arrowheadSmall)"></line>

<line x1="110" y1="145" x2="110" y2="177" style="stroke:black" marker-end="url(#arrowheadSmall)"></line>

<text x="100" y="56" fill="black" font-size="12px" dominant-baseline="middle" text-anchor="middle">1940</text>

<text x="200" y="125" fill="black" font-size="12px" dominant-baseline="middle" text-anchor="middle">3080</text>

<line x1="150" x2="220" y1="70" y2="70" stroke="#2A579A" stroke-width="1" stroke-dasharray="4"></line>

<path fill="none" stroke="#2A579A" stroke-width="1"

d="M 177.3116909814869 64.08334433563022 A 14 14 0 0 0 176 70"></path>

<text fill="#2A579A" font-size="12px" dominant-baseline="middle" transform="translate(162, 65)" text-anchor="middle">23 ° </text>

Report Designer (standalone)

answered on 01 Apr 2021