Questions on Reporting Forum

3 answers

276 views

SerializationException when using SQL Server for sessionState

I get the following exception when sessionState = SQL mode



[SerializationException: Type

'Telerik.Reporting.ObjectDataSource' in Assembly 'Telerik.Reporting, Version=4.0.10.310, Culture=neutral, PublicKeyToken=a9d7983dfcc261be' is not marked as serializable.]

System.Runtime.Serialization.FormatterServices.InternalGetSerializableMembers(RuntimeType type) +9452985

System.Runtime.Serialization.FormatterServices.GetSerializableMembers(Type type, StreamingContext context) +247

System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitMemberInfo() +160

System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitSerialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter, SerializationBinder binder) +218

System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Write(WriteObjectInfo objectInfo, NameInfo memberNameInfo, NameInfo typeNameInfo) +388

System.Runtime.Serialization.Formatters.Binary.ObjectWriter.WriteMembers(NameInfo memberNameInfo, NameInfo memberTypeNameInfo, Object memberData, WriteObjectInfo objectInfo, NameInfo typeNameInfo, WriteObjectInfo memberObjectInfo) +481

System.Runtime.Serialization.Formatters.Binary.ObjectWriter.WriteMemberSetup(WriteObjectInfo objectInfo, NameInfo memberNameInfo, NameInfo typeNameInfo, String memberName, Type memberType, Object memberData, WriteObjectInfo memberObjectInfo) +139

System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Write(WriteObjectInfo objectInfo, NameInfo memberNameInfo, NameInfo typeNameInfo, String[] memberNames, Type[] memberTypes, Object[] memberData, WriteObjectInfo[] memberObjectInfos) +186

System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Write(WriteObjectInfo objectInfo, NameInfo memberNameInfo, NameInfo typeNameInfo) +480

System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Serialize(Object graph, Header[] inHeaders, __BinaryWriter serWriter, Boolean fCheck) +444

System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph, Header[] headers, Boolean fCheck) +133

System.Web.Util.AltSerialization.WriteValueToStream(Object value, BinaryWriter writer) +1708

[HttpException (0x80004005): Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'Custom' mode.]

System.Web.Util.AltSerialization.WriteValueToStream(Object value, BinaryWriter writer) +1793

System.Web.SessionState.SessionStateItemCollection.WriteValueToStreamWithAssert(Object value, BinaryWriter writer) +34

System.Web.SessionState.SessionStateItemCollection.Serialize(BinaryWriter writer) +638

System.Web.SessionState.SessionStateUtility.Serialize(SessionStateStoreData item, Stream stream) +244

System.Web.SessionState.SessionStateUtility.SerializeStoreData(SessionStateStoreData item, Int32 initialStreamSize, Byte[]& buf, Int32& length, Boolean compressionEnabled) +67

System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem) +140

System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +807

System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +148

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

General Discussions

answered on 14 May 2012

0 answers

106 views

retrieve a picture

hi
i have a picture in SQL data base
i want load it in a picturebox in a form of Windows App;
use this cod but have an error

byte[] imgBytes = reader["image column"];

MemoryStream imgStream = new MemoryStream(imgBytes);

pictureBox1.Image= Image.FromStream(imgStream);

error message is :
Cannot implicitly convert type 'object' to 'byte[]'. An explicit conversion exists (are you missing a cast?)
this program is writed with C# lan;
plz help me.
thanks

General Discussions

asked on 14 May 2012

5 answers

190 views

[Solved] does not compile wpf 3.5 reporting

I downloaded a trial version of WPF and the Report found.
made a report and placed in the ReportViewer. compile error:
"Could not load file or assembly" Telerik.Windows.Controls, Version = 2012.1.215.35, Culture = neutral, PublicKeyToken = 5803cfa389c90ce7 "or one of its dependencies. Found assembly manifest definition does not match the assembly reference" .
While that worked on the previous free version of last year, but with bugs.

While downloaded and installed:
telerik.windows.controls 2012.1.326.35 version
telerik.reporting 6.0.12.302 version
Visual Studio 2010

An error during initialization.

Help me...

General Discussions

answered on 12 May 2012

1 answer

151 views

multi linq binding

Hello
My report has a lot of Linq query to display the collection into multiple tables of the report.
by reference http://www.telerik.com/community/forums/reporting/telerik-reporting/linq-or-business-object-datasource.aspx Described only as a binding collection in a single table.

I also report to the class of collections of multiple properties.
How are they tied to other tables.
that appear in the order.



public partial class BusinessObjectsReport : Report
{
    public BusinessObjectsReport()
    {
        /// <summary>
        /// Required for telerik Reporting designer support
        /// </summary>
        InitializeComponent();
          
      this.DataSource = Collection_1 as IEnumerable<item1>; //(it appears)
      this.Table_2.DataSource = Collection_2 as IEnumerable<item2>; //(how to bring?)
      this.Table_3.DataSource = Collection_3 as IEnumerable<item3>;//(how to bring?)
      this.Table_4.DataSource = Collection_4 as IEnumerable<item4>;//(how to bring?)
    }
}

Give an example of a design report, please

General Discussions

answered on 12 May 2012

3 answers

242 views

How to set up 2 dimensional array as source for parameter

I've used code behind to set up an array to supply values for a dropdown parameter. This works fine if the Display Member and Value Member are the same. But now I have a scenario where I want to have a dropdown where the display shows text and the value is an integer. There are only a few values so I didn't think I would need to create a SQL table for them, but I haven't got this to work yet.

Here is the code:

Public Sub New()

InitializeComponent()

Dim aryorder(,) As String = {{0, "Lot"}, {1, "Address"}}

Me.ReportParameters("Order").AvailableValues.DataSource = aryorder

End Sub

This works, but I can't figure out what to set for the DisplayMember property. I can use =Fields.Item to get the number for the ValueMember, but I don't know what to use for the DisplayMember. Any ideas?

Thanks

General Discussions

answered on 12 May 2012

4 answers

996 views

IIF Function and Report Parameters

Not sure how I can make this work. I get "Cannot perform '=' operation on System.Object[] and System.Int32"

Thanks for the help -- Bryan H

= IIf(Parameters.ParameterServiceTypeID.Value = 0, "Services: All", "Service: " + Fields.ServiceTypeName)

General Discussions

answered on 11 May 2012

4 answers

105 views

Grid Chart Question

Can the Grid chart "allow the user to expand and minimize the raw data view"?

What is being asked is for the Grid Chart to essentially be hidden, unless a user hits a button on the report to open that view up. I was under the impression that this was not what the software actually did. I'm trying to explain this to my PM in a way that he will understand. The closest thing I seem to find is the Filter opeion in the properties menu, but I am unsure if this is what I need to accomplish this task.

What I have right now is a Grid Chart that is displaying all of the raw data in a report via a custom SQL query. Obviously, with a 1000 results, this can be a lot of data on one report view.

General Discussions

answered on 11 May 2012

2 answers

614 views

[Solved] Italic font doesn't work in pdf format for Q1 2012

I just moved to the Q1 2012 release, and then immediately moved to the Q1 2012 (6.0.12.504) internal build because of the "add new report" problem in Visual Studio.

What I've found is that the italics text I have no longer works in the pdf (or related, the print copy). It displays correctly in VS Preview, VS Html Preview, and in the browser. If you print (pdf) or export to pdf, however, the font is not italicized.

I've attached an image showing what I'm seeing.

The font I'm using is 9pt Tahoma.

Thanks for any help!

General Discussions

answered on 11 May 2012

2 answers

252 views

Fixed Height Tables

I want to create a table of a fixed height regardless of how many items are put into the list, if there is too many items to fit in this space i want the table to be printed again on a following page. Anyone know of a way to do this?

General Discussions

answered on 11 May 2012

1 answer

776 views

Report Taking a long Time to load and Render

Hi Friends,

I ahve a report which is 10 columns wide.The problem is that though the report loads with a little delay....and when it loads and i Try to
use the scoll bar of the report viewer to drag to other columns it starts to render again for a long time ...and then i am able to use the whole report after some time..Why is it doing like that?

PS: There is a warning on My reprot deisgn..Saying that report is to wide to fit on a single page...Does this have anything to do with my problem..Please guide me...Thank you

General Discussions

answered on 11 May 2012