Questions on Reporting Forum

4 answers

426 views

How to use custom user functions in a web site project?

Hello together

Recently, we switched to the HTML 5 report viewer and XML reports which are part of a web site project. Now I wanted to use a custom user function to get a list of recursive nodes for use in an SQL query.
Now, how to access this function inside our web site? I guess, since the reports / report viewer are running inside the web site project, this should be possible?
In which scope is the report / report viewer / report processor running?

When I try to access a function from a separate assembly, this is working. But then I'm unable to access the classes from the web site which are representing the node hierarchy to use.

Thanks for any advice on this!

General Discussions

answered on 14 Oct 2015

1 answer

407 views

End-User Design

Hello

we use MVC and Html5 and we use telerik report but our customer want to design report how can i do it??

In your demos isn't it Like StimulSoft

thanks a lot Telerik...

Abbas Mirzaee

Report Designer (standalone)

answered on 13 Oct 2015

1 answer

351 views

User defined functions not regonized

Hi,

I've got a user defined functions which is included in a EncounterDatasource.dll below is the code

[Function(Category = "My Functions", Namespace ="My",Description= "Get array item")]

public static string GetArrayItem(string[] values,int index)

{

return values[index];

}

My problem is upon deployment it cause error in the fields using the said functions. The error is

An error has occurred while processing TextBox 'textBox81': The expression contains object 'My' that is not defined in the current context.

On the Telerik Report Designer its working fine since I've able to add the dll reference in the Telerik.ReportDesigner config but not on the application its not working. I've also made a reference to the dll from my project and make sure it reside with the report. What would be the possible cause of this and how would I deploy report using user defined functions from external dll?

Regards,

Jordan

General Discussions

answered on 13 Oct 2015

1 answer

380 views

Export to excel and pdf icons in htmlviewer

Our requirement is to show excel icon and pdf icon for easy access, ability to pass parameter directly instead of dropdown similar to print icon

we need to show excel and pdf similar to print icon in template.

what data-command do we use, i dont see one.

http://www.telerik.com/help/reporting/html5-report-viewer-data-attributes.html

also if we have export in dropdown list how do we control the styles..need to update z-index and its not working for us.

<div class="k-animation-container" style="width: 82px; height: 27px; margin-left: -2px; padding-left: 2px; padding-right: 2px; padding-bottom: 4px; overflow: visible; display: block; position: absolute; z-index: 10002; top: 29px; left: 0px;"><ul data-command-list="export-format-list" class="k-group k-menu-group k-popup k-reset k-state-border-up" role="menu" data-role="popup" style="display: block; position: absolute; font-size: 12px; font-family: abc-regular; font-stretch: normal; font-style: normal; font-weight: 400; line-height: 15px;"><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="PDF" data-command="telerik_ReportViewer_export" href="#" class="k-link">Acrobat (PDF) file</a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="CSV" data-command="telerik_ReportViewer_export" href="#" class="k-link">CSV (comma delimited)</a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="XLS" data-command="telerik_ReportViewer_export" href="#" class="k-link">Excel 97-2003</a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="XLSX" data-command="telerik_ReportViewer_export" href="#" class="k-link">Excel Worksheet</a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="PPTX" data-command="telerik_ReportViewer_export" href="#" class="k-link">PowerPoint Presentation</a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="RTF" data-command="telerik_ReportViewer_export" href="#" class="k-link">Rich Text Format</a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="IMAGE" data-command="telerik_ReportViewer_export" href="#" class="k-link">TIFF file</a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="MHTML" data-command="telerik_ReportViewer_export" href="#" class="k-link">Web Archive</a></li><li class="k-item k-state-default" role="menuitem"><a data-command-parameter="DOCX" data-command="telerik_ReportViewer_export" href="#" class="k-link">Word Document</a></li><li class="k-item k-state-default k-last" role="menuitem"><a data-command-parameter="XPS" data-command="telerik_ReportViewer_export" href="#" class="k-link">XPS Document</a></li></ul></div>

General Discussions

answered on 13 Oct 2015

1 answer

564 views

Printing from Microsoft Edge

Hello,

Printing from Microsoft Edge doesn't look promising in general right now. Microsoft and thousands of users seem to indicate that it doesn't work correctly.

That being said has Telerik looked into getting the print dialog to come up in Edge? As of now the print button causes a PDF to download much like it did with Firefox some years back. I'm wondering if there is a similar workaround for Edge.

Thank you!

General Discussions

answered on 12 Oct 2015

1 answer

310 views

Use a wildcard for "version" in <AssemblyReferences />

Hi all,

I have an assembly with some user-defined functions. To use it in our another project (and in VS designer) i had to add this snippet to my config(s):

<Telerik.Reporting>

All this worked fine until we decided to have real version numbers for all assemblies in our solution. So, one day, we replaced

[assembly: AssemblyVersion("1.0.0.0")]

with

[assembly: AssemblyVersion("1.0.*")]

in the AssemblyInfo.cs file of MyAssemblyName project. Now Telerik Reporting cannot resolve MyAssemblyName because of the wrong version number.

So, my question is: is there any way to have an AssemblyReference without specifying the exact version number?

Thanks in advance.

P.S. I've tried omitting "version" altogether, specifying version ranges, wildcards etc. Nothing helps :-(.

General Discussions

answered on 12 Oct 2015

1 answer

234 views

Is possable using objectDataSource to filter multi value parameters?

one of my my data source object List<int> categoriesIds = {1, 2, 3}

I want using multiple value parameters filter the datasource

I using Field.Categories(List<int>) in = Parameters.categories.Value, but this is not working

General Discussions

answered on 12 Oct 2015

9 answers

586 views

[Solved] table wizard in Details section problem?

I am using a table wizard in the details section to generate the columns i need for my database records...but the problem i face is that the
table repeats itself after the end of recordset..How Can i stop it from doing it....

Thank you

General Discussions

answered on 12 Oct 2015

1 answer

223 views

IReportResolver for subreports

Hi,

I use a custom IReportResolver in combination with the ReportConnectionStringManager and it works well. However my next requirement is to support subreports where the ReportSource property is set to a parameter, e.g. = Parameters.invoiceReport.Value. This is a problem when attempting to update the connection string on the subreport, the name is given as the expression, not the evaluation of the expression. It seems that I can evaluate the expression myself with a bit of work and checking the Http context request referrerUrl property, but looks a bit fragile.

If you look at the code for ReportConnectionStringManager you can see that it assumes here:

using (var xmlReader = System.Xml.XmlReader.Create(uriReportSource.Uri, settings))

that the Uri is already evaluated, but it's not, it is the string "= Parameters.invoiceReport.Value". Do you have any suggestions other than evaluating the expression myself?

Thanks,

General Discussions

answered on 12 Oct 2015

2 answers

485 views

[Solved] Subreport data not showing up

Hi,

Been trying to set the figure out how to properly set the data of my sub report, thru searching on the threads I managed to come up with this code but testing it still does not show the data of my subreport. For the main report its seems fine, it there anything I miss out?

Below is the code

private void Form1_Load(object sender, EventArgs e)

{

var service = new TelerikReportDatasource.Service.ReportServiceEncounter();

var reportParameter = new TelerikReportDatasource.ParameterModel.ViewReportEncounter1ParameterModel

{

ProviderId = 1,

PatientId = 0,

PatientCaseId = 0,

ApptDate = Convert.ToDateTime("9/28/2015"),

EncounterDate = Convert.ToDateTime("9/28/2015"),

IgnoreMainSettings = false,

IsTimeCheck = false,

IsPrintedCheck = true,

IsSortByAlpha = false,

ConnectionString = "some connection string",

IsMandatoryNPExam = false,

OnePerAppt = false,

ShowCTytd = true,

PastVisit = true,

FutureAppt = true,

NumberFutureAppts = 0,

SetCPTList = true,

DiagCount = 12,

SetEncMemo = true,

SetEncSpec = true,

SystemTimeZone = 2,

UserTimeZone = 2

};

var telerikReportSource = service.GetReportData(reportParameter);

var reportObjectDatasource = new ObjectDataSource();

reportObjectDatasource.DataSource = telerikReportSource.Encounter1Data;

reportObjectDatasource.DataMember = "GetEncounter1";

var uriReportSource = new UriReportSource();

uriReportSource.Uri = "rptEncounter.trdx";

var report = DeserializeReport(uriReportSource);

report.DataSource = reportObjectDatasource;

//Set the subreport datasource

var subReportPatDiag = (SubReport)report.Items.Find("PatDiag", true).FirstOrDefault();

var subReportPatDiagReportsource = (UriReportSource)subReportPatDiag.ReportSource;

subReportPatDiagReportsource.Parameters.Add("ApptID", telerikReportSource.Encounter1Data.FirstOrDefault().AppointID);

var reportPatDiag = DeserializeReport(subReportPatDiagReportsource);

var reportPatDiagSource = (ObjectDataSource)reportPatDiag.DataSource;

reportPatDiagSource.DataSource = telerikReportSource.Encounter4Data;

reportPatDiagSource.DataMember = "GetEncounter4";

reportPatDiag.DataSource = reportPatDiagSource;

var reportSource = new InstanceReportSource();

reportSource.ReportDocument = report;

reportViewer1.ReportSource = reportSource;

reportViewer1.RefreshReport();

}

/// <summary>

/// Deserialize the TRDX report file from uri report to be able to use it as a report

/// </summary>

/// <param name="uriReportSource"></param>

/// <returns></returns>

Report DeserializeReport(UriReportSource uriReportSource)

{

var settings = new System.Xml.XmlReaderSettings();

settings.IgnoreWhitespace = true;

using (var xmlReader = System.Xml.XmlReader.Create(uriReportSource.Uri, settings))

{

var xmlSerializer = new Telerik.Reporting.XmlSerialization.ReportXmlSerializer();

var report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);

return report;

}

Help is greatly appreciated

General Discussions

answered on 09 Oct 2015