Questions on Reporting Forum

1 answer

263 views

I am sure that there is something simple I am missing but...

I have creates some functions that the report uses to fill in text boxes. How do I run the VS debugger to watch that code operate? I have set break points and tried to run in debug mode to no avail. I have searched the help files but again found nothing.

Thanks,

Matthew

General Discussions

answered on 03 Feb 2009

2 answers

117 views

[Solved] Create Report Wizard Gone

I made the mistake of clicking on "Don't show me again" when the report wizard displays after clicking on add new item "Telerik Report Q3 2008". Can someone tell me how to get the wizard bacK?

Thanks

General Discussions

answered on 03 Feb 2009

2 answers

280 views

Creating Master-Detail Reports using DataSets

Dear Community,

We are currently strugling with some issues related to the Master-Details reports when using DataSets as data source. We have so far tried to follow and convert the Telerik examble http://www.telerik.com/help/reporting/designingreportsmasterdetail.html to fit our needs, however we seem to have run in to some problems along the way. To keep our problem simple, we have created a simple forms application containing a report viewer and some sample data to feed into the reports.

Our first problem is mainly getting the DataSet data to work with the detail page. So far, we have all our data in the load method of the form:

private void Form1_Load(object sender, EventArgs e)

{ ... }

We then create a new object of the MasterReport and bind the dataset to the report. This works, however we still lack to fill data onto th detail report, any idea on how to complete this sort of task?

Our second problem is getting the filtering to work properly. I have followed the guide from Telerik step-by-step, however the result is either no output, or output without filtering.

If someone have experience with using these kinds of reports based on e.g. a dataset (or basicly anything else besides the Telerik Report Wizard), it would be great with some assistance - code examples are much appreciated.

Kind regards,
S. Engel

General Discussions

answered on 03 Feb 2009

1 answer

190 views

Image Overlay in MHTMLReports

Hi there, is that possible to have image overlays (1 image on top of another), for a Report?
We actually tried that and it works in PDF and RTF, but no MHTML and report Preview.

any suggestions welcome :)

General Discussions

answered on 03 Feb 2009

1 answer

119 views

Initial date value

I have a report where I have defined parameters and filters for handling start date and end date. For the start date I would like to user =Now().AddDate(-1) but I get an error when I write that. Is there any way to solve that?

General Discussions

answered on 30 Jan 2009

1 answer

225 views

conditional formatting across multiple text boxes

I am trying to do a couple of things with conditional formatting.

1. Create a conditional format based on the returned valued from a user defined function.

I have created a user defined function that returns the text "low" , "moderate", and "high" and is shown in a text box. I would like to make the text box bold or bold italic based on the value returned. Can this be done with the conditional formatting system?

2. I will have a number of text boxes that will have the same conditional format (e.g., if value is > 5 make bold). How can I use the same formatting rules in different text boxes?

Thanks,

Matthew

(update - Would styles be the way to do these things?)

General Discussions

answered on 29 Jan 2009

1 answer

190 views

Webinar Canceled?

I would just like to say that I am dissapointed that the Telerik Reporting 101 Webinar was canceled. I had reserved time out of my day to attend, and received nothing but a terse cancellation notice minutes before the webinar was to have started. I feel you have wasted my time and provided neither the courtesy of an explanation nor a timely notification that the event was to be canceled.

I hope this is not the way you conduct webinars in the future. This is definitely a case where Telerik did not "Deliver more than expected".

General Discussions

answered on 29 Jan 2009

1 answer

307 views

Push Page Footer Contents to Bottom of Page

Is there a way to do this? I just want the contents of the page footer to display at the bottom of each page, it current will show after the end of the content for each page.

Thanks,

General Discussions

answered on 28 Jan 2009

6 answers

494 views

Page Footer Expression Problem

I am creating a report programmitically and all of the things working properly, but I have a textbox which has a expression like below:

txtBox.Value = "=Sum(mydatafield)";

The report accepts the expression but didn't show the expression result. More clearly, it is not showing the sum at page level. Although the field is visible = true, every thing is correctly implemented. However I apply the same thing at group level it is working properly and also showing the group sum. Kindly give me the hint to resolve this problem. This is urgent requirement.

Thanks,

Adeel Ahmed

General Discussions

answered on 28 Jan 2009

5 answers

269 views

Bind chart at Runtime

I am trying to bind a basic chart at runtime as a proof of concept. I have tried everything without any luck. Help! Are there any explicit instructions? Any help would be apprieciated.

Thanks,

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

using Telerik.Reporting;

using Telerik.Reporting.Drawing;

using System.Collections;

using Processing = Telerik.Reporting.Processing;

using System.Text;

using System.Data;

using System.Data.OleDb;

using Oracle.DataAccess;

using Oracle.DataAccess.Client;

using System.Configuration;

/// <summary>

/// Summary description for UtilDcpType.

/// </summary>

public partial class UtilDcpType : Telerik.Reporting.Report

{

public UtilDcpType()

{

/// <summary>

/// Required for telerik Reporting designer support

/// </summary>

InitializeComponent();

//

// TODO: Add any constructor code after InitializeComponent call

//

// TODO: This line of code loads data into the 'appDcpDataSet.appDcpDataSetTable' table. You can move, or remove it, as needed.

try

{

//this.appDcpDataSetTableAdapter1.Fill(this.appDcpDataSet.appDcpDataSetTable);

string m_connString = ConfigurationManager.ConnectionStrings["ProdOle"].ConnectionString;

OleDbConnection conn = new OleDbConnection(m_connString);

string selectCommand = @"SELECT * FROM (

SELECT UTIL_DCP_TYPE, COUNT(UTIL_DCP_TYPE) AS cnt

FROM APP_DCP

GROUP BY UTIL_DCP_TYPE) CNT

WHERE CNT.CNT > 1000";

OleDbDataAdapter adapter = new OleDbDataAdapter(selectCommand, conn);

//SqlConnection conn = new SqlConnection(

//@"Server=(local)\SQLEXPRESS;Integrated Security=true;Database=AdventureWorksT");

//string selectCommand = "SELECT * FROM Production.Product";

//SqlDataAdapter adapter = new SqlDataAdapter(selectCommand, conn);

DataSet dataSet = new DataSet();

adapter.Fill(dataSet);

this.DataSource = dataSet;

this.DataMember = "Table";

}

catch (System.Exception ex)

{

// An error has occurred while filling the data set. Please check the exception for more information.

System.Diagnostics.Debug.WriteLine(ex.Message); }

}

private void chart1_NeedDataSource(object sender, System.EventArgs e)

{

Telerik.Reporting.Processing.Chart chart = sender as Telerik.Reporting.Processing.Chart;

string m_connString = ConfigurationManager.ConnectionStrings["Prod"].ConnectionString;

OleDbConnection conn = new OleDbConnection(m_connString);

//OracleConnection conn = new OracleConnection(m_connString);

string cmdText = @"SELECT * FROM (

SELECT UTIL_DCP_TYPE, COUNT(UTIL_DCP_TYPE) AS cnt

FROM APP_DCP

GROUP BY UTIL_DCP_TYPE) CNT

WHERE CNT.CNT > 1000";

OleDbDataAdapter adapter = new OleDbDataAdapter(cmdText, conn);

// OracleDataAdapter adapter = new OracleDataAdapter(cmdText, conn);

DataSet ds = new DataSet();

//adapter.SelectCommand = cmd;

adapter.Fill(ds);

MessageBox.Show("got here!");

DataView view = ds.Tables[0].DefaultView;

view.Sort = "Rank DESC";

chart.DataSource = view;

}

General Discussions

answered on 27 Jan 2009