Telerik Forums
Reporting Forum
0 answers
377 views

Hi,

I am using Web Service DS and i get this error in the standalone report designer.

I have been able to return the data in json format via Postman with the same Header parameters, but when i try to configure the data source in the report designer, I get the following error. 

System.InvalidCastException: Unable to cast object of type 'System.String' to type 'Newtonsoft.Json.Linq.JToken'.

Issue Value

{"esFilters":{"Paging":[{"paged":false,"resultsPerPage":0,"pageNumber":0}]}}

or

{ esFilters: {"Filters":[{"filterName":"","filterValue":"","filterOperator":""}],"Paging":[{"paged":true,"resultsPerPage":100,"pageNumber":1}]}}

Please advice. Thsi API works in the application and postman without any issues.

Thanks,

BV

 

 

Balaji
Top achievements
Rank 1
Veteran
 asked on 23 Mar 2022
1 answer
456 views

I would like to export all the database objects used within a report (.trdp file), and the number of times each reference is used. The rationale is we need to be able to easily identify all the database objects (e.g., tables and columns) used in a report whenever schema change discussions arise. This would include columns used in text elements, tables, charts, expressions, and so on.

Example:

REPORTDATASOURCETABLENAMEFIELDNUM_REFERENCES
FacilitiesReport.trdpfacilitiesfacilityid1
FacilitiesReport.trdpfacilitiesfacilityname2
FacilitiesReport.trdpfacilitiesfacilityzip_code1
FacilitiesReport.trdpfacilitiescityzip1
FacilitiesReport.trdpfacilitiescityname3
FacilitiesReport.trdpfacilitiescitystate1

I doubt this exists out of the box so I figure I need to script something. I am considering creating an instance of a report and looping through all the objects and collecting all datasource and field references in a dictionary and then exporting the completed dictionary to a csv.

I could also unzip the trdp file and parse the xml, but if the schema changes from version to version I could wind up with brittle or broken code.

Has anyone here down something similar? Recommendations?

 

Dimitar
Telerik team
 answered on 21 Mar 2022
1 answer
275 views

I'm exporting a report programmatically to PDF using code like this:

                var reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
                var deviceInfo = new System.Collections.Hashtable();
                var reportSource = new Telerik.Reporting.UriReportSource();
                reportSource.Uri = "<My report path>.trdp";

//Various parameters are set
                object ParmValue;
                ParmValue = "<My value>";
                reportSource.Parameters.Add("<My parameter name>", ParmValue);

                Telerik.Reporting.Processing.RenderingResult result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo);

After this I save the result into SQL server for retrieval later. For these reports I always get a result object back even if there are no data rows returned from the database query the report makes (it still has headers/footers/etc. but no details). What I'd like to do is determine if there weren't any data rows returned and take alternate action myself. 

Is there a way to determine how many data rows were retrieved by the report? The only solution I can come up with at the moment is querying the database twice; first without the report being involved to see if the database query will returns any rows; and then again by the RenderReport method if there's data to report on. That isn't efficient though. Is there something in the report objects that will tell me if there was no data returned to the report?

Todor
Telerik team
 answered on 17 Mar 2022
0 answers
393 views

Hi,

 

I'm struggling to authenticate a Microsoft Dynamics 365 webservice with OAuth2.

I'm using the Web Service Data Source wizard within the Report designer to connect to the Web service but not having any luck. I can successfully access the Web service and OAuth2 API in Postman. 

When I try to download the response in the preview window, I get a 400 bad request error. I believe the problem is with fetching the token/authentication but not sure.

Can someone please tell me what I'm doing wrong?


Neel
Top achievements
Rank 1
 updated question on 14 Mar 2022
0 answers
110 views

How do I create a dropdown with the options of: greater than >, less than <, or equal to =, then have a textbox for the value?

See attached image for something similar I am looking for. I'm trying to make a report where the user can enter a number, then select one of the options I just described. I've been stuck on this for a week!!!

 

I've read so many articles, and watched 7-8 year outdated youtube videos. Any help is greatly appreciated!

 

-Chris

0 answers
126 views

Hello,

For the WPF report viewer, we can localize almost everything... excepted for the export formats.

I'm talking of the list that appears when we click the "Export" button on the viewer. The drop down list contains English text, such as "Acrobat (PDF) file" that can't be localized.

Do you have any tip to make them change to another language?

Regards

Patrick
Top achievements
Rank 2
Iron
Iron
Iron
 asked on 14 Mar 2022
1 answer
907 views

hello, 

I don't want to use the built-in export functionality that comes with HTML 5 Report. 

Is there a way to download report with click in PDF format.

Thank you.

Todor
Telerik team
 answered on 11 Mar 2022
0 answers
521 views

Hello,

I'm trying to add a dashed horizontal line and a dashed vertical line to a report.

First question: how can I have the line at the top of the page (this is a sub-report)?

Second question: is it possible to customize the dashing?

I have lines that are 0.5pt width and the line looks almost like a solid line, excepted when looking with a magnifier!

Best regards

Patrick
Top achievements
Rank 2
Iron
Iron
Iron
 asked on 11 Mar 2022
0 answers
236 views

Getting an error, while using method. What can be the reason ? 

Version using:  "Assembly RadGridReportingLite, Version=1.10.2.1, Culture=neutral, PublicKeyToken=null"

Dim report As New RadGridReport("")

report.ReportFormShow(Me, Me.rgvPrint)

Error Details

System.MissingMethodException
  HResult=0x80131513
  Message=Method not found: 'Telerik.WinControls.UI.MasterGridViewTemplate Telerik.WinControls.UI.RadGridView.get_MasterGridViewTemplate()'.
  Source=RadGridReportingLite
  StackTrace:
   at RadGridReportingLite.RadGridReport.GetRowHeight(RadGridView grid)
   at RadGridReportingLite.RadGridReport.GetGridDimensions(RadGridView grid)
   at RadGridReportingLite.RadGridReport.ReportFormShow(IWin32Window owner, RadGridView radGridView)
   at AdecBkOfficeAdmin.frmReportft.PrintMethodNew()
0 answers
150 views
In send email popup in format dropdown i need to show only PDF and CSV.  other than pdf and csv all other format should not be display. how can i do this
Mohan
Top achievements
Rank 1
 asked on 11 Mar 2022
Top users last month
Rob
Top achievements
Rank 3
Bronze
Iron
Iron
Sergii
Top achievements
Rank 1
Iron
Iron
Dedalus
Top achievements
Rank 1
Iron
Iron
Lan
Top achievements
Rank 1
Iron
Doug
Top achievements
Rank 1
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?