Reporting Services is loosing stores credentials during connecting to Analysis Services

Hi, experts.
I have another strange problem with Reporting Services.
There are two machines:
-machine A with ReportingServices +IIS but without SQL SERVER nor
Analysis Services
-machine B with SQL Server and Reporting Services.
There is a web application in the machine A that collects data that
the web user
sends to the web server in order to pass it as parameters to Reporting
Services using a POST method. This POST method is sent from the
browsers (the web server
generates a form with hidden fields that are automatically sent to
Reporting Services by means of JavaScript).
Stored credentials are used in the datasource configuration and I've
put
all Services Packs that are available.
When the user wants to see the report for the first time, everything
works smoothly. Once it returns to the main page in order to visualize
other report or the same report once again, it is not possible to
connect to Reporting Services due to the security issues (dimension
not found error is obtained).
If I close the web browser and open it again, I can seee one report
and then
I obtain the same error.
I think that stored credentials are lost, but I have no idea how I can
fix it.
Thank you in advance for any ideas
Maciej Kiewrahmm...Are both your RS servers set up for Win Auth?
Depending on how your domain is configured, Windows credentials can be
passed across one computer connection before they expire. A user connection
to a report server counts as the first connection. If the user opens a
report that retrieves data from a remote server, that login counts as a
second connection and will fail if you are using Windows Authentication and
Kerberos is not enabled.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_datasources_v1_87e9.asp
--
Adrian M.
MCP
"Maciej Kiewra" <mkiewra@.mail.fujitsu.es> wrote in message
news:bc86bf57.0502221051.459d8e69@.posting.google.com...
> Hi, experts.
> I have another strange problem with Reporting Services.
> There are two machines:
> -machine A with ReportingServices +IIS but without SQL SERVER nor
> Analysis Services
> -machine B with SQL Server and Reporting Services.
>
> There is a web application in the machine A that collects data that
> the web user
> sends to the web server in order to pass it as parameters to Reporting
> Services using a POST method. This POST method is sent from the
> browsers (the web server
> generates a form with hidden fields that are automatically sent to
> Reporting Services by means of JavaScript).
> Stored credentials are used in the datasource configuration and I've
> put
> all Services Packs that are available.
> When the user wants to see the report for the first time, everything
> works smoothly. Once it returns to the main page in order to visualize
> other report or the same report once again, it is not possible to
> connect to Reporting Services due to the security issues (dimension
> not found error is obtained).
> If I close the web browser and open it again, I can seee one report
> and then
> I obtain the same error.
>
> I think that stored credentials are lost, but I have no idea how I can
> fix it.
> Thank you in advance for any ideas
> Maciej Kiewra|||Hi, experts
I´ve solved it. The problem was related with the user that
executed the web application ReportServer (IWAM anonymous access).
I´ve put a user that has access to Analysis Services in the anonymous
access option and now
everything works fine.
Regards
Maciej Kiewra
mkiewra@.mail.fujitsu.es (Maciej Kiewra) wrote in message news:<bc86bf57.0502221051.459d8e69@.posting.google.com>...
> Hi, experts.
> I have another strange problem with Reporting Services.
> There are two machines:
> -machine A with ReportingServices +IIS but without SQL SERVER nor
> Analysis Services
> -machine B with SQL Server and Reporting Services.
>
> There is a web application in the machine A that collects data that
> the web user
> sends to the web server in order to pass it as parameters to Reporting
> Services using a POST method. This POST method is sent from the
> browsers (the web server
> generates a form with hidden fields that are automatically sent to
> Reporting Services by means of JavaScript).
> Stored credentials are used in the datasource configuration and I've
> put
> all Services Packs that are available.
> When the user wants to see the report for the first time, everything
> works smoothly. Once it returns to the main page in order to visualize
> other report or the same report once again, it is not possible to
> connect to Reporting Services due to the security issues (dimension
> not found error is obtained).
> If I close the web browser and open it again, I can seee one report
> and then
> I obtain the same error.
>
> I think that stored credentials are lost, but I have no idea how I can
> fix it.
> Thank you in advance for any ideas
> Maciej Kiewra

Reporting Services Formatting Fields from whole minutes to hours

Dear All,

I have a problem formatting a field in Reporting Services (minutes to hours).

I have a field called duration which stores time in whole minutes only. I can format this into hours within mssql using the following:

cast(sn.duration/60 as varchar(5)) + ':' + RIGHT('0' + cast(sn.duration%60 as varchar(2)), 2)

But I need to have totals and average columns in my report, which means that the data must come through to RS in the minutes format so I can perform the calculations there.

I have the first part (I think!!):

=string.format("{0:0}",Fields!SalesTime.Value / 60) + ":"

But I cannot get the minutes part working!

Any help would be gratefully received.

Dan

note direction of the slash!

635

= (635\60) & ":" & 635 - ((635 \ 60) * 60)|||

Thank you,

with a little formatting it has worked a treat!!!

Dan