6 answers

473 views

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

254 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

550 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

106 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

159 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

205 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

3 answers

128 views

Design time error while changing the report property

Hi,

when you try to change the Report while having the visibility property set to false it will give you the following message:

“Property value is not valid.
Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration>\<system.web>\<httpModules> section in the application configuration.”

At the moment you can only change the report property in design time when the visible property is set to true.

I’m using the Q3 2008 version of Telerik Reporting.

Regards,
YCeron

General Discussions

answered on 26 Jan 2009

1 answer

145 views

Subreport Using Stored Procedure

Dear Sir.,
This is Suriya again., Now my doubt in using subreport using stored procedure with passing parameters through web forms..

Sir i need a detailed answer from you., i am waiting for ur reply..

By Suriya Narayanan

General Discussions

answered on 23 Jan 2009

4 answers

278 views

Converting Ampersand

Hi

I am currently trying to convert the code for an ampersand (&) into the actual sign. The database that I am retrieving the value from stores it as its code but when displayed in my report, it doesn't convert it. Does anyone know if it is possible to convert it when displaying the report?

Thanks

Simon

General Discussions

answered on 22 Jan 2009

1 answer

354 views

Dynamic Page Breaks

Is there any way to do a conditional page break? I have a label report that needs to have page breaks at certain places based on the data but not on a group or such. So I want to use some sort of conditional formatting or whatever to insert page breaks based on a value in one of the fields. Is this possible?

General Discussions

answered on 21 Jan 2009