reporting server language

I want to change the reporting server language entirely - starting at the parameters bar.
how can i do that, where should i begin?

I don't think it is possible, unless I'm misunderstanding what you're asking. You could try to edit the .rdl file. However some of the XML tags are required tags which allow the report to render correctly, editing them could cause problems.

Reporting server is not so smart as Analysis server

Hi,

I have a fact table with 2 columns value A and value B

In Analysis server I add a calculated column C as A / B

Now my data looks like this

A B C

0 10 0

5 10 0.5

If you add totals in Analysis server you get

5 20 and 0.25 which is correct

If you add totals in Reporting server you get

5 20 and 0.5 which is not correct.

How can I fix this ?

Thanks in advance

Constantijn

If you are using a table report, in your group footer you could add an expression for C that equates to

=sum(Fields!A.value)/sum(Fields!B.Value)

|||

Or, assuming that the report uses the SSAS cube, instead of using SUM use Aggregate as explained here.

|||

Teo,

Many thanks for that tip - I had totally missed that little trick.

Will

|||Thanks, I wasn't aware of the that function

Reporting server is not so smart as Analysis server

Hi,

I have a fact table with 2 columns value A and value B

In Analysis server I add a calculated column C as A / B

Now my data looks like this

A B C

0 10 0

5 10 0.5

If you add totals in Analysis server you get

5 20 and 0.25 which is correct

If you add totals in Reporting server you get

5 20 and 0.5 which is not correct.

How can I fix this ?

Thanks in advance

Constantijn

If you are using a table report, in your group footer you could add an expression for C that equates to

=sum(Fields!A.value)/sum(Fields!B.Value)

|||

Or, assuming that the report uses the SSAS cube, instead of using SUM use Aggregate as explained here.

|||

Teo,

Many thanks for that tip - I had totally missed that little trick.

Will

|||Thanks, I wasn't aware of the that function

reporting server failing....System outof memory exception

Hi :

We have a setup reporting services for reporting...and our reports are working fine for 100-200 thousand records which is basically 1 year worth of data.

The reporting server fails when it starts processing beyond 200 thousand records...when I check the reporting log I see System outof memory exception. The reporting server has 8GB of ram and its a blade server. I dont know how to solve this issue.

Please let me know where I am doing wrong....

Thanks,

Pramod

Are you sure that SQL Server has not been restricted in how much memory is available for it to use?

Also as a general rule, I try to return as little data in the dataset for RS to process as possible. So it's better to do some GROUP BY clases in your query rather than returning all records and letting RS do the Sums.

|||You'll want to make sure SQL Server is actually "seeing" all 8 gig of ram ... I've seen a lot of admins forget to configure AWE.|||Yep sql server is made available all 7 gb of 8 gb ram...by setting /7gb in boot.ini.|||Yes adam...the RS is after group by of all fields....other wise i would get a million records without group by....

Reporting Server error

When I log onto the homepage of my reporting server I get a big RED "X" in the upper left hand corner with the word "Error". There is nothig in the event viewer to indicate a problem. I have looked at the IIS permissions and they all appear to be set properly.

Are you trying to connect to <servername>/Reports or <servername>/ReportServer?

What version are you using?

Have you checked the RS logs in ...\Program Files\...?

Reporting server causes blocking on db server

I am seeing my reporing server (v2005) has a conneciton to my db server that
is causing blocking. the dbcc inputbuffer results show this: "
ReportServer.dbo.WriteLockSession;1 "
I dont see any entries on Google for this problem, does anyone know what the
RS server is doing? the thread appears to be hung.
thanks in advance!Its a long story but the default for Sql Server is read commited meaning it
will block updates while reading the data. you can add
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
To the beginning of your query in generic query mode. This will fix the
problem.
Carl Henthorn wrote:
>I am seeing my reporing server (v2005) has a conneciton to my db server that
>is causing blocking. the dbcc inputbuffer results show this: "
>ReportServer.dbo.WriteLockSession;1 "
>I dont see any entries on Google for this problem, does anyone know what the
>RS server is doing? the thread appears to be hung.
>thanks in advance!
--
Message posted via http://www.sqlmonster.com|||ReportServer is the database used by Reporting Services. It does not contain
any data that is being reported off of by a user. Unless he has some reports
that are query RS system tables then no reports or queries whatsoever by
anybody but RS is occuring.
My question is, what is the result to other activities? I have RS running on
my datamart and see no problems.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ghunter via SQLMonster.com" <u4529@.uwe> wrote in message
news:64f4e1087cea1@.uwe...
> Its a long story but the default for Sql Server is read commited meaning
> it
> will block updates while reading the data. you can add
> SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
> To the beginning of your query in generic query mode. This will fix the
> problem.
>
> Carl Henthorn wrote:
>>I am seeing my reporing server (v2005) has a conneciton to my db server
>>that
>>is causing blocking. the dbcc inputbuffer results show this: "
>>ReportServer.dbo.WriteLockSession;1 "
>>I dont see any entries on Google for this problem, does anyone know what
>>the
>>RS server is doing? the thread appears to be hung.
>>thanks in advance!
> --
> Message posted via http://www.sqlmonster.com
>|||While I dont have anything queryin ghte ReportServer db, I did have a report
querying another db on that server. As it turns out, another team added a
report that literally hundereds of users where using to check and download as
PDF convention agendas. This second report seems to have overwhelmed the
server and cuased this problem. For my report, i pointed it to a different
server and it now runs fine, and I havnt seen any blocking since.
thank you for your help!!
"Bruce L-C [MVP]" wrote:
> ReportServer is the database used by Reporting Services. It does not contain
> any data that is being reported off of by a user. Unless he has some reports
> that are query RS system tables then no reports or queries whatsoever by
> anybody but RS is occuring.
> My question is, what is the result to other activities? I have RS running on
> my datamart and see no problems.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ghunter via SQLMonster.com" <u4529@.uwe> wrote in message
> news:64f4e1087cea1@.uwe...
> > Its a long story but the default for Sql Server is read commited meaning
> > it
> > will block updates while reading the data. you can add
> >
> > SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
> >
> > To the beginning of your query in generic query mode. This will fix the
> > problem.
> >
> >
> > Carl Henthorn wrote:
> >>I am seeing my reporing server (v2005) has a conneciton to my db server
> >>that
> >>is causing blocking. the dbcc inputbuffer results show this: "
> >>ReportServer.dbo.WriteLockSession;1 "
> >>I dont see any entries on Google for this problem, does anyone know what
> >>the
> >>RS server is doing? the thread appears to be hung.
> >>thanks in advance!
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >
>
>|||That makes sense. PDF is very intensive rendering operation.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:117C3B33-0E10-4F10-A7C9-F9ED8EBAE567@.microsoft.com...
> While I dont have anything queryin ghte ReportServer db, I did have a
> report
> querying another db on that server. As it turns out, another team added a
> report that literally hundereds of users where using to check and download
> as
> PDF convention agendas. This second report seems to have overwhelmed the
> server and cuased this problem. For my report, i pointed it to a different
> server and it now runs fine, and I havnt seen any blocking since.
> thank you for your help!!
> "Bruce L-C [MVP]" wrote:
>> ReportServer is the database used by Reporting Services. It does not
>> contain
>> any data that is being reported off of by a user. Unless he has some
>> reports
>> that are query RS system tables then no reports or queries whatsoever by
>> anybody but RS is occuring.
>> My question is, what is the result to other activities? I have RS running
>> on
>> my datamart and see no problems.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ghunter via SQLMonster.com" <u4529@.uwe> wrote in message
>> news:64f4e1087cea1@.uwe...
>> > Its a long story but the default for Sql Server is read commited
>> > meaning
>> > it
>> > will block updates while reading the data. you can add
>> >
>> > SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
>> >
>> > To the beginning of your query in generic query mode. This will fix the
>> > problem.
>> >
>> >
>> > Carl Henthorn wrote:
>> >>I am seeing my reporing server (v2005) has a conneciton to my db server
>> >>that
>> >>is causing blocking. the dbcc inputbuffer results show this: "
>> >>ReportServer.dbo.WriteLockSession;1 "
>> >>I dont see any entries on Google for this problem, does anyone know
>> >>what
>> >>the
>> >>RS server is doing? the thread appears to be hung.
>> >>thanks in advance!
>> >
>> > --
>> > Message posted via http://www.sqlmonster.com
>> >
>>

Reporting server and Active directory authentication

Hi!
Does anybody know how one can prevent users from accessing some
reports on the report server website using active directory? I have an
active directory with all the users and I would like to use this to
enable / disable users from viewing and accessing reports.
Cheers ErikOn Jan 30, 1:12 am, e...@.liffner.se wrote:
> Hi!
> Does anybody know how one can prevent users from accessing some
> reports on the report server website using active directory? I have an
> active directory with all the users and I would like to use this to
> enable / disable users from viewing and accessing reports.
> Cheers Erik
Hi Erik,
You should be able to set up securtiy via the report manager website.
Permissions can be set for folders or individually for reports. If
you look at the properties and go to the security tab, you will see
the users who have permission to access the object. To start with, you
should see the user 'BUILTIN\Administrators' as Content Manager.
Here you can add new users with different roles, or create you own
roles.
Is that what you are looking for?
Rowen