Error loading report

I have created many crystal reports within VB.Net that are based upon an *.xsd file as the report source is dynamic. This works fine on the machine they were developed on. However I now wish to roll out the final solution and store the reports on a shared network drive whilst the VB app is on each desktop. I have tried copying the *.rpt file to the shared drive along with the *.xsd files. I even changed each report to now look at the *.xsd in the new location. However when I try to open a report I get the following error:

Error in file e:\directory\report.rpt.
Failed to load database information.

Any ideas.?

ThanksMake sure it is pointing the correct database|||Check if proper DSN is created and Verify the Database in the report at design time.|||With e:\ being the network drive my report e:\myreport.rpt is pointing to e:\myreport.xsd

which is correct as far as I know.|||Have ttried changing network paths to UNC, no joy.

Strangely, if I load the project within VB.Net, the app and the reports run fine. But when I run the installed package I get this error. This makes me think that maybe I need to package up some additional files with the app.?

error in Reports transfer from access to sql server

Hey,
I Hv been given with upsized adp and mdb. But Reports are not working...
So what could be the problem...
and how culd i solve it.
thxummmm...could you supply just a little more detail?

my usb esp port is clogged|||Sure,,
What i hv been given with are adp and mdb databases...
Now there are some bugs in the adp which wizards do not fixes automatically. So those bugs have to fix by us manually.
The first bug i found is that there is the problem in the reports. The reports after upsizing into sql server are not accessing the data from sql server...
It seems to me that these reports are not connected to sql server some how but application is running good...
I think it may need to change some code but i m unsure that which code...
So plz help..
thx|||Are you getting an error?

What's the data source?

Did all of the tables get qualified with dbo_ in front of them

What do you mean the application is runniong "good"

Can you write a new report and then see what happens?|||When i click on the control in the reports.
It gives me "Invalid Control Propety:Control Source"

and running the application means On the main form i hv some TextBoxes to filled from the database..
and those are good..
but i m having trouble with reports...|||It also says
"No such field in the field list"

error in reports

Hi group
Finally I got it installed... ;0)
when I try to access the http://server/reports/ I get the following error
Cannot use 'partitionResolver' unless the mode is StateServer' or SQLServer
I tryid to give it a seperate appPool...
I have a sharepoint on theres as well
anyone that can assist ?On Sep 11, 4:24 am, "Wiper" <taenke...@.gmail.com> wrote:
> Hi group
> Finally I got it installed... ;0)
> when I try to access thehttp://server/reports/I get the following error
> Cannot use 'partitionResolver' unless the mode is StateServer' or SQLServer
> I tryid to give it a seperate appPool...
> I have a sharepoint on theres as well
> anyone that can assist ?
You may want to check the web.config file for Reporting Services
(normally located at: C:\Program Files\Microsoft SQL Server\MSSQL.
2\Reporting Services\ReportManager -or- C:\Program Files\Microsoft SQL
Server\MSSQL.2\Reporting Services\ReportServer; however, MSSQL.2 could
be MSSQL.3) and add:
partitionResolverType="" in the sessionState key.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Error in reporting services

hi,

i am facing a problem in reporting services of Sql server 2005

i am trying to run the "third party tool"(Reports of proclarity) in sql server 2005

and i am getting the following error

An error has occurred during report processing.
Cannot create a connection to data source 'Employees_'.
Cannot connect to the server 'SYSTEM100'. The server is either not started or too busy.
Property name was not recognized, 'MDX Missing Member Mode'

regards

lalitha

This is a bit of a guess, since I don't really know much about how Proclarity works with Reporting Services, but given that 'MDX Missing Member Mode' is a valid connection string property that only appeared with AS2005 are you perhaps trying to connect to Analysis Services using an older version of the OLEDB for OLAP Provider? You should be using MSOLAP.3; if you don't have it installed, you can download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

Chris

|||

Hi Lalitha,

Check the connection string of your report (click the "Properties" tab and then select "Data Source" from the list on the left). Your connection string probably looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP;MDX Compatibility=2;MDX Missing Member Mode=Error

You need to change the "Provider" portion of the connection string from "MSOLAP" to "MSOLAP.3" so your connection string now looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP.3;MDX Compatibility=2;MDX Missing Member Mode=Error

Hope this helps,

Joe Hayes

Error in reporting services

hi,

i am facing a problem in reporting services of Sql server 2005

i am trying to run the "third party tool"(Reports of proclarity) in sql server 2005

and i am getting the following error

An error has occurred during report processing.
Cannot create a connection to data source 'Employees_'.
Cannot connect to the server 'SYSTEM100'. The server is either not started or too busy.
Property name was not recognized, 'MDX Missing Member Mode'

regards

lalitha

This is a bit of a guess, since I don't really know much about how Proclarity works with Reporting Services, but given that 'MDX Missing Member Mode' is a valid connection string property that only appeared with AS2005 are you perhaps trying to connect to Analysis Services using an older version of the OLEDB for OLAP Provider? You should be using MSOLAP.3; if you don't have it installed, you can download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en

Chris

|||

Hi Lalitha,

Check the connection string of your report (click the "Properties" tab and then select "Data Source" from the list on the left). Your connection string probably looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP;MDX Compatibility=2;MDX Missing Member Mode=Error

You need to change the "Provider" portion of the connection string from "MSOLAP" to "MSOLAP.3" so your connection string now looks something like this:

Data Source=localhost;Initial Catalog=Adventure Works DW Standard Edition;Provider=MSOLAP.3;MDX Compatibility=2;MDX Missing Member Mode=Error

Hope this helps,

Joe Hayes

Error in report services

Hi all,

I am getting the following error when iam trying to deploy my reports on a remote report server (remote machine).can anyone help me in this regard?its very urgent.

The permissions granted to user 'domainname\userid' are insufficient for performing this operation.

Thanks in advance.

Hi,

the user has to be at miminum in the publisher role. Otherwise he won′t be able to make a call to the webservice.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Error in new SQL2K5 Performance Dashboard Reports

I tried this new SQL2K5 Performance Dashboard Reports using custom reports in Management Studio.

http://www.microsoft.com/downloads/details.aspx?familyid=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

But running it first on any server gives me this error:

Difference of two datetime columns caused overflow at runtime.

Has anybody come across this error? How to fix it?

Thanks in advance!

- Rupesh

first check the sp2 is applied or not.

ref : http://blogs.msdn.com/sqlrem/archive/2007/03/07/Performance-Dashboard-Reports-Now-Available.aspx

Because DATEDIFF returns and int once you have connection that is more than 24 days or so old it will overflow the dattype if you modify the procedure so caluclates the differnce in minutes first converts this to milliseconds then add the number of minutes diffrence onto the start time and then calculate the remianing number of milli seconds it will work so basicalyy if you modify trhe offending line

sum(convert(bigint, datediff(ms, login_time, getdate()))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,

to

sum(convert(bigint, CAST ( DATEDIFF ( minute, login_time, getdate()) AS

BIGINT)*60000 + DATEDIFF ( millisecond, DATEADD ( minute,

DATEDIFF ( minute, login_time, getdate() ), login_time ),getdate() ))) - sum(convert(bigint, s.total_elapsed_time)) as idle_connection_time,

then it will work

hopes this helps the rest of you who have the same problem.

Madhu

|||

Hi,

I am facing an error saying ‘Arithmetic overflow error converting expression to data type datetime.’ In data base due to my following query.

Then I tried with cast and convert function too, still I got the error.

select*

from datetable

wherecast(('May 29 20076:30:00:000PM' - endtime) as int) >=2

andcast(('May 29 20076:30:00:000PM' - endtime)as int)<=3

anddatetable_id= 102

order by datetable_iddesc

I got this beacause of some bad ‘endtime’ data in datetable for datetable_id102 : 5465-08-12 12:00:00.000.

But I need to support all type of date here and the table is also huge. So I have this col as indexed.

I thought of to use datediff func here. again I am not sure what will be the performance impact on my query, coz it will diff and convert to int and compare for each of the row.

So can any body suggest how efficiently can I handle this?

Thanks

~Dhiru

Error in deployment of Reports

Hello,
I have built a report on SSRS 2005 and wanted to deploy that report as a
URL. However, it gives me an error which reads - "The permissions granted to
user '<Machine Name>\IUSR_<Machine Name>' are insufficient for performing
this operation. (rsAccessDenied)". Any idea whats causing this error. I get
the same message when I try to log on to http://localhost/reportserver.
The IIS on the machine has anonymous access enabled as well as Integrated
Windows Authentication.
Thanks.Bingo (anonymous access). You are not given the rights to deploy because you
are anonymous.
Turn off anonymous access on Reports and ReportServer webs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Vince Keller" <siliinvestor@.hotmail.com> wrote in message
news:Ox1%23AujPGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have built a report on SSRS 2005 and wanted to deploy that report as a
> URL. However, it gives me an error which reads - "The permissions granted
> to user '<Machine Name>\IUSR_<Machine Name>' are insufficient for
> performing this operation. (rsAccessDenied)". Any idea whats causing this
> error. I get the same message when I try to log on to
> http://localhost/reportserver.
> The IIS on the machine has anonymous access enabled as well as Integrated
> Windows Authentication.
> Thanks.
>|||That worked!
Thank you very much.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:ubRl21jPGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Bingo (anonymous access). You are not given the rights to deploy because
> you are anonymous.
> Turn off anonymous access on Reports and ReportServer webs.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Vince Keller" <siliinvestor@.hotmail.com> wrote in message
> news:Ox1%23AujPGHA.532@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I have built a report on SSRS 2005 and wanted to deploy that report as a
>> URL. However, it gives me an error which reads - "The permissions granted
>> to user '<Machine Name>\IUSR_<Machine Name>' are insufficient for
>> performing this operation. (rsAccessDenied)". Any idea whats causing this
>> error. I get the same message when I try to log on to
>> http://localhost/reportserver.
>> The IIS on the machine has anonymous access enabled as well as Integrated
>> Windows Authentication.
>> Thanks.
>

Error in CrystalReport

I have an application developed in VB 6.0, SQl and
Crystal Reports. I am getting the following error message.

"Line 77: Cannot load control CrystalReport1."

the code is

CrystalReport1.SQLQuery = lstrsql.

I have also activated the crystal report control in the components dialog box.

regs
R.PriyaraniIs there an error number? Try looking up the error number or the error description online. Sometimes you can find the answer that way.

Did you rename the control to something different and are trying to call it by the default name?

Do you have the correct dll installed on the machine you're getting the error on?|||Thank you, Malleyo I've solved the problem

error in access report manager

I am able to access report server and view the reports on my machine but when i access

the report manager it gives error

"The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version"

Is the service running ? is the database in a normal state ? Which Reporting Services version are you using ? Did you change the compatibility mode ? Was it a clean install of reporting services ?

You see, that you will have provide more information to let us help you.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

i am using RS2005 and service is running.I have not changed the compatibility mode

i installed it with sql server 2005.i checked everything that you mentioned and there is no conflict.

problem is same