Report erroe

Hi All ,

i got tired from the component crytsal reports but i need it to finish an application i'm building .

i got the folloiwng error when i try to run the report.

ONE : Cannot implicitly convert type 'CrystalDecisions.Shared.TableLogOnInfos' to 'CrystalDecisions.Shared.TableLogOnInfo'

TWO: foreach statement cannot operate on variables of type 'CrystalDecisions.Shared.TableLogOnInfo' because 'CrystalDecisions.Shared.TableLogOnInfo' does not contain a public definition for 'GetEnumerator'

and here is the code that i'm using:

using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace Hope
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void ConfigureCrystalReports()
{

ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.DatabaseName = "NorthWind";
connectionInfo.UserID = "";
connectionInfo.Password = "";

string reportPath = Application.StartupPath + "\\" +
"NorthwindCustomers.rpt";
crystalReportViewer.ReportSource = reportPath;



SetDBLogonForReport(connectionInfo);

}

private void Form1_Load(object sender, EventArgs e)
{
ConfigureCrystalReports();

}

private void SetDBLogonForReport(ConnectionInfo connectionInfo)
{
TableLogOnInfo tableLogOnInfos = crystalReportViewer.LogOnInfo;

foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
{
tableLogOnInfo.ConnectionInfo = connectionInfo;
}


please try to help me find out , what's the problem , i'll get mad soon,hi
this is saurabh

i have creating a crystal report. in this report i want inserting no. of images .
can i put these images directly into the folders.
without saving in database.

plz... give reply as soon as possible....!|||Are you jokking ,

why to post here in my thread , create your own.

i'm so amazed from your action ,

Report Building

Can you build reports using SQL Express w/o SQL 2005. If so how, the online books are not making this very clear.You can use Microsoft SQL Server 2005 Express Edition with Advanced Services.

But this is only capable for local relational data:

-Run SQL Server Reporting Services reports on local relational data.

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=4C6BA9FD-319A-4887-BC75-3B02B5E48A40

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
sql

Report Builder Parameter List empty

After building a report in report builder, I've set on of the filters to prompt for user input "in this list". When I run the report I get a drop down list with nothing in it. I can manually type in a value an run the report but I'd like to be able to select the parameter from the list.

I've also tried clicking on (no values selected) and selected all the available values...however this gives me the same results.

I also have the same problem...and have been searching for an answer...

I know we fixed this or had a solution for this last year...and it may have something to do with the existing cardinalities in the Roles in the model...

But I'm still looking and trying to find a definite answer....

Report Builder Filter Newbie Question

Sorry for the newbie question.

I've just started building a report to display my IIS logs. I want to filter out all internal IP's, how would I do this?

Thanx

I've figured out NOT but how do I use a range of IP's?

Could I use a wild card

<>"192.168.1.*"

Or should I give it a range'

<>"192.168.1.1-192.168.1.254"

Thanx

|||

Try this

In Filter list

Use an expression instead of selecting the field/column itself like

if u have IPField

left(IPField,10) (this gives value - 192.168.1. (10 chars))

In Operator use != (Not equals)

In Value use an expression = "192.168.1."

Hope this helps u

Report Builder - Table Triangles

When building a table in report builder from related entities, there appear two small upside-down moveable triangle flags above the column headers. Moving these flags seem to affect the automatic grouping and automatic joins of the table.

Does anyone know what this feature is called? I mean, it cannot really be referred to as "those triangle things." I've searched and cannot find any reference to it. Also, does anyone know how to really use this feature?

Thanks

These sliders control the equivalent of the "Freeze Panes" feature in Microsoft Excel. They should not affect the grouping structure of the table or the underlying query.

Report Builder - Numeric Aggregate Aggravation

So I'm building a report model containing several 8 or so numeric amounts. All amounts are numeric(10,2), and there is nothing that would differentiate the columns other than their names.

One of the columns WILL NOT generate any aggregates. It just appears as an attribute. It's inexplicable.

I've even tried to build a model containing just this one numeric attribute, and it still does not work!! VS just hates this one element! Anyone seen anything like this?

I'm running VS 2005 Sp1.

Ah, the beauties of "automagic" model generation. :)

In this case, model generation thinks it's an "ID" column because it's numeric and it ends in "id", so it doesn't bother to generate aggregates. You'll have to do it manually, or change the name temporarily to fool it.

|||

WHAAAAAAAAAAAAAAATTTTTT?

What genius came up with that! Any why would an ID field be numeric 10,2!!

Thank you thank you thank you!

And how do you do manual specification of aggregates in the model?

Report Builder

Is Report Builder capable of building any complex reports that Visual Studio Report Designer can build?

What are the limitations of using Report Builder with SQL Server Databases?

Report Designer is the tool for building complex reports. In Report Builder you can only build simple reports such as a single table, matrix or graph.

The value in report builder is in creating fast ad-hoc reports without having to specify a query first. Report Builder is designed to work with SQL databases, but you have to create a model of your database first. You can do this automatically in Report Manager and then customize your model using Model Designer