date and time diffs: reports

Showing posts with label reports. Show all posts

Tuesday, March 27, 2012

Datasource-Microsoft Visual Studio

I am new to all SQL Related. I am trying to create a datasource to our old database we used in the company to write reports on the data. when I create a new data source and enter all required info, when testing the connection, i get a reply that I do not have the necessary permissions to use this object, although my account is specified as an administrator? can somebody please explain this to me.

I am moving this to the SQL Server Security forum.|||

From where you are connecting (trying) to this new database?

Is it from Reporting services or any other application?

|||it is saved on my computer.|||You might check the permission for the user when trying to create this D-source connection, if the user do not have corresponding database privileges then it will fail.

Datasource-Microsoft Visual Studio

I am moving this to the SQL Server Security forum.|||

From where you are connecting (trying) to this new database?

Is it from Reporting services or any other application?

Datasource-Microsoft Visual Studio

Hi Hanel O,

Try posting this query to the MSDN SQL Server Data Access Forum:
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1&bcsi_scan_A9C07E6225287F19=z5cf+RkCipiHryeey+QUUQYAAAAmrYMB&bcsi_scan_filename=ShowForum.aspx

Also here is the MSDN SQL Server Forum main page, where you will find many SQL forums dedicated to different aspects of Microsoft SQL Server:
http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

Also try looking in SQL Server Books Online, which comes as part of the SQL Server install package.

Hope this helps,

Frank

Datasource information retrieved from a database

Hi everyone,
I have an assembly deployed on my report server that contains a number of
functions used by my reports. The assembly has full trust and all of the
functions work fine except one.
The purpose of this function is to query a database table for the correct
connection string for the report datasource. The code that returns the
connection string works correctly in a test windows app. When I run the
report through report manager, I get the following error:
Does this mean that a report server can only use the database where it
stores its server information? This would be inconvenient and I would like
to avoid it if possible.
Also, I would prefer my assembly not to have full trust, and instead only
have the permissions necessary to allow it to read from the database where
the connection string information is stored. So far, I have found plenty of
sample code describing the XML that I need to add to grant
FileIOPermissions, but nothing on database-related permissions. Can anyone
point me in the right direction?
Thanks in advance,
Ed AllisonFor anyone else who gets stuck on this, the solution is here:
http://blogs.sqlxml.org/bryantlikes/archive/2004/07/21/845.aspx
"Ed Allison" <ed@.optix.co.uk> wrote in message
news:eMGQtxzUGHA.5996@.TK2MSFTNGP10.phx.gbl...
> Hi everyone,
> I have an assembly deployed on my report server that contains a number of
> functions used by my reports. The assembly has full trust and all of the
> functions work fine except one.
> The purpose of this function is to query a database table for the correct
> connection string for the report datasource. The code that returns the
> connection string works correctly in a test windows app. When I run the
> report through report manager, I get the following error:
> Does this mean that a report server can only use the database where it
> stores its server information? This would be inconvenient and I would
> like to avoid it if possible.
> Also, I would prefer my assembly not to have full trust, and instead only
> have the permissions necessary to allow it to read from the database where
> the connection string information is stored. So far, I have found plenty
> of sample code describing the XML that I need to add to grant
> FileIOPermissions, but nothing on database-related permissions. Can
> anyone point me in the right direction?
> Thanks in advance,
> Ed Allison
>

DataSource for Exchange

I found some reports for exchanges.
Now I need to create a Datasource.
Does anyone know how to find the
exchange server name?
exchange login name?
exchange login password?
once I have a working datasource These reports should work.
Scott BurkeOn Nov 28, 3:20 pm, Scott Burke <ScottBu...@.discussions.microsoft.com>
wrote:
> I found some reports for exchanges.
> Now I need to create a Datasource.
> Does anyone know how to find the
> exchange server name?
> exchange login name?
> exchange login password?
> once I have a working datasource These reports should work.
> Scott Burke
This link might be helpful.
http://msdn2.microsoft.com/en-us/library/bb264455.aspx
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi EMartinez, Thank you for the input. I did install the ManagementPack.exe
and it did stay it was installed but I cant find it on my computer! When I
try to reinstall the ManagementPack.exe but it state that it is installed.
IS this a stand alone programm? or is this a service? Do I have to find a
program to us this?
Scott Burke
"EMartinez" wrote:
> On Nov 28, 3:20 pm, Scott Burke <ScottBu...@.discussions.microsoft.com>
> wrote:
> > I found some reports for exchanges.
> > Now I need to create a Datasource.
> >
> > Does anyone know how to find the
> > exchange server name?
> > exchange login name?
> > exchange login password?
> >
> > once I have a working datasource These reports should work.
> >
> > Scott Burke
>
> This link might be helpful.
> http://msdn2.microsoft.com/en-us/library/bb264455.aspx
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Datasource error after deployment

reports run fine in studio. When I deploy the reports that reference a 2k
box, I get an error saying I'm unablt to connect to the data source unless we
promt for name and password and pass them as windows credentials. How do I
use the user's windows credentials?Once I granted access to nt authority\anonymous logon, my problems
disappeared. Is this an IIS setting?
"Jeff Ericson" wrote:
> reports run fine in studio. When I deploy the reports that reference a 2k
> box, I get an error saying I'm unablt to connect to the data source unless we
> promt for name and password and pass them as windows credentials. How do I
> use the user's windows credentials?

Datasource credentials and linked reports

Hi,

we have a problem with linked reports. We are using the same reports that are run on about 70 different Oracle schemas. The credential information is passed when calling the report. This works fine for reports and reports with subreports. But when linking to another reports, the credential information is lost.

Is the a possibuility to pass the datasource credential information to a linked report?

Thanks in advance for your help

Michael

you could try setting up a credential parameter on the second report, and pass the credentials of the first report through to that report using the parameter...

datasource connection error

have developed a report on a test windows server machine in SSRS 2005 which
I can access from i./e. http://localhost/reports
DataSourcce is accessed using a sql login
My colleague on his machine can not access. His error is:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'MarketAnalytics'.
(rsErrorOpeningConnection)
For more information about this error navigate to the report server on the
local server machine, or enable remote errorsCheck the SRS error logs they should have a better error for you. They can be
found in: C:\Program Files\Microsoft SQL Server\MSSQL.#\Reporting
Services\LogFiles.
--
SQL Server Developer Support Engineer
"arkiboys2" wrote:
> have developed a report on a test windows server machine in SSRS 2005 which
> I can access from i./e. http://localhost/reports
> DataSourcce is accessed using a sql login
> My colleague on his machine can not access. His error is:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'MarketAnalytics'.
> (rsErrorOpeningConnection)
> For more information about this error navigate to the report server on the
> local server machine, or enable remote errors
>

Datasource cannot be found after report redeployment

We have an application using the winforms report viewer, and it displays all our reports perfectly untill I need to redeploy a report.

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occured during report processing. The data souce 'mydatasource' cannot be found.

This error occurs irrespective of electing to re-deploy ot not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

I can reproduce the same problem hosting the reports in a web browser as well, with a slightly different error message

An error has occurred during report processing. (rsProcessingAborted). The data source 'mydatasource' cannot be found. (rsDataSourceNotFound)

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

Can I configure RS2005 to prevent this error occuring ? I have read that RS2005 seems to work a lot more within the IIS session for the user and cache things it thinks are usefull, so can I turn this behaviour off, or make it run like RS 2000 did, which provided me with a stable reporting platform?

If I cannot do this from the RS end of the system, is there any advice on using the winforms control to get around this issue - i've only just started using the control so I am not familiar with all its aspects !

Thanks

Andy

Hi Andy, did you ever resolve this? (I'm experiencing the same problem)

Cheers,

George

Sunday, March 25, 2012

Datasource cannot be found after report redeployment

We have an application using the winforms report viewer, and it displays all our reports perfectly untill I need to redeploy a report.

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occured during report processing. The data souce 'mydatasource' cannot be found.

This error occurs irrespective of electing to re-deploy ot not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

I can reproduce the same problem hosting the reports in a web browser as well, with a slightly different error message

An error has occurred during report processing. (rsProcessingAborted). The data source 'mydatasource' cannot be found. (rsDataSourceNotFound)

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

Thanks

Andy

Hi Andy, did you ever resolve this? (I'm experiencing the same problem)

Cheers,

George

Datasource

I have several hundred reports that I need to change the Datasource to point
to another server. Without going one report property at a time and changing
the datasource, is there a way to run an update statement on ReportServer
database to use the new target server for the said reports? If running an
update is not advisable then how do I make global change to the reports data
sources?
Thanks in advance for the assistance.
--
Lito DWhy don't you just change the connection string of the current Data Source
instead of creating a new one and changing all of the reports?
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Datasource
> thread-index: AcgQYLyNYww3Wxw0QxS8ZfpBNLID8A==> X-WBNR-Posting-Host: 207.46.19.168
> From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> Subject: Datasource
> Date: Tue, 16 Oct 2007 18:55:04 -0700
> I have several hundred reports that I need to change the Datasource to
point
> to another server. Without going one report property at a time and
changing
> the datasource, is there a way to run an update statement on ReportServer
> database to use the new target server for the said reports? If running an
> update is not advisable then how do I make global change to the reports
data
> sources?
> Thanks in advance for the assistance.
> --
> Lito D
>|||The problem is that some reports must stay on the live server whereas the
rest should go to another server having previous day old data. I assume
there is a utility ( not too familiar with rs.exec) that I can issue via
command line to change the datasource from one to another then manually
change the few reports that must stay on the live server.
Lito D
"Chris Alton [MSFT]" wrote:
> Why don't you just change the connection string of the current Data Source
> instead of creating a new one and changing all of the reports?
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Datasource
> > thread-index: AcgQYLyNYww3Wxw0QxS8ZfpBNLID8A==> > X-WBNR-Posting-Host: 207.46.19.168
> > From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> > Subject: Datasource
> > Date: Tue, 16 Oct 2007 18:55:04 -0700
> >
> > I have several hundred reports that I need to change the Datasource to
> point
> > to another server. Without going one report property at a time and
> changing
> > the datasource, is there a way to run an update statement on ReportServer
> > database to use the new target server for the said reports? If running an
> > update is not advisable then how do I make global change to the reports
> data
> > sources?
> >
> > Thanks in advance for the assistance.
> >
> > --
> > Lito D
> >
>|||If you are using a Shared DataSource for your reports then you are going to
have to create a new Data Source anyway. So if all you have are a few
reports to change that stay on the live server then just change the
existing Shared Data Source to point to the new server and then create a
second Data Source that points to the old server. Then manually change the
few reports to the new Shared Data Source. If you are using embedded Data
Sources in your reports then you've got a tedious job ahead of you. The
following tool might help you out but its a 3rd party tool and I haven't
really used it extensively.
http://www.sqldbatips.com/showarticle.asp?ID=62
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Datasource
> thread-index: AcgRFlfiLyP20tutQlCHtUWElaYfEw==> X-WBNR-Posting-Host: 207.46.19.197
> From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> References: <A60B2818-F70D-4150-BBA9-41BEC7FCDC93@.microsoft.com>
<4c7dqiMEIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Datasource
> Date: Wed, 17 Oct 2007 16:35:04 -0700
> The problem is that some reports must stay on the live server whereas the
> rest should go to another server having previous day old data. I assume
> there is a utility ( not too familiar with rs.exec) that I can issue via
> command line to change the datasource from one to another then manually
> change the few reports that must stay on the live server.
>
> --
> Lito D
>
> "Chris Alton [MSFT]" wrote:
> > Why don't you just change the connection string of the current Data
Source
> > instead of creating a new one and changing all of the reports?
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Datasource
> > > thread-index: AcgQYLyNYww3Wxw0QxS8ZfpBNLID8A==> > > X-WBNR-Posting-Host: 207.46.19.168
> > > From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> > > Subject: Datasource
> > > Date: Tue, 16 Oct 2007 18:55:04 -0700
> > >
> > > I have several hundred reports that I need to change the Datasource
to
> > point
> > > to another server. Without going one report property at a time and
> > changing
> > > the datasource, is there a way to run an update statement on
ReportServer
> > > database to use the new target server for the said reports? If
running an
> > > update is not advisable then how do I make global change to the
reports
> > data
> > > sources?
> > >
> > > Thanks in advance for the assistance.
> > >
> > > --
> > > Lito D
> > >
> >
> >
>sql

Datasets in Data regions

I have encountered a problem in one of my reports.
I use multiple datasets, and inside a List I have two matrices, one for my
'income' dataset and one from my 'cost' dataset. The List uses a field from
the 'income' dataset as it's 'Details Grouping'.
My problem is that even though i explicitly set the data source for the
second matrix to my 'cost' dataset, it still access the 'income' dataset. I
looked in the RDL-file and the <DataSetName> fields is correctly set as
'cost'.
Furthermore; when using the expression editor in a field in the cost-matrix,
I can only choose fields from the 'income' dataset...
Any clues as to what causes this?Your matrices are in the List data region. All items in the same data region
must use the same dataset. That is why you are getting this problem. You have
to change how you are doing this. Perhaps you need to use subreports inside
the list data region? Create a separate report for each of the matrix regions
that needs to have a different dataset. Each report must use a parameter if
you want to filter the data returned in the matrix. Add a subreport control
to the list data region and link to the report you just created, passing the
correct parameter(s) to return the data you need.
HTH
Charles Kangai, MCT, MCDBA
"Kristian Vinther" wrote:
> I have encountered a problem in one of my reports.
> I use multiple datasets, and inside a List I have two matrices, one for my
> 'income' dataset and one from my 'cost' dataset. The List uses a field from
> the 'income' dataset as it's 'Details Grouping'.
> My problem is that even though i explicitly set the data source for the
> second matrix to my 'cost' dataset, it still access the 'income' dataset. I
> looked in the RDL-file and the <DataSetName> fields is correctly set as
> 'cost'.
> Furthermore; when using the expression editor in a field in the cost-matrix,
> I can only choose fields from the 'income' dataset...
> Any clues as to what causes this?|||I combined my datasets into one, and instead used a Filter on my
matrix-rowgroups. That did the trick.
Thanks for your reply.
"Charles Kangai" wrote:
> Your matrices are in the List data region. All items in the same data region
> must use the same dataset. That is why you are getting this problem. You have
> to change how you are doing this. Perhaps you need to use subreports inside
> the list data region? Create a separate report for each of the matrix regions
> that needs to have a different dataset. Each report must use a parameter if
> you want to filter the data returned in the matrix. Add a subreport control
> to the list data region and link to the report you just created, passing the
> correct parameter(s) to return the data you need.
> HTH
> Charles Kangai, MCT, MCDBA
> "Kristian Vinther" wrote:
> > I have encountered a problem in one of my reports.
> >
> > I use multiple datasets, and inside a List I have two matrices, one for my
> > 'income' dataset and one from my 'cost' dataset. The List uses a field from
> > the 'income' dataset as it's 'Details Grouping'.
> >
> > My problem is that even though i explicitly set the data source for the
> > second matrix to my 'cost' dataset, it still access the 'income' dataset. I
> > looked in the RDL-file and the <DataSetName> fields is correctly set as
> > 'cost'.
> > Furthermore; when using the expression editor in a field in the cost-matrix,
> > I can only choose fields from the 'income' dataset...
> >
> > Any clues as to what causes this?

Datasets

When using datasets in reports, is it possible to reuse them in other
reports? For example a generic dataset that returns all employee names to
use in parameters. Another report needs the same parameter and we need to
create another dataset. Is there some mechanism to share the datasets
across reports?
This is regarding Reporting Services on SQL 2000.
ThanksCreate a sproc with parms?
--
William Stacey [MVP]
"isicoder" <isicoder@.newsgroups.nospam> wrote in message
news:OxiAWUqIGHA.1388@.TK2MSFTNGP11.phx.gbl...
| When using datasets in reports, is it possible to reuse them in other
| reports? For example a generic dataset that returns all employee names to
| use in parameters. Another report needs the same parameter and we need to
| create another dataset. Is there some mechanism to share the datasets
| across reports?
|
| This is regarding Reporting Services on SQL 2000.
|
| Thanks
|
||||Yes we do have a stored proc that has params. I was wondering about the
dataset within the report itself? Having two reports that share the same
proc (via the dataset) to get a lookup is one way (and possibly the only
way) to do it, but what about sharing the same dataset within the report
designer? I don't think MS SQL reporting services is set up to do this but
I'd like to be wrong to minimize the amount of coding I need to do for each
report.
As I'm getting up and running, I imagine one day we will be generating some
or all of our reports from code and generating the RDL on the fly. As this
question pertains to SQL Reporting 2000 we are a bit behind the times but it
would be nice to know for either version (SQL 2000 or SQL 2005) as we will
one day migrate to 2005.
Thanks
"William Stacey [MVP]" <william.stacey@.gmail.com> wrote in message
news:OX5J5tqIGHA.2320@.TK2MSFTNGP11.phx.gbl...
> Create a sproc with parms?
> --
> William Stacey [MVP]
> "isicoder" <isicoder@.newsgroups.nospam> wrote in message
> news:OxiAWUqIGHA.1388@.TK2MSFTNGP11.phx.gbl...
> | When using datasets in reports, is it possible to reuse them in other
> | reports? For example a generic dataset that returns all employee names
> to
> | use in parameters. Another report needs the same parameter and we need
> to
> | create another dataset. Is there some mechanism to share the datasets
> | across reports?
> |
> | This is regarding Reporting Services on SQL 2000.
> |
> | Thanks
> |
> |
>|||From what I've found, you can't reuse datasets, unfortunately. You're not
the first one to ask...
Stored procedures are the best way to go, but unfortunately you can't have a
list reusable datasets. That would have been great...
Kaisa M. Lindahl
"isicoder" <isicoder@.newsgroups.nospam> wrote in message
news:%23M28JR5IGHA.3224@.TK2MSFTNGP09.phx.gbl...
> Yes we do have a stored proc that has params. I was wondering about the
> dataset within the report itself? Having two reports that share the same
> proc (via the dataset) to get a lookup is one way (and possibly the only
> way) to do it, but what about sharing the same dataset within the report
> designer? I don't think MS SQL reporting services is set up to do this
> but I'd like to be wrong to minimize the amount of coding I need to do for
> each report.
> As I'm getting up and running, I imagine one day we will be generating
> some or all of our reports from code and generating the RDL on the fly.
> As this question pertains to SQL Reporting 2000 we are a bit behind the
> times but it would be nice to know for either version (SQL 2000 or SQL
> 2005) as we will one day migrate to 2005.
> Thanks
>
> "William Stacey [MVP]" <william.stacey@.gmail.com> wrote in message
> news:OX5J5tqIGHA.2320@.TK2MSFTNGP11.phx.gbl...
>> Create a sproc with parms?
>> --
>> William Stacey [MVP]
>> "isicoder" <isicoder@.newsgroups.nospam> wrote in message
>> news:OxiAWUqIGHA.1388@.TK2MSFTNGP11.phx.gbl...
>> | When using datasets in reports, is it possible to reuse them in other
>> | reports? For example a generic dataset that returns all employee names
>> to
>> | use in parameters. Another report needs the same parameter and we need
>> to
>> | create another dataset. Is there some mechanism to share the datasets
>> | across reports?
>> |
>> | This is regarding Reporting Services on SQL 2000.
>> |
>> | Thanks
>> |
>> |
>>
>

Wednesday, March 21, 2012

dataset isn't showing

SQL/RS 2K, VS .Net 2003 - several single resultset/dataset reports working
just fine, finally got some multiple-resultset/dataset reports working very
well, too. today, however, i am creating a new one that isn't working, and i
can't yet determine why.
i have 5 different datasets so far, each are command type text, each field
presents the data just fine in the Data tab. I've created tables in the
Layout tab for each dataset, and dragged/dropped the fields into each
accordingly. When I go into the Preview tab, each dataset/table is visible
only intermittently' Meaning, I'm in Preview, and 3 of the five
datasets/tables are showing data, the other two are blank. Now, if i hit
refresh, only two are showing data... AND one of them is one that wasn't
showing data a moment ago.
I'm setting this thing up just like the three i did yesterday, which are
working just fine.
Can anybody provide any direction on this? It's very, very important, and I
do appreciate any assistance.
--
LynnWeird. I haven't seen this before. I suggest trying to deploy and see if
this is something only from the development environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lynn" <Lynn@.discussions.microsoft.com> wrote in message
news:278379C7-06BF-4726-B3DA-18EE50B6EAFA@.microsoft.com...
> SQL/RS 2K, VS .Net 2003 - several single resultset/dataset reports working
> just fine, finally got some multiple-resultset/dataset reports working
> very
> well, too. today, however, i am creating a new one that isn't working,
> and i
> can't yet determine why.
> i have 5 different datasets so far, each are command type text, each field
> presents the data just fine in the Data tab. I've created tables in the
> Layout tab for each dataset, and dragged/dropped the fields into each
> accordingly. When I go into the Preview tab, each dataset/table is
> visible
> only intermittently' Meaning, I'm in Preview, and 3 of the five
> datasets/tables are showing data, the other two are blank. Now, if i hit
> refresh, only two are showing data... AND one of them is one that wasn't
> showing data a moment ago.
> I'm setting this thing up just like the three i did yesterday, which are
> working just fine.
> Can anybody provide any direction on this? It's very, very important, and
> I
> do appreciate any assistance.
> --
> Lynn

Dataset - Command type question

Hi to all
I need to use a set of stored procedures as source of my report datasets, my
problem is that I have several reports already created some of them using
StoredProcedure as command type, and others using Text and using "EXEC
MyStoreProcedure @.Param1,@.Param2" as the Query String , it seems to work in
the same way, change one of the sets of reports can cost some resources of
my team.
My question is if no exist differences or I can have problems with this
second type of datasets?
ThanksFor "SQL Server" connections they are for all practical purposes identical.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mauricio Cadima" <mcadima@.jalasoft.com> wrote in message
news:#XmzhXedEHA.2544@.TK2MSFTNGP10.phx.gbl...
> Hi to all
> I need to use a set of stored procedures as source of my report datasets, my
> problem is that I have several reports already created some of them using
> StoredProcedure as command type, and others using Text and using "EXEC
> MyStoreProcedure @.Param1,@.Param2" as the Query String , it seems to work in
> the same way, change one of the sets of reports can cost some resources of
> my team.
> My question is if no exist differences or I can have problems with this
> second type of datasets?
> Thanks
>sql

Thursday, March 8, 2012

Data-Driven Subscriptions

I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.

Any help, comments, or even suggestions will be very welcome.

Kind Regards
Carel Greaves

Hi,

Is the SSAS also 2005 or is it 2000?

|||What do you have in the RS windows service logfile <Program Files>\Microsoft SQL Server\MSSQL.#\Reporting Services\LogFiles\ReportServerService__<timestamp>.log at the time when DD subscription fires?|||SSAS is also 2005, i had a problem with the cubes before SP1 was released, but after SP! the Cubes and SSAS 2005 seems to be working fine|||There are two log files there so i pasted both for you

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>South Africa Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__11_22_2006_00_04_51.log</Path>
<SystemName>FORGE2005</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!7!11/22/2006-00:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-00:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-00:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-00:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-01:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-01:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-02:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-02:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-03:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-03:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-04:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-04:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-04:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-05:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-05:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-05:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-05:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-06:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-06:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-06:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-07:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-07:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-07:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-08:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-08:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-08:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-09:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-09:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-09:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:00:33:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:00:34:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:00:36:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:15:: i INFO: Call to ListTasks
w3wp!library!6!11/22/2006-10:01:15:: i INFO: Call to GetRoleProperties:System Administrator
w3wp!library!6!11/22/2006-10:01:24:: i INFO: Call to SetRoleProperties:System Administrator
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to ListTasks
w3wp!library!8!11/22/2006-10:01:27:: i INFO: Call to GetRoleProperties:System User
w3wp!library!8!11/22/2006-10:01:28:: i INFO: Call to SetRoleProperties:System User
w3wp!library!7!11/22/2006-10:01:39:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:40:: i INFO: Call to GetSystemPermissions
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!7!11/22/2006-10:01:59:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:00:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:11:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:12:: i INFO: Call to GetSystemPermissions
w3wp!library!8!11/22/2006-10:02:20:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:22:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!1!11/22/2006-10:02:22:: i INFO: Call to ListHistory( '/FutureCOM/90-10 Report' )
w3wp!library!7!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:23:: i INFO: Call to GetPermissions:/FutureCOM/90-10 Report
w3wp!library!8!11/22/2006-10:02:24:: i INFO: Call to GetSystemPermissions
w3wp!library!1!11/22/2006-10:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-10:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-10:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-10:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-11:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-11:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!1!11/22/2006-11:44:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-11:54:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:04:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!7!11/22/2006-12:14:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!6!11/22/2006-12:24:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!library!8!11/22/2006-12:34:51:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!6!11/22/2006-12:36:42:: i INFO: Reporting Web Server stopped

And the Second one is:

Kind Regards|||Here is my Stored Proc that i use to run the reports in a batch along with an error that i got in the log file, perhaps there is something here that you could find missing, although this stored proc worked perfectly in SQL2000:

The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>

--My Stored Procedure

set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO
-- ******************************************************************
-- FSP GET SCHEDULE PARAMETERS
-- Returns a ful list of clients forthe reporting services schedules
--
-- TEST
-- fsp_GetScheduleParameters
-- ******************************************************************
ALTER PROCEDURE [dbo].[fsp_GetScheduleParametersOriginal]
AS
BEGIN
SELECT '[Client].[All Client].[' + LTRIM(RTRIM(Province)) + ']' AS [@.paramProvince],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + ']' AS [@.paramCity],
'[Client].[All Client].[' + LTRIM(RTRIM(Province)) + '].[' + LTRIM(RTRIM(City)) + '].[' + RTRIM(Client_Name) + ']' AS [@.Client],
dbo.fnc_GetSubscriptionYear(GetDate()) AS [Year],
dbo.fnc_GetSubscriptionMonth(GetDate()) AS [Month],
'd:\Reporting Services Output\' + Client_SerialNo AS [FileName],
LTRIM(RTRIM(Province)) AS [ProvinceName],
LTRIM(RTRIM(City)) AS [CityName],
Client_KEY AS [ClientKEY],
dbo.fnc_GetSubscriptionMonthNumber(GetDate()) AS [MonthNumber]
FROM dbo.DIM_Client
WHERE Client_KEY IN (2)
--WHERE Client_KEY NOT IN (7, 8, 9, 10, 11, 12, 21, 55, 56, 57, 58, 59, 60, 62)
ORDER BY Client_SerialNo
END

One RUN on two reports: ERROR

1/10/2007 7:32:10 AM.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item fab79ac0-b671-4455-9052-4797819e7f82
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: EventPolling processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: EventPolling finished processing item 74701900-4bcc-4228-8dbd-fe9fa6f5a892
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: EventPolling finished processing item da61a67f-7f25-4a5b-85ed-b91bcc919615
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!1/10/2007-07:32:10:: NotificationPolling processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!library!f!01/10/2007-07:32:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!f!01/10/2007-07:32:10:: Notification a9a25328-7fd8-4882-848b-fd9feded8f30 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Unscanned Totals, Attempt 0
ReportingServicesService!dbpolling!f!01/10/2007-07:32:10:: NotificationPolling finished processing item a9a25328-7fd8-4882-848b-fd9feded8f30
ReportingServicesService!dbpolling!a!1/10/2007-07:32:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!d!1/10/2007-07:32:10:: NotificationPolling processing item ff57f016-470c-49d8-82db-30001b7f7fc9
ReportingServicesService!library!d!01/10/2007-07:32:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'Month' is not a valid value.
ReportingServicesService!notification!d!01/10/2007-07:32:11:: Notification ff57f016-470c-49d8-82db-30001b7f7fc9 completed. Success: False, Status: , DeliveryExtension: Report Server FileShare, Report: Assistant Activity Log Disp, Attempt 0
ReportingServicesService!dbpolling!d!01/10/2007-07:32:11:: NotificationPolling finished processing item ff57f016-470c-49d8-82db-30001b7f7fc9|||Have you checked that value returned for Month is within the valid range as it's defined by your report?|||I managed to track down my problem and there were a few, so if anyone is sitting with the same problem then please try to follow.

My reports read their path to place them from the stored procedure under d:\reporting services output\<client_serial> which is incorrect, i had to change that to a mapped path because reporting services requests a URL for a path to place the created reports, so i mapped a folder on my server and changed the path to \\reporting services output

Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX

My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

I hope that this will help other people in the future that have or had the same problem:

Kind Regards
Carel Greaves|||

Hi All

I have the same error...

ReportingServicesService!library!1a40!02/28/2007-17:51:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportParameterException: Default value or value provided for the report parameter 'servco_no' is not a valid value.

Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.

Can you please be more explient? Thank you.

Regards,

Thomas.

|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.

Kind Regards

Carel Greaves

Data-Driven Subscriptions

I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.

Any help, comments, or even suggestions will be very welcome.

Kind Regards
Carel Greaves

Hi,

Is the SSAS also 2005 or is it 2000?

And the Second one is:

The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>

--My Stored Procedure

One RUN on two reports: ERROR

Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX

My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

I hope that this will help other people in the future that have or had the same problem:

Kind Regards
Carel Greaves|||

Hi All

I have the same error...

Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.

Can you please be more explient? Thank you.

Regards,

Thomas.

|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.

Kind Regards

Carel Greaves

Data-Driven Subscriptions

I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.

Any help, comments, or even suggestions will be very welcome.

Kind Regards
Carel Greaves

Hi,

Is the SSAS also 2005 or is it 2000?

And the Second one is:

The error below has a problem with month, but i tried to pass it the value of <Month> and of <monthNumber>

--My Stored Procedure

One RUN on two reports: ERROR

Concerning my MDX reports, there is still a major flaw in Microsoft's design referring to the space handling in MDX

My MDX reports wouldn't build with the data-driven subscriptions because i had lines between my code such as:

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

it should have just been without the spaces: - Weird i know, but that was a major problem for me why my Data-driven subscription wouldn't build my MDX reports

CODE ASD:LKADL:ASJDLAS:JDSA:JDKLA

MORE CODE ASDL:KD:ASJD:SAJDL:ASJDSKL

MORE CODE ASDKJAHSFKLFHDAKLJHDKLJHDFLA

I hope that this will help other people in the future that have or had the same problem:

Kind Regards
Carel Greaves|||

Hi All

I have the same error...

Eagle1984, I don't understand... Which code are you talking about? I have an xml page and stored procedures, I think that's all.

Can you please be more explient? Thank you.

Regards,

Thomas.

|||Hi Thomas, please explain your whole problem to me and what u are trying to find out or do then i might be able to help you out.

Kind Regards

Carel Greaves

Tuesday, March 27, 2012

Datasource-Microsoft Visual Studio

Datasource-Microsoft Visual Studio

Datasource-Microsoft Visual Studio

Datasource information retrieved from a database

DataSource for Exchange

Datasource error after deployment

Datasource credentials and linked reports

datasource connection error

Datasource cannot be found after report redeployment

Sunday, March 25, 2012

Datasource cannot be found after report redeployment

Datasource

Datasets in Data regions

Datasets

Wednesday, March 21, 2012

dataset isn't showing

Dataset - Command type question

Thursday, March 8, 2012

Data-Driven Subscriptions

Data-Driven Subscriptions

Data-Driven Subscriptions

date and time diffs

Blog Archive

About Me