Hello Telerik Team, 

I want to group the axis datetime type label as shown in image attached.

Thanks!

Vivek

Hello Telerik team,

I want to create a area type series with vertical shading, i have also tried Monochromatic, gradient, but failed. Can you please help me in this? related images are attached.

Thanks!

Vivek

Hi,

I am using radchart view control in winforms. I have problem is that i used a drill down event on that and define a Case 0 , Case 1 and Case 2 it means three level but when i was in third level and then click on chart it calls the drill down event and there is no any Case 3 is define so report populate blank.

I need to handle that when i am in third level and click on chart report should not populate blank and needs go back to third level.

How can do this in winforms using VB.Net.

Your help will be appreciable. 

 

I've been tasked with creating a requisition form for lab orders that are sent to a third party. Using the Stand-alone Report Designer, the form itself I had no trouble with creating, but the third party has specified criteria that must be met on this form. The main item is a required PDF417 barcode. I cannot figure out the syntax required to build this barcode. I'm completely guessing at every step since there doesn't appear to be any documentation on this.
I have a blank report with the PDF417 Barcode Report Item added.

The Third Party requires the barcode have a structure like the following:
H||||^^||
P|||||||||^^|||||||||||^^|||||||||^^|||||||^|||||||||^|||||||||^^^^^^^^^^^^^^|^^^^^^^|||||||||||||||||^^|^^|^^|^^||||^||||||^^|^^^^|||^||
C|||||||||||||||||||^||||||||
A|||||||||||||||||||||^^|^|^||||||^^|^^^^^|||
M||||||
T|||||||||||||||||||||||||||||||||||||||||
S|^^^^^^|
D|||
L||
E||

Between the Pipe or Caret characters I'll need to populate my fixed values or data fields like the following 'P' segment:
P|Fields.P1_PtChartno||||||Fields.P7_Account_clientNo|Fields.P8_RequisitionNo|Fields.P9_PtNameLast^Fields.P9_PtNameFirst^Fields.P9_PtNameMiddle|Fields.P10_PtDOB

So in the Expression I put in this.
='P|'Fields.P1_PtChartno   + '||||||' + Fields.P7_Account_clientNo + '|' + Fields.P8_RequisitionNo + '|' + Fields.P9_PtNameLast + '^' + Fields.P9_PtNameFirst + '^' + Fields.P9_PtNameMiddle + '|' + Fields.P10_PtDOB

This didn't work, but it didn't error. Just no results when scanned. I found a post on the forum stating that if any field returns a NULL nothing will be displayed. So, I tried the suggested fix.
='P|'+isnull(fields.p1_ptchartno,"")+'||||||'+isnull(fields.p7_account_clientno,"")+'|'+isnull(fields.p57_externalsystemaccessionno,"")+'|'+isnull(fields.p9_ptnamelast,"")+'^'+isnull(fields.p9_ptnamefirst,"")+'^'+isnull(fields.p9_ptnamemiddle,"")+'|'+isnull(fields.p10_ptdob,"")+'|'

Progress! Although not entirely correct data, I got results:
P|44555|||||||JBF|JONES^JOHNNY^|CAAAAIAE|

Issue here is the value ‘JBF’ should be ‘915’ and ‘CAAAAIAE’ should ‘20000804’

If I add another segment the issue shifts fields:
='H|EDIFECS|'+ IsNull(Fields.H2_reqdate,"")+'|'+IsNull(Fields.H3_ediident,"")+'|^^||'
+'P|'+isnull(fields.p1_ptchartno,"")+'||||||'+isnull(fields.p7_account_clientno,"")+'|'+isnull(fields.p57_externalsystemaccessionno,"")+'|'+isnull(fields.p9_ptnamelast,"")+'^'+isnull(fields.p9_ptnamefirst,"")+'^'+isnull(fields.p9_ptnamemiddle,"")+'|'+isnull(fields.p10_ptdobconvert,"")+'|'

Returns,
H|EDIFECS|20160927|e|^^||
#|EEFFF|||||||915|9:,4$Y9:7,,^Y|20000804|
P returns as #, 44555 as EEFFF, and JONES^JOHNNY^ as 9:,4$Y9:7,,^Y

I know I’m doing it wrong, but I can’t find the correct way to format the expression.

Hi,

I am working in .NET (MVC5). 

My problem is with cross-origin resource sharing. When I am trying to get telerikReportViewerTemplate-html in Chrome (IE and Edge are working OK) I am getting this error: 

"XMLHttpRequest cannot load http://localhost:56878/api/reports/resources/templates/telerikReportViewerTemplate-html. No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://localhost:58343' is therefore not allowed access."

This is my code in JS calling report viewer:

            $('#reportViewer').telerik_ReportViewer({
                "serviceUrl": "http://localhost:56878/api/reports/",
                "scale": 1.0,
                "persistSession": false,
                "parametersAreaVisible": true,
                "documentMapVisible": true,
                "viewMode": "INTERACTIVE",
                "scaleMode": "SPECIFIC",
                "printMode": "AUTO_SELECT",
                "renderingBegin": "",
                "renderingEnd": "",
                "printBegin": "",
                "printEnd": "",
                "exportBegin": "",
                "exportEnd": "",
                "updateUi": "",
                "error": "",
                "pageReady": "",
                "ready": "",
                "parameterEditors": []
            });

 

How can I put a permissions in request header?

 

Hi,
I'm getting the "classic" error message: Report is unavailable or session has expired.
I have read your faq:
http://www.telerik.com/support/kb/reporting/report-viewers/report-is-unavailable-or-session-has-expired-error-message.aspx
where you list "Problem" and "Solution".
First:
I don't agree that you list the solution, you just describes three possible causes, not how to solve them! :)

Second:
I'm curious, why the need of sessions? Why keep, as you say in the faq, resources as images and html pages in sessions?
How often do you load the same report twice so you need to locally store the information?

Third (the real question :) ):
We have a website on one domain and from there links to another domain (on a different server) where the reports are generated.
So the problem is obvious, I surf on the website and maybe generates a report. Then I surf a little more on the website and after a while I want to generate another report. What happens? The report domain has of course timed out.

How can I solve this problem?

(We load the reports in a RadWindow if that could be something the causes the error)

Regards,
Mattias

Hi admin,

I'm using telerik reporting 2015 Q2 on a WPF project. A textbox in the report may contains tab characters for formatting a remarks field. On the print preview the tab characters are there and you will see the value of remarks field formatted by tab characters. But when producing print output, the tab characters are not there anymore. This also happens when I try to export the print preview to any format (PDF, Excel, Word, etc.)

 

Help is much appreciated. 

Thank you!

Hello,

I'm having some issue connecting to a database. I'm using a Microsoft Access db and the standalone report designer. However, it is a requirement that I overwrite the data source's database connection programatically so that it is always using my WPF application's database ConnectionString in the app.config.  Using the standalone report designer is required because the client will be creating new reports and then previewing them, but ultimately dropping the report files on many machines which may have different db paths.

What DOES work is if embed my db connection in the report designer wizard - then the report will successfully show up in my application. However, this doesn't solve my issue of needing to use the app.config connection string.

My connection string looks like so:

My code to change the datasource:
 

 

I get the error "Unable to find the required .Net Framework provider. It may not be installed."

How can this be true if I can otherwise access the same database using that connection string elsewhere in the application? And the embedded connection string will work correctly?

I'm hitting a wall here. I have seen other threads mention downloading the newest JET service pack but even Microsoft's support site says I should already have it (https://support.microsoft.com/en-us/kb/239114). I am on a 64 bit Windows 8 machine, and have my solution compiling to a 32 bit application.

Any help would be appreciated. Thank you!!

Hi,
I'm using telerik reporting Q3 2013 sp1 (7.2.14.127) in winform application.
In my report i have a graph control with DateTime scale and month unit:

dateTimeScale1.BaseUnit = Telerik.Reporting.DateTimeScaleUnits.Months;
dateTimeScale1.LabelUnit = Telerik.Reporting.DateTimeScaleUnits.Months;
dateTimeScale1.MajorUnit = Telerik.Reporting.DateTimeScaleUnits.Months;
dateTimeScale1.MinorUnit = Telerik.Reporting.DateTimeScaleUnits.Months;
dateTimeScale1.PositionMode = Telerik.Reporting.AxisPositionMode.OnTicks;

and labels format:

this.graphAxis2.LabelFormat = "{0: MMM yy}";
this.graphAxis2.LabelPlacement = Telerik.Reporting.GraphAxisLabelPlacement.NextToAxis;

Graph was shown, but datetime scale is not corrert, it's shifted back of one month,
for example if date is 14/10/2015
in graph the label date is "sept 2015" instead of "oct 2015".

Graph datasource in the attached image is:

l.Add(new GraphSerie { Data = Convert.ToDateTime("14/10/2015"), Serie = "Andamento cellule", Valore = 100 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("8/11/2015"), Serie = "Andamento cellule", Valore = 150 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("22/12/2015"), Serie = "Andamento cellule", Valore = 130 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("18/01/2016"), Serie = "Andamento cellule", Valore = 256 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("4/02/2016"), Serie = "Andamento cellule", Valore = 500 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("15/03/2016"), Serie = "Andamento cellule", Valore = 0 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("16/04/2016"), Serie = "Andamento cellule", Valore = 600 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("27/05/2016"), Serie = "Andamento cellule", Valore = 199 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("14/06/2016"), Serie = "Andamento cellule", Valore = 247 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("19/07/2016"), Serie = "Andamento cellule", Valore = 445 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("14/10/2015"), Serie = "Soglia", Valore = 150 });
l.Add(new GraphSerie { Data = Convert.ToDateTime("19/07/2016"), Serie = "Soglia", Valore = 150 });

As you can see all dates in graph labels are shifted back of one month.

Where could be the problem?

Thank you very much.
Andrea