1 answer

89 views

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

187 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

152 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

268 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

454 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

243 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

3 answers

531 views

No parameterless constructor

We're getting an exception thrown, when trying to load the report viewer. The contents:

Server Error in '/' Application.

No parameterless constructor defined for this object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.MissingMethodException: No parameterless constructor defined for this object.

Source Error:

An unhandled exception was generated during the execution of the
            current web request. Information regarding the origin and location of the
            exception can be identified using the exception stack trace below.

Stack Trace:

[MissingMethodException: No parameterless constructor defined for this object.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache) +86
   System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache) +230
   System.Activator.CreateInstance(Type type, Boolean nonPublic) +67
   System.Activator.CreateInstance(Type type) +6
   Telerik.ReportViewer.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context) +560

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringTypeSig, SerializationInfo info, StreamingContext context) +0
   System.Reflection.RuntimeConstructorInfo.SerializationInvoke(Object target, SerializationInfo info, StreamingContext context) +108
   System.Runtime.Serialization.ObjectManager.CompleteISerializableObject(Object obj, SerializationInfo info, StreamingContext context) +273
   System.Runtime.Serialization.ObjectManager.FixupSpecialObject(ObjectHolder holder) +49
   System.Runtime.Serialization.ObjectManager.DoFixups() +223
   System.Runtime.Serialization.Formatters.Binary.ObjectReader.Deserialize(HeaderHandler handler, __BinaryParser serParser, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage) +188
   System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Deserialize(Stream serializationStream, HeaderHandler handler, Boolean fCheck, Boolean isCrossAppDomain, IMethodCallMessage methodCallMessage) +203
   System.Web.Util.AltSerialization.ReadValueFromStream(BinaryReader reader) +788
   System.Web.SessionState.SessionStateItemCollection.ReadValueFromStreamWithAssert() +55
   System.Web.SessionState.SessionStateItemCollection.DeserializeItem(String name, Boolean check) +281
   System.Web.SessionState.SessionStateItemCollection.get_Item(String name) +19
   System.Web.SessionState.HttpSessionStateContainer.get_Item(String name) +13
   System.Web.SessionState.HttpSessionState.get_Item(String name) +13
   Telerik.ReportViewer.WebForms.ReportDataOperation.ReportFromQuery(NameValueCollection urlQuery) +163
   Telerik.ReportViewer.WebForms.ReportPageOperation.PerformOperation(NameValueCollection urlQuery, HttpContext context) +73
   Telerik.ReportViewer.WebForms.HttpHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext context) +229
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

We're testing with sessionState mode="StateServer", for the specific purpose of ensuring that we get an error like this whenever we try to put something in the Session that isn't serializable. Up 'til now, the errors that have resulted have always told us which class it was that wasn't serializable. Unfortunately, If this error is telling me which class is causing the problem, I can't see it.

"No parameterless constructor defined for this object" - which object? Of what type?

Anyone know how to find out?

General Discussions

answered on 27 Jan 2009

1 answer

91 views

Email-Report (Asp)

Hi,
I need to email the report from report viewer, but the report has to be in email body instead of attachment.

I saw the code from this forum http://www.telerik.com/community/forums/reporting/telerik-reporting/send-a-report-by-email.aspx,
but i need to display the report in email body.

Is it posible.
Help me ASP.

Thanks.
Eva

General Discussions

answered on 27 Jan 2009

0 answers

146 views

Reports load on demand

Hi all,

I have designed a report to show data but it takes long time to load

as it shows a lot of records and generate report page for each record,

so are there any method to make report show page on demand?

means show page that user clicks on paging arrows?

Regards

General Discussions

asked on 26 Jan 2009

3 answers

191 views

Build an invoice serverside and email

Hi everyone,
I have just started to play with the reporting tool provided and must say I really like it.
I am building a website that processes credit card payments using a 3rd party, I need to be able to email my users an receipt once a payment has been made. Thats were I see telerik reporting fitting in.

I have built a report that I wish to use as my template that I will contact to my datasource however I really dont know how to wire everything up.

I have an aspx page which I dont wish to show the report so I havent added a viewer but what I wish to do is create the report as a pdf and then email it. I know how to email the report but I am unsure of how I need to bind the report to my datasource,creating the pdf then sending it.

Does anyone have any tips to get me started?

General Discussions

answered on 26 Jan 2009