Questions on Reporting Forum

0 answers

106 views

Best Practices for Consuming Reports in Multiple Clients

Hi all!

Rather than try and re-invent the wheel...

I have a solution that includes a number of projects including; winform, web, and mobile clients. I also have a separate class for my reports. I also have abstracted interfaces for business logic, and also others for business objects and data access. Nothing really unusual here.

What I am looking to do is provide my users with a catalogue of reports, which will be displayed to them via a treeview control grouped by headings (parent nodes). I've considered these possible implementations:

Using a database in which I built two tables that include a Report table and a ReportGroup table. This can be used to build the treeview control on the form. Doing this would allow me to control what reports are made available to specific customers.
Through reflection, iterate through the report classes within the report assembly, and then build the treeview using the attributes of each found report class.
Build a custom config file that does the same as the above.

Does anyone have any example implementations of any of these? If so, please post some examples.

Much appreciated!

Paul

General Discussions

asked on 12 Nov 2010

5 answers

111 views

Format Pie Labels

Hello,
I'm trying to format the pie labels in my report. I have the following:

Budget:
Budget Spent: 25
Budget Remain: 75

The issue is that it's displaying like this

Budget Spent: 25.00000
Budget Remain: 75.00000

I simply want the display number to show:

Budget spent: 25%
Budget Remain: 75%

How is this done within the property of that chart control?
Please keep in mind that I'm not displaying the labels the above are to explain the situation.

General Discussions

answered on 12 Nov 2010

1 answer

137 views

Dynamic Report

I am using following code:

Dim

DynRpt As New DynamicReport

Dim SQL = "Select * from TABLE1 where rownum<=50"

Dim Constr = "Data Source=XXXX;User Id=XXX;Password=XXXX;"

Dim adp As New Devart.Data.Oracle.OracleDataAdapter(SQL, Constr)

Dim dataSet As New DataSet()

adp.Fill(dataSet)

DynRpt.DataSource = dataSet

ReportViewer1.Report = DynRpt

Report is loaded with 25 pages, but all blank. does not show any Data.
Is there anything else that needs to be done, i was following Sample from documentation

General Discussions

answered on 12 Nov 2010

1 answer

163 views

2010 Q3 One or more parameters are not set or have invalid values.

I am using the Silverlight Report Viewer and just upgraded to Q3 2010 reporting controls. Now when I try to run my report without initializing the parameters values I get the following error: 'One or more parameters are not set or have invalid values.', and the report won't even load. Before it would load and allow me to enter in the parameters that didn't have any default values. Is there a way to run a report so that the user can enter in the parameters?

I have two parameters that are hidden and three that the user needs to enter information into before the report is run. I am setting the two hidden parameters before the report runs, but not setting the other three.

Thanks!

General Discussions

answered on 12 Nov 2010

1 answer

506 views

Missing Assembly?

I downloaded the latest version of the Reporting Suite yesterday and I get this error when loading my application:

Could not load file or assembly 'Telerik.Windows.Controls, Version=2010.2.714.35, Culture=neutral, PublicKeyToken=5803cfa389c90ce7' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Error at object 'System.Windows.ResourceDictionary' in markup file 'Telerik.ReportViewer.Wpf;component/Themes/OfficeBlack/ReportViewer.xaml'.

Project References:
Telerik.Windows.Controls: 2010.3.1110.35
Telerik.ReportViewer.Wpf 4.2.10.1110
Telerik.Reporting 4.2.10.1110

XAML File:

<Window x:Class="ReportingTest.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:telerik="clr-namespace:Telerik.ReportViewer.Wpf;assembly=Telerik.ReportViewer.Wpf"

Title="MainWindow" Height="350" Width="525">

<Grid>

<telerik:ReportViewer Name="ReportViewer" />

</Grid>

</Window>

Code Behind:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Windows;

using System.Windows.Controls;

using System.Windows.Data;

using System.Windows.Documents;

using System.Windows.Input;

using System.Windows.Media;

using System.Windows.Media.Imaging;

using System.Windows.Navigation;

using System.Windows.Shapes;

using Telerik.ReportViewer.Wpf;

namespace ReportingTest

{

/// <summary>

/// Interaction logic for MainWindow.xaml

/// </summary>

public partial class MainWindow : Window

{

public MainWindow()

{

InitializeComponent();

var report = new TelerikReport();

ReportViewer.Report = report;

}

Report Designer File:

namespace ReportingTest

{

partial class TelerikReport

{

#region Component Designer generated code

/// <summary>

/// Required method for telerik Reporting designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.pageHeader = new Telerik.Reporting.PageHeaderSection();

this.detail = new Telerik.Reporting.DetailSection();

this.pageFooter = new Telerik.Reporting.PageFooterSection();

//

// TelerikReport

//

this.Style.BackgroundColor = System.Drawing.Color.White;

this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] {

this.pageHeader,

this.detail,

this.pageFooter});

}

#endregion

private Telerik.Reporting.PageHeaderSection pageHeader;

private Telerik.Reporting.DetailSection detail;

private Telerik.Reporting.PageFooterSection pageFooter;

}

Report Code File:

namespace ReportingTest

{

using System;

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

using Telerik.Reporting;

using Telerik.Reporting.Drawing;

/// <summary>

/// Summary description for TelerikReport.

/// </summary>

public partial class TelerikReport : Telerik.Reporting.Report

{

public TelerikReport()

{

//

// Required for telerik Reporting designer support

//

InitializeComponent();

//

// TODO: Add any constructor code after InitializeComponent call

//

}

<Window x:Class="ReportingTest.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:telerik="clr-namespace:Telerik.ReportViewer.Wpf;assembly=Telerik.ReportViewer.Wpf"

Title="MainWindow" Height="350" Width="525">

<Grid>

<telerik:ReportViewer Name="ReportViewer" />

</Grid>

</Window>

<Window x:Class="ReportingTest.MainWindow"

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:telerik="clr-namespace:Telerik.ReportViewer.Wpf;assembly=Telerik.ReportViewer.Wpf"

Title="MainWindow" Height="350" Width="525">

<Grid>

<telerik:ReportViewer Name="ReportViewer" />

</Grid>

</Window>

General Discussions

answered on 12 Nov 2010

4 answers

512 views

how to print telerik report without using reportviewer

Dear all,

I am using print button in radgrid.when i click print button it should dispalay print dialoguebox after selecting printer it print report. It is possible without using report viewer can call report. I set reportviewer property visible to false but not printing report.

Best rgds

Azeheruddin khan

General Discussions

answered on 12 Nov 2010

0 answers

184 views

Client print direct to Default printer

With basic ASP web application , Use

Dim

printerSettings As New System.Drawing.Printing.PrinterSettings()
It 's not problem.

But When I Use Report on "Dotnetnuke Portal", It show "Printer default is not set".

How can I set client button click event then it print to client default printer from ReportViewer.
Without show choose printr dialog.

Thanks!

General Discussions

asked on 12 Nov 2010

2 answers

157 views

Graph Not to Show when Value =0 or No Data

Hello,

I have a graph with three series in it. Each serie shows data from a column. There are some months or all the months, depending on user selections, the data in one or all columns is 0. How do I make the graphs not to show data when it is 0? I tried to use IF in my calculated fields and put null if 0 and that worked but only worked when there's some data in the column, When the entire column had no data, an error "the column is not numeric" was thrown.

Is there a way that not show the data when it is 0 even the entire column is 0? I just don't want the graph drops all the way to the bottom when 0.

Thanks!

General Discussions

answered on 11 Nov 2010

0 answers

80 views

Add Alert Column in report

Hi,
I have created a report dynamically, which contains two columns bound to 2 textboxes, now I want to display third column as alert, which will depend on Difference between the values of first two columns. Alert will be a picture box, the image path will be assigned dynamically based on difference whether negative or positive.

Can anybody help me on this?

Thank you
Rushikesh

General Discussions

asked on 11 Nov 2010

0 answers

136 views

How to equal cell's height?

Problem in telerik report sub report page. I am using tables.

Basically, All Cell(<td>) withing a Row(<tr>) has equal heights. But in my case, a cell has 6 lines texts so as having 116px height, but other cells do not equals to this one height. Other Cells have less 3/4/2 lines of texts only.

What happens is, the longer text container Cell takes Rowspan value to increase own height, which should not be the case.
See attachments.

Is there any solution on how to make all Cells height equal that are within a Row?

General Discussions

asked on 11 Nov 2010