Telerik Forums
Reporting Forum
1 answer
395 views

Hello,

I'm trying to run Reporting REST service with docker under Linux environment. I'm using the .NET 6. In my separate Report Viewer application, I see the following error:

Unable to get report parameters. An error has occurred. Type: Telerik.Reporting.ReportSerialization.Current.ReportSerializable`1[Telerik.Reporting.Report]

This is a sample code from my Report Viewer application:

import { TelerikReportViewer } from '@progress/telerik-react-report-viewer'

export default function ReportViewer() {
    let viewer;
    return (
        <TelerikReportViewer
            ref={ e => viewer = e }
            serviceUrl="http://localhost:32788/api/reports/"
            reportSource={{
                report: 'SampleReport.trdp',
                parameters: {}
            }}
            viewerContainerStyle = {{
                position: 'absolute',
                left: '5px',
                right: '5px',
                top: '40px',
                bottom: '5px',
                overflow: 'hidden',
                clear: 'both',
                fontFamily: 'ms sans serif'
            }}
            viewMode="INTERACTIVE"
            scaleMode="SPECIFIC"
            scale={1.0}
            enableAccessibility={false} 
        />
    )
}

And this is my Dockerfile of the REST Service application:

FROM mcr.microsoft.com/dotnet/aspnet:6.0-jammy-amd64 AS base
WORKDIR /app
EXPOSE 80

RUN apt-get update \
    && apt-get install -y --allow-unauthenticated \
        libc6-dev \
        libgdiplus \
        libx11-dev \
    && rm -rf /var/lib/apt/lists/*

FROM mcr.microsoft.com/dotnet/sdk:6.0-jammy-amd64 AS build
WORKDIR /src
RUN dotnet nuget add source https://nuget.telerik.com/v3/index.json -n Telerik -u myemail@ishere.yea -p verysecretpassword --store-password-in-clear-text
COPY ["TelerikReportingRestService/TelerikReportingRestService.csproj", "TelerikReportingRestService/"]
RUN dotnet restore "TelerikReportingRestService/TelerikReportingRestService.csproj"
COPY . .
WORKDIR "/src/TelerikReportingRestService"
RUN dotnet build "TelerikReportingRestService.csproj" -c Release -o /app/build

FROM build AS publish
RUN dotnet publish "TelerikReportingRestService.csproj" -c Release -o /app/publish /p:UseAppHost=false

FROM base AS final
WORKDIR /app
COPY --from=publish /app/publish .

COPY "TelerikReportingRestService/Reports" /app/Reports

ENTRYPOINT ["dotnet", "TelerikReportingRestService.dll"]

Everything works if I deploy it locally on IIS, however, as soon as I deploy with docker, I'm unable to view reports. I also tried to add runtimeconfig.template.json file to my project root folder with the following:

{
  "configProperties": {
    "System.Drawing.EnableUnixSupport": true
  }
}

Without any luck.

The endpoints such as /api/reports/formats and /api/reports/version works fine even with docker:

[{"name":"PDF","localizedName":"Acrobat (PDF) file"},{"name":"CSV","localizedName":"CSV (comma delimited)"},{"name":"XLSX","localizedName":"Excel Worksheet"},{"name":"PPTX","localizedName":"PowerPoint Presentation"},{"name":"RTF","localizedName":"Rich Text Format"},{"name":"IMAGE","localizedName":"TIFF file"},{"name":"DOCX","localizedName":"Word Document"}]
"17.1.23.718"

Any help is appreciated. Thanks

Dimitar
Telerik team
 answered on 12 Oct 2023
1 answer
70 views

Hi support!

We do not have the server version.
We are having the problem that when a technician wants to modify a report made by another technician, he does not let him save the report and he has to save it with another name.

Is there a way to save the report with its name once modified?

This is the message.

We have looked to see if there is any option indicating that the report is blocked, but we have not found anything.

Thanks a lot!

Momchil
Telerik team
 answered on 11 Oct 2023
0 answers
74 views

Hi

I have a dynamic report viewer in my Blazor solution, when I call the viewer first time it works fine, but when I call different report or same report with different parameter's it load the data but does not show it until i hit refresh button,

 

here is the calling methods of the report

    protected async Task OPEN_REPORT_Onclick()
    {
        ParamsComponent = new Dictionary<string, object>
            {
                { "Params", null },
                { "rptName", "test.trdp" },
                { "OnClosed", EventCallback.Factory.Create(this, OnClosed) }
            };
        TypeComponent = typeof(DynamicReportViewer);
        await js.OpenDialog("report-modal");
    }
    protected async Task OPEN_REPORT2_Onclick()
    {
        ParamsComponent = new Dictionary<string, object>
            {
                { "Params", new Dictionary<string, object>{ {"SH_ID", parameterID } } },
                { "rptName", "Shipment.trdp" },
                { "OnClosed", EventCallback.Factory.Create(this, OnClosed) }
            };
        TypeComponent = typeof(DynamicReportViewer);
        await js.OpenDialog("report-modal");
    }

 

and here is my report viewer

<div class="dashboard">
    <ReportViewer ViewerId="rv1"
                  ServiceUrl="/api/reports"
                  ReportSource="@(new ReportSourceOptions{Report = rptName,Parameters = Params })">
    </ReportViewer>
</div>

 

am I missing something or did something wrong

P.S. when I debug it with breakpoint it works just fine

Update: When Zooming In then Out The data shows up

Update: Problem solved by opening the report in new tab not popup component

n/a
Top achievements
Rank 1
 updated question on 09 Oct 2023
1 answer
209 views

I'm facing some issues while connecting my SQL Server using 2 Step Authentication WebServiceDataSource in Telerik Reporting. I have referred the following official documents - Document 1  Document 2

Currently, I'm stuck on a few things:

  1. On Configure Data Retrieval window, Can I leave the Data Selector Field Blank? Is it required to specify JSONPath?
  2. In Postman I don't have to manually add any Headers to my current Authentication and Data Retrieval Endpoint (content type, accept, authorization, etc. these are automatically added by Postman). In Config Request/Authentication Parameters,  do I need to add any of these headers?
  3. In Configure 2 Step Authentication window;
    a. What is the role of Token Path? If it is to retrieve the access_token, as per the documentation is this regex (?:"access_token":")(.?)(?:")* correct? I came up with another regex "access_token":"(.*?)". Let me know which one is correct and why.
    b. What is the Request Body Type? Text or JSON?
  4. Due to the above configuration issues I am getting the following error on the Preview DataSource Results window.
    a. Error- Could not get preview.. An error has occurred. Value cannot be null. Parameter name: content

 

Momchil
Telerik team
 answered on 09 Oct 2023
1 answer
566 views

I have my SQL Server on Azure Virtual Machine. I'm trying to use Managed Identity Connection String (without the need of username, password in the connection string) to connect my SQL Server with Telerik Report. I did not find any specific documentation or a question regarding this implementation. Any leads will be appreciated.

I can connect my SQL Server using this normal connection string: Server=tcp:sqlserverendpoint,1234;Initial Catalog=SampleDatabase;Persist Security Info=False;User ID=username;Password=password;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

I'm trying to use this Connection String (which doesn't include username and password): Server=tcp:sqlserverendpoint,1234;Authentication=ActiveDirectoryManagedIdentity;Encrypt=True;Database=SampleDatabase;

Any leads would be appreciated. Thanks.

5 answers
300 views

I have a table in my report and need to let the user pick the item they want the data grouped by.  If I have a parameter in the group by clause, is there a way to fill it with specific fields from the table?  I don't want all of the fields to be available as choices.

 

Thank you,

 

Jennifer

Joshua
Top achievements
Rank 2
Iron
Veteran
Iron
 answered on 05 Oct 2023
1 answer
394 views
Hello, I'm new to web development, and I'm currently facing an issue with viewing reports on my website when it's uploaded to the server using IIS. The problem is that sometimes I can't view the Report Viewer, but other times I can. When I can't view it, I get this error message: "Error registering the viewer with the service. An error has occurred. Access to the path is denied." Where should I start checking for this issue?
Dimitar
Telerik team
 answered on 05 Oct 2023
1 answer
100 views

Hi all,

When I run telerik report on Telerik Reporting Designer, report run normally. But when I run it on web by HTML5 Report Viewer then error as attach picture. Plesae help to correct it.

Thanks a lot.

 

Todor
Telerik team
 answered on 04 Oct 2023
1 answer
250 views

Hi all,

I have a question so need to consutant from you. When I run telerik report from Telerik report designer I already get error as attach picture. I guess it relate to timeout. Can you show me how to set it in telerik report designer? Thanks a lot.

Dimitar
Telerik team
 answered on 03 Oct 2023
1 answer
69 views

im having an issue getting the total to align correctly the Pharm name and quantity line up correctly but the total is getting kicked to the right. i have a attached the report and relevant screen shot

thanks!!

 
Dimitar
Telerik team
 answered on 02 Oct 2023
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?