A data source instance has not been supplied for the data source

Hi Guys,

I have create a report and it works in development mode. But when I call this report from aspx page it give me above error message. Please let me know how can I setup datasource of this report at runtime. Below is my code

Regards

ReportParameter[] rptPara = new ReportParameter[1];

rptPara[0] = new ReportParameter("rDate", WebDateChooser1.Text, false);

ReportViewer1.LocalReport.ReportPath = @."C:Business\RPT585.rdl";

ReportViewer1.LocalReport.SetParameters(rptPara);

ReportViewer1.LocalReport.Refresh();

Please anybody could let me guide here....

|||

This is how you can provide DataSource information to report at runtime.

Example:

ObjectDataSource objAdventureWorks = new ObjectDataSource("MyData", "GetDataAddress");

objAdventureWorks.ID = "Adventureworks";

this.Controls.Add(objAdventureWorks);

this.ReportViewer.LocalReport.DataSources.Add(new ReportDataSource("AdventureWorks2000", "Adventureworks"));

|||

I have added the datasource of my report but still keep getting this error message. Please let me guide how to fix this error. adn how to set data source instance. Below is my code

ReportParameter[] rptPara = new ReportParameter[1];

rptPara[0] = new ReportParameter("rDate", WebDateChooser1.Text, false);

ReportViewer1.LocalReport.ReportPath = @."C:\business\RPT528.rdl";

ReportViewer1.LocalReport.SetParameters(rptPara);

ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsCustomers"));

ReportViewer1.LocalReport.Refresh();

|||

http://blogs.msdn.com/bimusings/archive/2005/07/01/434659.aspx

I think this article should answer your question. I was experiencing the same error and Russell's work-around fixed it.

TF

90 compatability mode option not available after upgrade

I upgrade to sql 2005 from sql2000. The problem is that the compatability mode 90 is not available, 8.0 and 7.0 are, when looking at the compatability level in the properties tab. THe GUI, Management studio is loaded and operational.

What do I need to do to make the 90 compatability mode available?

Thanks!

You can use the following T-SQL Sentences to change to Compatibility Mode to 90 for your database.

USE [master]

GO

EXEC dbo.sp_dbcmptlevel @.dbname=N'MyDatabase', @.new_cmptlevel=90

GO

But, i'm sure that this will not work fine for you, because, i look that is possible that your database have enabled some features, that only work in the 80 compatibility mode, because this has been disabled or are obsolete in SQL Server 2005.

Best Regards,

|||

Are you sure you actually installed the 2005 database engine? It sounds as if just the client tools are installed. What version number is reported when you run the following SQL against the master database?

SELECT @.@.version

80 mode

Hello everybody.
What mean if server is runninf in the default 80 mode
What are 60, 65,70 mode.
Thanks for all respond."harry" <simon_add@.op.pl> wrote in message news:d1s8fk$rbv$1@.news.onet.pl...
> Hello everybody.
> What mean if server is runninf in the default 80 mode
> What are 60, 65,70 mode.
>
They are the versions of SQL Server - 6.0, 6.5, 7.0 and 8.0 (2000). The best
bet is to look up the differences in BOL, though the most significant
changes occurred between 7.0 and 8.0 as far as I know.
Yours,
Ann-Marie|||On Wed, 23 Mar 2005 18:19:57 +0100, harry wrote:

>Hello everybody.
>What mean if server is runninf in the default 80 mode
>What are 60, 65,70 mode.
>Thanks for all respond.
>
Hi Harry,
That's the compatibility mode.
60, 65, and 70 indicate that SQL Server takes some steps to pretend to
be a SQL Server 6.0, 6.5, or 7.0 installation, rather than SQL Server
2000. Some new commands are not available in the old compatibility
modes. Some fixed bugs will reappear in the old compatibility modes. And
some discontinued functions are still avaialable in the compatibility
modes.
Note that compatibility mode is a database setting - it doesn't affect
all databases on the server, just one - but it can't be switched on an
ad-hoc basis in case you need old behaviour AND new functionality.
Also note that the compatibility is limited. Many discuontinued or
changed commands, options or functionalities remain unavailable or
changed even when running at an older compatibility level.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

64bit and compatability mode

Is it possible to run SQL 2005 64bit in compatability mode?
We have one Database that will only run under SQL2000, but we want to know
whwther we can put it on a 64bit SQL2005 server
Thanks!
--
Ulli Patzer
Systems Administrator
NYCAbsolutely, there is not difference in that regard between 32 and 64 bit.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Ulli" <ulli_patzer.msn.com@.youknowhowtochangethis> wrote in message
news:BCB6604F-7DB4-4976-B832-EAA181FCDD67@.microsoft.com...
> Is it possible to run SQL 2005 64bit in compatability mode?
> We have one Database that will only run under SQL2000, but we want to know
> whwther we can put it on a 64bit SQL2005 server
> Thanks!
> --
> Ulli Patzer
> Systems Administrator
> NYC|||Thank you very much!
--
Ulli Patzer
Systems Administrator
NYC
"Andrew J. Kelly" wrote:
> Absolutely, there is not difference in that regard between 32 and 64 bit.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Ulli" <ulli_patzer.msn.com@.youknowhowtochangethis> wrote in message
> news:BCB6604F-7DB4-4976-B832-EAA181FCDD67@.microsoft.com...
> > Is it possible to run SQL 2005 64bit in compatability mode?
> >
> > We have one Database that will only run under SQL2000, but we want to know
> > whwther we can put it on a 64bit SQL2005 server
> >
> > Thanks!
> > --
> > Ulli Patzer
> > Systems Administrator
> > NYC
>