Telerik Forums
Reporting Forum
0 answers
146 views

Hi,

 

I am using the HTML5 viewer under .Net 6. I have 2 parameters CICAreaFilter and SubReportVisible.

I am using this Javascript to pass values to these parameters:

        $(document).ready(function () {

            $("#reportViewer1")
                .telerik_ReportViewer({
                    serviceUrl: "api/reports",
                    reportSource: { report: "First Attempt.trdp" },
                    parameters: [ { CICAreaFilter: 'GEN' }, { SubReportVisible: true }],
                    scaleMode: telerikReportViewer.ScaleModes.SPECIFIC,
                    scale: 1.0
                });
        });

The parameters are not being set in the report. What do I need to change to get these parameters to work? I have tried 1 parameter and it also does not work.

 

Thanks.

 

Lloyd.

Lloyd
Top achievements
Rank 1
 asked on 22 Jun 2022
1 answer
349 views

I have a relatively simple report.  Four columns, three of which will contain little data, but the fourth could contain a large amount (see figure attached).

How do I get the row bottoms of the first three columns to align with the fourth?

All columns have Behavior defined as:
Culture                 (default)
Keep Together   TrueMultiline              True
Visible                 True

All have Appearance.TextWrap True

The detail section that they are in has Behavior defined as:
CanShrink            False
Keep Together   TruePageBreak           None
Visible                 True

Report is created with standalone designer version 16.1.22.511

 

Dimitar
Telerik team
 answered on 22 Jun 2022
24 answers
1.4K+ views
Using released, licensed version 1.0 of the report component, I follow (closely enough, I should think) the instructions in the help file's quickstart for creating a simple report. I connect to the AdventureWorks database, and enter a SQL statement to select all from the Production.Product table using the query builder. When I test, I get 500 +/- rows returned, so I "Finish" and close the datasource configuration wizard.

Step 15: Set the DataSOurce property for the Report component. I click the down-arrow on the datasource property line, and get a message: "Value does not fall within the expected range".

I've tried this with the trial version and the released version on two different machines, against SQL2005 and SQL2005Express. 

What am I missing? Thanks in advance.
FL-Developer
Top achievements
Rank 1
 updated answer on 20 Jun 2022
1 answer
246 views

I am getting an error when attempting to run a WinUI project with the Telerik.ReportViewer.WinUI NuGet package installed.  Project builds without errors, but when I attempt to run the project, I get the following error:

Exception thrown: 'System.IO.FileNotFoundException' in Telerik.ReportViewer.WinUI.Themes.dll

In App.xaml I have added:

<ResourceDictionary Source="ms-appx:///Telerik.ReportViewer.WinUI.Themes/Themes/Generic.xaml"/>

The application target framework is .Net 6.0.  I attempted to following the example projects that were mentioned here.  What am I missing?

I also get the following errors if I add the Telerik.WinUI.Controls (2.0.0) NuGet Package.  The errors are:

PRI175: 0x80073b0f - Processing Resources failed with error: Duplicate Entry.

PRI222: 0x80073b0f - Unspecified error occurred.
Todor
Telerik team
 answered on 20 Jun 2022
2 answers
196 views

Hi,

we have troubles with the excel report creation. We defined a footer with a left, middle and right textbox which renders correctly in a PDF [pdf-Screenshot 2022-06-13 103500.png] but in Excel it renders the left and middle textbox in the left footer in Excel [excel-footer-Screenshot 2022-06-13 103646.png]. Additionally the height of the footer seems to be wrong because the margins won't be setup correctly [excel-height-Screenshot 2022-06-13 103622.png].

This is the code we use to create the reports:


        private static byte[] Render(ReportFormat format, ReportData values)
        {
            var serializerSettings = new JsonSerializerSettings
            {
                ContractResolver = new CamelCasePropertyNamesContractResolver()
            };

            var jsonValues = JsonConvert.SerializeObject(values, serializerSettings);
            var reportPath = Configuration.AppSettings.Read("ReportPath");
            var uriReportSource = new UriReportSource
            {
                Uri = reportPath,
            };
            uriReportSource.Parameters.Add("Parameter1", jsonValues);
            var r = new ReportProcessor();

            var formatString = format switch
            {
                ReportFormat.Excel => "XLSX",
                ReportFormat.Pdf   => "PDF"
            };

            var result = r.RenderReport(formatString, uriReportSource, new Hashtable());
            return result.DocumentBytes;
        }

Greetings

Jan



Jan
Top achievements
Rank 1
Iron
 answered on 20 Jun 2022
9 answers
602 views
in my DB, I have submit date & Due Date field.  I added a textbox & I try to calculate the past due date but it throw me an error
can someone help me with this?

= Fields.Date - Fields.[DueDate]  (I got error here)
Doors
Top achievements
Rank 2
Iron
 answered on 16 Jun 2022
2 answers
95 views

Greetings,

I  was wondering whether this is a feature request or something the map control can already do.

Is it not possible on large datasets for the map to cluster data points together and show a clustered total marker?

The map already seems to have implemented many of the underlying features (grouping, varying bubble sizes etc) so a "clustered bubble" displaying a total would have been ideal and not make the map too cluttered, especially if illustrated on a tiled background.

If its already possible, some sample code would be highly appreciated.

Thanks

 


Yemo
Top achievements
Rank 1
Iron
 answered on 13 Jun 2022
0 answers
130 views

Hi,

we want to open a custom windows application with the Navigate to URL action. The protocol is neither "http" nor "https" it is "profile". So the link we want to navigate to looks like this: "profile://hostname/db(tenant)/Parts(1)". This seems to work perfectly fine if we render it to an Excel file but won't open anything if we render it to a PDF.

Greetings
Jan

Jan
Top achievements
Rank 1
Iron
 asked on 13 Jun 2022
1 answer
2.1K+ views

Hi, i need open .trdp file inside visual studio (ScreenShot) for use "Object Datasource"

In normal mode i click on .trdp file run "Reporting Designer" Out of the visual studio

How to open .trdp file inside visual studio ?

 

Telerik_Reporting_R2-2022 16.1.22.511

Visual Studio 2022

 

thank you

Dimitar
Telerik team
 answered on 13 Jun 2022
2 answers
77 views

Hi Reporting team,

I would like to reduce the number of makers (basically I would display the makers only in the first, last, max and min values) . However, I don't want to simplify the data because that make change on the shape of line.

Would you please help me a solution to modify the display of makers? 

 

minh
Top achievements
Rank 2
Iron
Iron
Iron
 answered on 10 Jun 2022
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?