Questions on Reporting Forum

2 answers

200 views

Trouble creating simple report from Entity Framework edmx file

Hi all,

I'm actually working with Entity Framework Code First (DB created from coded model), but believe that Telerik Reporting doesn't yet support this. Therefore, I've created myself an edmx file from the SQL database for this purpose.

When I create a new report, the wizard launches and I'm able to select a new Entity Data Source, select the connection created with the edmx file and the context. After that, I'm presented with the Choose an Object Context Member dialog, asking me to select a member of the object context that will return data. Unfortunately, I'm unsure as to what I should be selecting at this point. Say I have a model named Products. Right now, all I'm interested in is returning every product. How would I go about this? Selecting the Products model from the dialog and clicking Finish returns an "Exception has been thrown by the target of a invocation" error.

Any help much appreciated!

General Discussions

answered on 19 May 2011

3 answers

429 views

Format of the initialization string does not conform to specification starting at index 0.

I created a simple report on three different machines, Windows 7 64bit, Win Vista 64bit and Windows XP 32 bit. On each report I get the following message:

An error has occured while processing Report '':
Format of the initialization string does not conform to specification starting at index 0.

I saw the post at http://www.telerik.com/community/forums/reporting/documentation/format-of-the-initialization-string-does-not-conform-to-specification-starting-at-index-0.aspx and I still get the error even though this is a report being used in a winforms project with a separate Report Class.

The report renders perfectly in the design preview for winforms and html.

this is the code in my code behind
        public Form1()
        {
            InitializeComponent();
            Report1 report = new Report1 ();
            ReportViewer1.Report = report;
        }

I'm using the sqlDataSouce, could this problem be caused by using SQLExpress 2008 as the backend database?

General Discussions

answered on 19 May 2011

2 answers

108 views

[Solved] differences between preview and printing (from silverlight application)

In preview my report look fine but when i print the report the margins (left and top)are missing and a field (3 red arrow) are also missing.

Any idea?

Thanks

Claudiu

General Discussions

answered on 19 May 2011

1 answer

240 views

Issues adding EntityDataSource to Report

I am experiencing issues while trying to add a EntityDataSource to a report:

Method 1:
1) Opened a new VS2010 project of "Class Library"
2) Added a new "Telerik Report Q1 2011" item to the project, and cancelled the Report Wizard
3) Added a new EntityDataSource from the toolbox
a) On the "Choose Your Data Connection" screen, selected "Specifiy a new connection string" and added the following to connect to a simple database on my local installation of SQL 2008: (See attached picture "ConnectionString")

metadata=res://*/SL_Lab1.csdl|res://*/SL_Lab1.ssdl|res://*/SL_Lab1.msl;provider=System.Data.SqlClient;provider connection string="Data Source=localhost;Initial Catalog=SL_Lab1;Integrated Security=True"

b) Proceed to the "Save the Connection String" page, leaving the "Yes, save this connection string..." checkbox checked, I click "Next" and receive a "blank" VS2010 error. (See attachment "SaveError")

Method 2:
1) I cancel the wizard and remove the EntityDataSource item from the report
2) I add an ADO.NET Entity Model to the project - named "SL_Lab1" to match the database name.
3) I add a blank table "table1" into the body of the report.
4) I switch over to the code view and update the code behind.

namespace EntitySetTest

{

using System;

using System.ComponentModel;

using System.Drawing;

using System.Windows.Forms;

using Telerik.Reporting;

using Telerik.Reporting.Drawing;

/// <summary>

/// Summary description for EntitySetReport.

/// </summary>

public partial class EntitySetReport : Telerik.Reporting.Report

{

public EntitySetReport()

{

//

// Required for telerik Reporting designer support

//

InitializeComponent();

Telerik.Reporting.EntityDataSource entityDataSource = new Telerik.Reporting.EntityDataSource();

entityDataSource.ObjectContext = typeof(SL_Lab1Entities);

Telerik.Reporting.Report report = new Telerik.Reporting.Report();

report.DataSource = entityDataSource;

table1.DataSource = entityDataSource;

}

5) Previewing the report gives me "The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid."
6) Add in the connection string

entityDataSource.ConnectionString = "SL_Lab1Entites";

6) Build and Preview - same error.
7) Change ConnectionString to:

entityDataSource.ConnectionString = "metadata=res://*/SL_Lab1.csdl|res://*/SL_Lab1.ssdl|res://*/SL_Lab1.msl;provider=System.Data.SqlClient;provider connection string="Data Source=localhost;Initial Catalog=SL_Lab1;Integrated Security=True;MultipleActiveResultSets=True"";

8) Build and Preview - same error.

I have tried this several times, with different databases and always receive an error. Either the one above or "Unable to load the specified metadata resource".

Any advice on what I am doing wrong?

General Discussions

answered on 18 May 2011

7 answers

1.0K+ views

Sum Textbox Values

I have a textbox in my detail section that gets a value from a user function. I need to sum all of those textbox values in the report footer, but I can’t get it to work. Is there a way to use the SUM function on textbox values instead of data fields?

General Discussions

answered on 18 May 2011

2 answers

554 views

Fullscreen display of report

Hello, I have created a report to display it on a web page. The data comes up fine but I am unable to find how to have the report fill the entire screen.

There seems to be no property to set the report to expand to 100% of the screen width.

I am using Q1 2011 and developing in VS 2010.

Please advise.

Thanks

General Discussions

answered on 17 May 2011

1 answer

114 views

Sending report to printer on a server

Is it possible to use Telerik Reporting to render a report on the server and send it to a server attached printer ?

We would like to invoke that kind of feature from a web service trigger.

Thanks, Erik.

General Discussions

answered on 17 May 2011

4 answers

311 views

Can we get a Calendar Control?

I would like to visualize bound dates...can you guys put together a calendar control I can bind a DateTime to which would render the selected Day\Month by any chance?

PITS?

General Discussions

answered on 17 May 2011

3 answers

133 views

Report with Different ColumnCounts

I have a report that shows some data via text boxes and a picturebox.

After this I want to have some more data. This next set of data so far is running through a table. In the test report I built, the column count works fine(I want it to take up 2/3 columns), but once I put this in another report via subReport, it fails to read the columncount. How do I get around this?

Or can I have two seperate reports that I merge together at runtime? How would I go about doing that?

General Discussions

answered on 17 May 2011

1 answer

57 views

Image as Group with Detail on the right

Just wondering if this is within the capabilities of Telerik Reporting.
I have a list of images to display along with a list of comments about the image.
I tried using a crosstab, but the formatting comes out wrong, with inconsistent image size (Xtab.jpg)
I would like it to appear with the image on the left, with the comments on the right (Mockup.jpg).

If this isn't possible, any ideas how an image with multiple comments can be formatted to display nicely in a report?
I tried using 2 columns in the report, but some comments get separated from the picture when the report continues on the second column

General Discussions

answered on 17 May 2011