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 empty?

I have created a basic report that just shows some columns from a query, I'm using a dataadapter and the reportviewer component.

If I execute the query it calles it returns some rows, but the report is empty.

What's wrong with the reportviewer and the report objects?

I'm thinking about just using gridviews because the reports don't work, altough I'd like to use the reportviewer because it can export to excel/pdf.

Thanks.

HI,onishirox:

I can not debug it without any codes from your scenario, but you can have a check with this following walkround to make your codes work:

Binding Data to the ReportViewer Control Dynamically in ASP.NET 2.0 -

http://www.aspfree.com/c/a/ASP.NET/Binding-Data-to-the-ReportViewer-Control-Dynamically-in-ASPNET-20/1/

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be

of assistance

|||

HI,onishirox:
We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

|||

Thanks. I think the problem was that I was using sqlserver2000, seems to work ok now with sql2005.

Report designer client component?

I have seen reference to the above component - can anyone
please tell me what it is? Is it an optional part of
VS2003 installation?
TIA,
JBReport Designer is SQL Server 2000 Reporting Service's report authoring
tool. It is hosted within the Visual Studio 2003 .NET shell. This means that
you have to have some component (VB .NET satisfies this requirement) of VS
2003 .NET on your machine prior to install Report Designer
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JB" <anonymous@.discussions.microsoft.com> wrote in message
news:1fac401c45840$10d78ed0$a501280a@.phx.gbl...
> I have seen reference to the above component - can anyone
> please tell me what it is? Is it an optional part of
> VS2003 installation?
> TIA,
> JB

Report Catalog Database

Hi All,

In a scale out deployment, which component sends the query to the database, the report catalog or the Report Manager?

Report Manager is just a report portal. Running a report in report manager will send a request to the RS scale out deployment. If you are using a load balancer, it will send the request to one of the server nodes in the scale out deployments. This server node (a RS web service) will then execute the report which includes running queries, retrieving data, processing data, and rendering the result and sending it back to the client (which is report manager in this case).

-- Robert

Report Authentication

This is a newbie question. I have the report viewer component on one of my
aspx pages. When the user tries to open this page, he/she is prompted with a
user/password on the server. How do I set up the reporting services so that
it uses a generic account for all requests from the web. Thanks.
PremWell, the wrong way is to turn on Anonymous access to the Report Server. The
proper way is to create a custom security extension to replace the default
Windows-based security.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"Prem" <Prem@.discussions.microsoft.com> wrote in message
news:607E279E-7CC5-4135-BA35-F786EEE2A4E6@.microsoft.com...
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with
a
> user/password on the server. How do I set up the reporting services so
that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>|||Thanks Nell. That works.
"Nell" wrote:
> You need to grant permissions to your users and groups on the report server.
> You can do this at 'http://servername/reports', select the folder you want to
> apply permissions to, then select 'properties' and 'security'. Check out this
> article on Ode to Code for more info.
> http://odetocode.com/Articles/215.aspx
> You need to give browse access to the accounts you want to be able to view
> your reports, if you're using anonymous access then you need to make sure
> that the user you have set up in IIS for anonymous access (usually
> IUSR_computername or IWAM_computername) has this level of access. Don't
> give this account any unnecessary permissions though!
> "Prem" wrote:
> > This is a newbie question. I have the report viewer component on one of my
> > aspx pages. When the user tries to open this page, he/she is prompted with a
> > user/password on the server. How do I set up the reporting services so that
> > it uses a generic account for all requests from the web. Thanks.
> >
> > Prem
> >|||You need to grant permissions to your users and groups on the report server.
You can do this at 'http://servername/reports', select the folder you want to
apply permissions to, then select 'properties' and 'security'. Check out this
article on Ode to Code for more info.
http://odetocode.com/Articles/215.aspx
You need to give browse access to the accounts you want to be able to view
your reports, if you're using anonymous access then you need to make sure
that the user you have set up in IIS for anonymous access (usually
IUSR_computername or IWAM_computername) has this level of access. Don't
give this account any unnecessary permissions though!
"Prem" wrote:
> This is a newbie question. I have the report viewer component on one of my
> aspx pages. When the user tries to open this page, he/she is prompted with a
> user/password on the server. How do I set up the reporting services so that
> it uses a generic account for all requests from the web. Thanks.
> Prem
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
Rob
Standard SQL Server can act as a Replication Publisher and MSDE can
subscribe to these publications. Why do you think you require EnterPrise
Edition...?
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>I have a requirement to implement replication between SQL Server and MSDE
>on client machines. Problem is we cannot ask our customers to purchase SQL
>Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>
|||Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>
|||For some reason I though that it was only on enterprise, RTFM I guess.
Thanks
"Stringfellow Hawke" <Stringfellow.Hawke@.gmail.com> wrote in message
news:uS%23710etEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Standard SQL Server can act as a Replication Publisher and MSDE can
> subscribe to these publications. Why do you think you require EnterPrise
> Edition...?
> "Robert Chapman" <invalid@.invalid.com> wrote in message
> news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
Rob
Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
RobStandard SQL Server can act as a Replication Publisher and MSDE can
subscribe to these publications. Why do you think you require EnterPrise
Edition...?
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>I have a requirement to implement replication between SQL Server and MSDE
>on client machines. Problem is we cannot ask our customers to purchase SQL
>Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||For some reason I though that it was only on enterprise, RTFM I guess.
Thanks
"Stringfellow Hawke" <Stringfellow.Hawke@.gmail.com> wrote in message
news:uS%23710etEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Standard SQL Server can act as a Replication Publisher and MSDE can
> subscribe to these publications. Why do you think you require EnterPrise
> Edition...?
> "Robert Chapman" <invalid@.invalid.com> wrote in message
> news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>>I have a requirement to implement replication between SQL Server and MSDE
>>on client machines. Problem is we cannot ask our customers to purchase
>>SQL Server Enterprise Edition, so we are left with the buy vs build
>>scenario.
>> Can anyone recommend any components or vendors that offer this
>> functionality? Royalty free licensing is a must.
>> Thanks in advance.
>> Rob
>

Replication/Synchronization Component

I have a requirement to implement replication between SQL Server and MSDE on
client machines. Problem is we cannot ask our customers to purchase SQL
Server Enterprise Edition, so we are left with the buy vs build scenario.
Can anyone recommend any components or vendors that offer this
functionality? Royalty free licensing is a must.
Thanks in advance.
RobStandard SQL Server can act as a Replication Publisher and MSDE can
subscribe to these publications. Why do you think you require EnterPrise
Edition...?
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>I have a requirement to implement replication between SQL Server and MSDE
>on client machines. Problem is we cannot ask our customers to purchase SQL
>Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||Why not recomend them buyingSmall Business Server 2003 Premium Edition
It only cost about $600.00 and it comes with SQL 2000
Brad Shook
"Robert Chapman" <invalid@.invalid.com> wrote in message
news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I have a requirement to implement replication between SQL Server and MSDE
on
> client machines. Problem is we cannot ask our customers to purchase SQL
> Server Enterprise Edition, so we are left with the buy vs build scenario.
> Can anyone recommend any components or vendors that offer this
> functionality? Royalty free licensing is a must.
> Thanks in advance.
> Rob
>|||For some reason I though that it was only on enterprise, RTFM I guess.
Thanks
"Stringfellow Hawke" <Stringfellow.Hawke@.gmail.com> wrote in message
news:uS%23710etEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Standard SQL Server can act as a Replication Publisher and MSDE can
> subscribe to these publications. Why do you think you require EnterPrise
> Edition...?
> "Robert Chapman" <invalid@.invalid.com> wrote in message
> news:e5jWhqetEHA.3788@.TK2MSFTNGP09.phx.gbl...
>