Telerik Forums
Reporting Forum
4 answers
400 views

Hello Telerik,

I have a WPF application with Prism. I want to have reporting, so that users are able to change the default reports as they want.

What I have done so far is:

1) Created a Report inside the Visual Studio designer, filled it simply with an ObjectDataSource, which calls a method inside a ViewModel, which returns a list, bounded to report's fields.

2) I convert the default report into a .trdp file, using reportPackager, which user can open and change with the "Standalone Report Designer".

3) I unpack the .trdp file.

So far so good.

What happens now when I try to read the modified/changed version of the first report, is that I get the following error in my app:

 

An error has occurred while processing Report 'Reportx':

The assembly "xxx, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" is not permitted to be used by an ObjectDataSource component. Please include it in an AssemblyReferences element in the Telerik.Reporting configuration section of your application configuration file.

What am I doing wrong? How can I keep bindings after changing the report with  Standalone Report Designer?

I appreciate if you point me to right direction.

Thank you.

Kourosh

Todor
Telerik team
 answered on 02 Jan 2019
3 answers
291 views
I have a question, I use Telerik Reporting Q3 2015 SP2, after the 2018/8/13 Microsoft update, there will be attachment problems, how can I solve it?
Todor
Telerik team
 answered on 02 Jan 2019
2 answers
907 views
Hi

I have created  a Report with about 3-4 sub reports in Telerik reporting Q3 2011

I have managed to pass the parameter to the main report

I have created parameter to the sub reports but it doesnt seem to be passing the parameter

How should i go about passing parameters to the sub reports using the value passed to the main report
Kalai
Top achievements
Rank 1
Veteran
 answered on 31 Dec 2018
1 answer
1.0K+ views

 I have a very simple procedure :

create or replace 
procedure         get_name(
                 p_cursor out sys_refcursor) is
 begin
 
  open p_cursor for
 
  select NAME 
  from table1;

end;

Using SQL Developer the stored procedure returns a list of names, however when trying to use the Telerik Report Designer i receive an (see below for stack trace) error when trying to execute the stored procedure. The only parameter i have is an OUT parameter.

Any reasons as to why this does not work? Is this a known issue?

I am using the Oracle.ManagedDataAccess.Client provider.

System.Data.OracleClient.OracleException (0x80131938): ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'get_name'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

   at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at Telerik.Reporting.Processing.Data.SqlSchemaAdapter.<GetFields>d__1.MoveNext()
   at Telerik.Reporting.Processing.Data.SimpleSchemaAdapter.Fill(SimpleDataModel model)
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.GetSchemaCore()
   at Telerik.Reporting.Processing.Data.DataProvider`1.Telerik.Reporting.Processing.Data.IDataProvider.GetSchema()
   at Telerik.Reporting.Data.Design.DataSourceDesignerBase.Telerik.Reporting.Design.Interfaces.IDataSchemaProvider.GetSchema()
   at Telerik.Reporting.Data.Design.DataSourceService.GetSchemaFromContext(Object context)
   at Telerik.Reporting.Design.DataExplorerControl.<>c__DisplayClass2.<RefreshDataSource>b__0()

 

Ivan Hristov
Telerik team
 answered on 28 Dec 2018
1 answer
550 views

I created a report containing a textbox that acts as a button for interactivity purposes.

This button - for sure - must not appear when I print the report nor in the print preview mode.

How can I achieve this?

I saw similar threads like this one:

https://www.telerik.com/forums/hide-certain-elements-when-printing 

But there was no real solution for the problem from Telerik. Anything changed now?

 

Thanks,

Sascha

Ivan Hristov
Telerik team
 answered on 28 Dec 2018
1 answer
163 views

I am embedding the ReportViewer in a WPF application. I have a very long report and I want to provide an easy way for the user to navigate in the report.

 

To achieve an integrated feeling for the user, I'd like to add some buttons to the application that allow the user to jump to certain bookmarks within the report. I cannot use the current page for the purpose, because the length of the sections is dynamic.

 

I found two older threads with a similar requirement, but they were not really solved by Telerik:

https://www.telerik.com/forums/navigate-to-a-bookmark-through-code

https://www.telerik.com/forums/navigating-to-bookmark-from-code

 

Is there some active development regarding this? Or any workaround? If there were events during rendering that allowed me to capture the report page of every bookmark, this would be sufficient. But I couldn't find anything like this.

 

I am also fine with calling internal methods using reflection if that's a quick workaround, because I need the functionality very soon.

 

Thanks,

Sascha

Ivan Hristov
Telerik team
 answered on 28 Dec 2018
2 answers
173 views

I found the custom action to be kind of promising to add functionality to the report. But to make this really useful, we need the complete picture:

First, I added a textbox to the report and added a Custom Action to it.

Then I subscribed to the Enter, Leave and Executing events and added some code to handle them.

 

What I want to achieve:

a) Highlight the "button" simulated with the textbox when the user enters / hovers over it

b) Un-highlight when the user leaves

c) Execute something when the user clicks (this seems to be simple enough).

 

The highlighting doesn't really work. Let me show you my event handler:

 

        public void CustomAction_Enter(object sender, InteractiveActionEventArgs args)
        {
            var b = (Border)args.Element;

            b.BorderBrush = Brushes.DarkGray;
            b.Background = Brushes.Purple;
        }

 

This does something - it colors a part of the textbox purple. But it doesn't fill the entire textbox and also it overlays the text. When I investigate the Border, I see that is has no children. This is not properly working at all and I don't understand the purpose of the Border when it seems to have nothing to do with what we see in the report.

The expected behaviour is a border that matches / is the border of the text and a child in it that is the text as a textblock control.

 

How is this meant to be used?

 

Thanks,

Sascha

Ivan Hristov
Telerik team
 answered on 28 Dec 2018
4 answers
420 views

Hi

I am trying to add my first parameterised report to an ASP.net WebForms application.  I cannot figure out how to pass the parameter.  Having searched, a lot of posts are old, lead to blank pages, examples that use the old report viewer not the HTML 5 one and I cannot convert it etc.

I have created a .trdp file and added it to the project.  It takes a parameter and the report works in preview, if I Hard code the parameter.

My front end code to add the report viewer is:

01.<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="ContractDisplay2.aspx.vb" Inherits="Intranet3.ContractDisplay2" %>
02. 
03.<%@ Register Assembly="Telerik.ReportViewer.Html5.WebForms, Version=12.2.18.1129, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.Html5.WebForms" TagPrefix="telerik" %>
04. 
05.<!DOCTYPE html>
06. 
08.<head runat="server">
09.    <title></title>
10.</head>
11.<body>
12.    <form id="form1" runat="server">
13.        <div>
14.            <p>report:</p>
15.        <telerik:ReportViewer ID="ReportViewer1" runat="server"  style="border:1px solid #ccc;"
16.            width="99%" height="99%"/>
17.        </div>
18.    </form>
19.</body>
20.</html>

 

and in my code behind I have this:

1.Dim reportSource As New Telerik.ReportViewer.Html5.WebForms.ReportSource()
2.            reportSource.IdentifierType = Telerik.ReportViewer.Html5.WebForms.IdentifierType.UriReportSource
3.            reportSource.Identifier = "ConsignmentProductReport.trdp"
4.            reportSource.Parameters.Add("AccountNo", "ABC123")
5.            ReportViewer1.ReportSource = reportSource

 

The problem is that when I run it, the report is not rendered.

Please can someone advise how to do this using WebForms / HTML5 viewer and .trdp files?

Thanks

Silviya
Telerik team
 answered on 21 Dec 2018
5 answers
852 views

Hi,

How do I merge at run time , the columns of a row ?

See image attached table.

 

Greetings,

Carlos Carvalho

Todor
Telerik team
 answered on 20 Dec 2018
1 answer
749 views

I faced issue in group footer while preparing my document

In my group footer there is a table. For particular ID the table data should be visible in next page  if no  data is available the report should contain only one page (only detail section data should be visible)but  for me the report has two pages.

Second page is coming with group header section data .

  How can i come over from it any suggestions

 

Silviya
Telerik team
 answered on 19 Dec 2018
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?