Questions on Reporting Forum

3 answers

268 views

[Solved] NavigateToUrlAction.Target not working

Hello,

We currently have a picture box on our PDF report that we want to open in a new tab / window on click but it is not working.

The designer file looks like this

//
// pictureBox1
//
navigateToUrlAction1.Url = "= MapLocation(Fields.UniqueId)"; // This calls and returns a url and is working fine
navigateToUrlAction1.Target = Telerik.Reporting.UrlTarget.NewWindow; // Added this manually just in case, when using the designer and choosing New window under Link target it does not add this line, I assume its default behavior?
this.pictureBox1.Action = navigateToUrlAction1;

We have tried to set the url to just http://google.com but same results.

General Discussions

answered on 16 Mar 2020

2 answers

140 views

[Solved] Value Error in Column Graph

I have a dataset of products I'm trying to graph from a web service. When using the date field (which is a unix timestamp) as the category and the count of IDs as the values it's providing the incorrect results, even when I set the base unit to days/months/years etc. When I use another field other than date, the count returns what it should (as displayed in the difference between the two graphs in the screenshot). I've experimented with changing the groupings via the ToString() method on the date however it is producing inconsistent results. Any advice on what might be causing this?

General Discussions

answered on 12 Mar 2020

1 answer

14.1K+ views

Designer error: Value cannot be null. Parameter name: instance

When I try to open the designer in visual studio I get the following error:
Value cannot be null. Parameter name: instance

I tried reinstalling the latest version of reporting but that did not fix it.

The designer worked before, the error began happening randomly one day.

Any suggestions?

General Discussions

answered on 12 Mar 2020

7 answers

1.1K+ views

adding parameters to dynamic object datasource

i followed the attachment in this post to create an object datasource. now i have to pass ten parameters into the datasource for getting some data from a query with almost one billion rows if not applied parameters. since i need to reuse existing infrastructure i have to use the method in our data layer project to get data. so adding dynamic object datasource is a must. how will i pass these parameters to the object datasource

also i would like to know if there is any way to pass all these 10 parameters as a model so i can forward the model from our webapi controller?

General Discussions

answered on 11 Mar 2020

4 answers

493 views

[Solved] AddMonths Function

Hello,

This is a thread that continues from the following post: https://www.telerik.com/forums/filter-graph-data

To give a default value to a graph, I have used this expression in the report parameter:

= AddMonths(Last(Fields.wDate), -12)

The above displays the past 12 months of data on a graph which has 5 years (60 months) of data.

However, the data that I have does not include weekends and public holidays. So in scenarios such as:

Latest date (Last(Fields.wDate)) is 2nd March 2020, and the 12 month previous data is from 2nd March 2019. 2nd March 2020 is on a Monday so data is recorded, but 2nd March 2019 was on a Saturday hence there is no data on it, which results in an error saying 'Missing or invalid parameter value. Please input valid data for all parameters.'

Is there a way where, if the -12 value is on a weekend or public holiday, it picks the data closest to it, for e.g. 4th March in this case. Or alternatively a function where I just get the latest year's worth of data by default? I have tried = Today().AddMonths(-12) but it also has the same issue.

I have also attached a screenshot of my report parameter.

Thank You

Report Designer (standalone)

answered on 10 Mar 2020

3 answers

359 views

Changin Data of a Json File Dinamically

I create a report from JsonFile, I'm using vuejs, with asp.netcore, if i wanna change the json DataSource, for the data that i got from the consul to the REST api i vue, How can i do it dinamically

General Discussions

answered on 10 Mar 2020

2 answers

130 views

Set text/ordered list to single space

Hello,

I have an HTML Text Box that is rendering text as (at least) a double spaced. This needs to be single spaced. I have tried setting each list Item's (<li>

) enclosing span to a line height of 105% and 100% for two different attempts. Neither changed the spacing.

How is line spacing set?

HTML:

Notes to Merchant: <ol><li> 1. No substitution of any articles allowed</li><li> 2. Articles must not exceed the stated cost of $200.00, unless with authorized signature.</li><li> 3. Invoices must not exceed the stated amount on the request form, unless with authorized signature.</li><li> 4. Do not accept request forms from parents 30 past date marked on voucher.</li><li> 5. All invoices must be received 30 days from the date of distribution to be honored.</li><li> 6. Send or bring invoices monthly to:</li></ol><div style="text-align:center">Baltimore City Schools<br />Office of Home and Hospital Program<br />2000 Edgewood Street – Lower Level<br />Baltimore, MD 21216<br />Attention: Allen Blackwell / Annette White</div> <ol></ol>

Report Designer (standalone)

answered on 10 Mar 2020

2 answers

139 views

[Solved] Printing one document per person

I need to print a voucher document, one page/ document per person.

I have defined a data source to retrieve a single record (Select FullName, StudentId from Table where Student ID = '1234567') but when I try to set the value of a text box in 'Edit Expression' there are no Fields in the Field list. When I key in =Fields.FullName, nothing appears in the preview. When I key in [=Fields.FullName] then I see [=Fields.FullName] in the Preview.

What am I missing?

Thank you

Report Designer (standalone)

answered on 10 Mar 2020

3 answers

160 views

[Solved] Accessing subreport datasoource

Hi,
I have the following problem. I have a report that contains a few graphs with X axis as DateTime and a subreport which is also a graph reused in many reports. It is not acceptable to me to set label, major and minor points units and ranges in designer since in one case I can have 7 days process, and in other case 5 minutes process. According to this I need to calculate total time and decide if I will set label, major and minor points in seconds, minutes or hours, and also to calculate range so that I have approximately 10 major points on the graphs X axes. To achieve this i am modifying values set in designer programmatically at runtime. I tried the following approaches, neither is working:

1. I used ItemDataBound event on report and subreport hoping that in the time it fires I will have report data source filled, so that I can use data source to get collection of data to calculate. This was not the case. Data source was still null at the time of firing.

2.I tried to calculate explicitly by calling the public method in a report that will do the calculation. This was a successful approach for the graphs in the report since I call this method from outside the report after assigning data source, but still can't find a way to call public method in the subreport from the main report after the subreport bound the data source.

I would appreciate help.

General Discussions

answered on 09 Mar 2020

1 answer

383 views

2020 R1 can not get connection string from appsetting.json in my .net core application.

I used to Telerik reporing for data show. It is work order. but after update 2020 R1. I can not replace the connection string. please help.

my controller:

[Route("api/reports")]
 public class ReportsController : ReportsControllerBase
 {
 string reportsPath = string.Empty;

 public ReportsController(IHostingEnvironment environment)
 {
 this.reportsPath = Path.Combine(environment.WebRootPath, "UserUpload\\Reports");
 this.ReportServiceConfiguration = new ReportServiceConfiguration
 {
 HostAppId = "Html5DemoApp",
 Storage = new FileStorage(),
 ReportResolver = new ReportTypeResolver()
 .AddFallbackResolver(new ReportFileResolver(this.reportsPath)),
 };
 }

 [HttpGet("reportlist")]
 public IEnumerable<string> GetReports()
 {
 return Directory
 .GetFiles(this.reportsPath)
 .Select(path =>
 Path.GetFileName(path));
 }
 }

viewer code:

General Discussions

answered on 06 Mar 2020