Telerik Forums
Reporting Forum
1 answer
108 views

I've been looking for an "If>Then>Else" or Case statements, but haven't found them in the documentation. 

Are logic structures like these available?  If so, will someone provide examples of the syntax?

Stef
Telerik team
 answered on 22 Apr 2015
1 answer
297 views
I would like to know if there is a way to create comments in a report's expression.  If so, what is the syntax? 
Stef
Telerik team
 answered on 22 Apr 2015
1 answer
82 views

While my reports are displayed perfectly during runtime, it is not possible to get a preview during development in Visual Studio 2013. I got the following solution structure (WPF):

Main Application EXE
Data-ClassLibrary
Report-ClassLibrary
(... other ClassLibraries and Modules...)

All reports use objectDataSources which itself use the ApplicationDbContext defined in Data-ClassLibrary. What do I have to do to display a preview inside the Visual Studio ReportDesigner? I just can't find any help document for that scenario. The objectDataSources are not even instantiated when showing preview. :-(

And second question: why is it still (after YEARS) not possible to enter a value for an external stylesheet that is an embedded resource? You have to open the designer code to accomplish that. Is this SO HARD TO DEVELOP for Telerik?

Nasko
Telerik team
 answered on 21 Apr 2015
1 answer
112 views

We are designing a report with an ObjectDataSource in Visual Studio 2013.

The ObjectDataSource uses a method to retrieve data-items.

All works fine when the code needed to retrieve data is included in same library as the report.

However, when I want to use another (shared) library to retrieve the data, the designer fails to load that assembly (that's the exception that is shown).

I know that putting the library in same location as Visual Studio works, but that's not an option for us.

 

Nasko
Telerik team
 answered on 21 Apr 2015
2 answers
55 views

Hi

 We use RadPdfViewer 2013 Q1 in our Silverlight application. After installing a fresh copy of Chrome v42, enabling NPAPI in Chrome://flags and enabling Silverlight Plugin, report still cannot be previewed. Report could be previewed fine in the old version of Chrome (e.g. v39).

Any other flags, plugins and extensions do I need to turn on in Chrome v42?

Previewed report result is attached.

Thanks

Matt
Top achievements
Rank 1
 answered on 20 Apr 2015
1 answer
79 views

Hi all!

I have installed Reporting Trial version and I want to create a report using XML Datasource.

Reading online  documentation, i found this article :

"Binding to XML at Design-Time using an XMLDataSource"

link: http://www.telerik.com/help/reporting/buildingdatabindxmldesigntime.html .

but in my software i not found "Chart Smart Tag " and when i want to select a Data Source i have only these option  ( DataSourceWizard1.png) .

any suggestions???

 

Thanks,

Elena

 

Stef
Telerik team
 answered on 20 Apr 2015
1 answer
681 views

Hi,

I have Crystal rpt files and I need convert to trdx file with Telerik Report with Standalone Designer.

Actualy I using Crystal Reports version 14.1.4.1327 and my machine support 64 bit but I see this eror message.

"Could not load file or assembly 'CrystalDesicions.CrystalReports.Engine,version=10.2.3600.0 , culture=Neutral'. PublicKeyToken=''692bea5521e1304' or one of its dependencies.The system cannot file the file specified."




Nasko
Telerik team
 answered on 20 Apr 2015
1 answer
64 views

Hi.

My report class looks like this:

public partial class SystemReport<THeader, TBody> : Report
        where THeader : Report, new()
        where TBody : Report, new()
    {
        public THeader ReportHeader { get; private set; }
        public TBody ReportBody { get; private set; }
 
        public SystemReport()
        {
            InitializeComponent();
            InitializeSubReportHeader();
            InitializeSubReportBody();
        }
 
        private void InitializeSubReportHeader()
        {
            ReportHeader = new THeader();
            headerReportSource = new InstanceReportSource { ReportDocument = ReportHeader };
            InitSubReport(ReportHeader, subReportHeader, headerReportSource);
        }
 
        private void InitializeSubReportBody()
        {
            ReportBody = new TBody();
            bodyReportSource = new InstanceReportSource { ReportDocument = ReportBody };
            InitSubReport(ReportBody, subReportBody, bodyReportSource);
        }
 
        private void InitSubReport(Report report, SubReport subReport, ReportSource reportSource)
        {
            ((ISupportInitialize)(report)).BeginInit();
            subReport.ReportSource = reportSource;
        }
    }

 

The way I create the report where OperationHeader and OperationBody are seperate subReports:

var report = new SystemReport<OperationHeader, OperationBody> {DataSource = model};
report.ReportBody.DataSource = model;
report.ReportHeader.DataSource = model;

After assigning above created report to reportViewer.ReportSource everything is displayed correctly.  

Now I want to serialize this report. It seems to be possible using ReportXmlSerializer class. The think is that when the report is deserialized, type of report is no longer SystemReport but Report base type.

As I understood it correctly when report is deserialized I have to assign once again data sources. I'm doing it in this way:

foreach (var item in systemReport.Items.OfType<Telerik.Reporting.DetailSection>())
            {
                var subReport = item.Items.OfType<Telerik.Reporting.SubReport>().Single();
                subReport.Report.DataSource = model;
            }
 
            foreach (var item in systemReport.Items.OfType<Telerik.Reporting.ReportHeaderSection>())
            {
                var subReport = item.Items.OfType<Telerik.Reporting.SubReport>().Single();
                subReport.Report.DataSource = model;
            }
 
            systemReport.DataSource = model;

But actually after assigning report to reportViewer.ReportSource, subReports are not rendered at all.

Do you have any idea what I'm doing wrong? Or is there any other way to solve this?

Nasko
Telerik team
 answered on 17 Apr 2015
1 answer
281 views

I am a long time Telerik Reporting user, but this is my first attempt at graphs.  Any assistance is appreciated.

 

I have 2 datatables being passed to my report via a dataset.  table(0) populates the main purpose of the existing report, and is grouped with approx 200 pages of data.  I now need to add a graph to the GroupHeaderSection of the report, which I have done via the Graph Wizard.  table(1) contains the graph datasource and a sample is posted below.

 

Dim mytable As New DataTable
mytable.Columns.Add("jobcode", String.Empty.GetType())
mytable.Columns.Add("labels", String.Empty.GetType())
mytable.Columns.Add("Count", GetType(Integer))
 
mytable.Rows.Add(New Object() {"Job 93001", "20-30", 4})
mytable.Rows.Add(New Object() {"Job 93001", "30-40", 3})
mytable.Rows.Add(New Object() {"Job 93001", "40-50", 27})
mytable.Rows.Add(New Object() {"Job 93001", "50-60", 2})
mytable.Rows.Add(New Object() {"Job 93001", "60-70", 1})
mytable.Rows.Add(New Object() {"Job 93002", "20-30", 3})
mytable.Rows.Add(New Object() {"Job 93002", "30-40", 6})
mytable.Rows.Add(New Object() {"Job 93002", "40-50", 7})
mytable.Rows.Add(New Object() {"Job 93002", "50-60", 8})
mytable.Rows.Add(New Object() {"Job 93002", "60-70", 2})

 

1.  The graph is treating each row in the datatable as a series.  How do I force this to a single series for color and alignment purposes?

2.  How do I filter between the 2 datasets.  In the main report, Fields.jc is the group control.  I need to filter the graph to only show the appropriate jobcode based off of the groupheadersection.

 

Thank you.

 

 

Stef
Telerik team
 answered on 17 Apr 2015
3 answers
1.0K+ views

Hi,

I need to create a report in my MVC application that using SQL stored procedure with dynamic SQL query string and EXEC command. 

How can I do it and is there any example of that?​ 

 

Best Regards

Stef
Telerik team
 answered on 17 Apr 2015
Top users last month
Anislav
Top achievements
Rank 6
Silver
Bronze
Bronze
Jianxian
Top achievements
Rank 1
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Jim
Top achievements
Rank 2
Iron
Iron
Nurik
Top achievements
Rank 2
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?