Report Delivery -- HELP

Is SSRS limited to delivering reports to recipients inside your domain (active directory)? I'm using an SMTP server for report delivery an have set the SendMailToUserAlias to False and still can only send reports to e-mails with my domain (user@.mycompany.com). I need to send reports to recipients outside my company -- is SSRS capable? If so, how do I configure it to do so?If PermittedHosts config setting is not set there shouldn't be restrictions to the receiving hosts. Look at the RS logs and see if there are any exceptions. The restriction could be set at the SMTP server as well.sql

report bulder error(urgent)

report builder not launched once i click the ssrs 2005 report builder. what is the reason?
think you might need to be a bit more descriptive than this!

And maybe posting it in the reporting services forum, probably more experts aware of your problem in that forum.

Cheers

Matt

Report Builder, Getting Started Pane: OK greyed out

Hi all,

I'm working on a new SSRS implementation, and have created a Report Model against an SSAS database. I launced Report Builder and can see and select the model in the list, but the OK button at the bottom of the pane is greyed out so I'm unable to actually start building a report against it. Any ideas on what I need to change to make the button work? I have already verified that I have full access to the data source as well as the model, in addition to the underlying SSAS DB, so I don't believe it is a permissions issue... But I'm certainly open to any suggestions.

Thanks!

You are probably running into this (from http://support.microsoft.com/kb/899825):

In Report Builder, when you select a report model that was generated from an Analysis Services cube, you must select a perspective that is contained within the model. You must not select the top-level model itself. If your report contains items that are not within a single perspective, an error may occur when you try to render the report.

Brian

Report builder problem in SSRS 2005

Hi Guys,

I had a problem which bothered me for a while, My SSRS 2005 DB is migrated from 2000, knowing that i need to manually create "Report Builder" role in item level security in report services, I've created it and gaves the tasks rights as MSDN document suggested. Now the problem is that report builder can't open any report services root thus can't open any model via webpage, however it can do so in server itself.

I think it's a security issue, anyone has got a solution for this one ?

Best Regards,

-Chris

HI,Chris:

WHAT do you mean 'can't open '? Do you have some error messages when you try to open a model via pages?

Report Builder page header

SSRS 2005. When I create a report in Report Builder from a model, I can add a
title to the report, but it doesn't repeat on subsequent pages. How can I get
it (or something) to repeat at the top of every page?
Thanks
VernI have the exact same question. If anyone could point me in the direction of
the answer in this newsgroup it would be greatly appreciated.
"Vern Rabe" wrote:
> SSRS 2005. When I create a report in Report Builder from a model, I can add a
> title to the report, but it doesn't repeat on subsequent pages. How can I get
> it (or something) to repeat at the top of every page?
> Thanks
> Vern

Report Builder grouping?

Hello,
I am experiencing some funky (yes, that is a technical term) behavior with
SSRS 2005 Report Builder. I have a model setup with some of the fields set
to have their DiscourageGrouping property equal to True and some with it to
False. It seems that only SOMETIMES, when I add the fields with the
DiscourageGrouping set to TRUE to the report it wants to create a new group
for me.
I understand that this is the behavior when you add the columns to the left
of the other fields on the report (I think that the documentation refers to
this as a Value Group). BUT this is happending when I add the field as the
first item on the report. Each subsequent field I add to the left on the
report is inserted to another "main" group...
One note about my Report Model. It was created off a SQL View, not a bunch
of tables (tables probably being the more widely used situation).
Any idea what might be causing this strange behavior?
Anywhere I can go for more information on Report Builder usage? I haven't
found a whole lot of documentation on the usage of the product out there
(other than what is in BOL).
Thanks!
-BrianOK...I know what it is doing to me...but I don't know if it is a bug or if it
was intended to act this way...
Whenever the first field on the report is defined in the Report Model with
DiscourageGrouping = False, it creates a group even though I want it
displayed with the rest of the data. When DiscourageGrouping = True, the
field will not, by default, create it's own group when it is the first field
on the report.
For example, suppose I have 3 fields in my Report Model (AccountName, State,
City, Zip). I have AccountName and State defined as DiscourageGrouping =False b/c the users may want to group on these fields sometimes, but not all
the time (when I set DiscourageGrouping = True, it looks like I can never
group on the field).
When a report creator, using Report Builder (not Repot Designer!!), to
create a report and drops AccountName on the report first, it creates a group
for AccountName. When the user adds fields to the right of the AccountName
field, the fields are in a separate group. If the user just wants a listing
of all Accounts with their addresses, with no Groupings, and they want
AccountName as the first field in the group, how is this possible'
Thanks!
-Brian
"brianpmccullough" wrote:
> Hello,
> I am experiencing some funky (yes, that is a technical term) behavior with
> SSRS 2005 Report Builder. I have a model setup with some of the fields set
> to have their DiscourageGrouping property equal to True and some with it to
> False. It seems that only SOMETIMES, when I add the fields with the
> DiscourageGrouping set to TRUE to the report it wants to create a new group
> for me.
> I understand that this is the behavior when you add the columns to the left
> of the other fields on the report (I think that the documentation refers to
> this as a Value Group). BUT this is happending when I add the field as the
> first item on the report. Each subsequent field I add to the left on the
> report is inserted to another "main" group...
> One note about my Report Model. It was created off a SQL View, not a bunch
> of tables (tables probably being the more widely used situation).
> Any idea what might be causing this strange behavior?
> Anywhere I can go for more information on Report Builder usage? I haven't
> found a whole lot of documentation on the usage of the product out there
> (other than what is in BOL).
> Thanks!
> -Brian

Report Builder 401 Errors since SP1

I have been accessing SSRS and Report Builder on a SQL 2005 from the
Internet successfully for some time now but today I am receiving 401 errors
when I try to launch Report Builder. The details show a 401 error
"Unauthorized". This all worked fine until I installed SQL 2005 SP1.
Has anybody run into this before or any suggestions. I can still run saved
reports just fine, it is only the launch of Report Builder that fails.
Thanks, MikeWe got this from Report Manager after we installed Microsoft Windows
Server 2003 Service Pack 1 (SP1).
http://support.microsoft.com/Default.aspx?kbid=896861 solved our
problem.
Neil
Mike Morisoli wrote:
> I have been accessing SSRS and Report Builder on a SQL 2005 from the
> Internet successfully for some time now but today I am receiving 401 errors
> when I try to launch Report Builder. The details show a 401 error
> "Unauthorized". This all worked fine until I installed SQL 2005 SP1.
>
>
> Has anybody run into this before or any suggestions. I can still run saved
> reports just fine, it is only the launch of Report Builder that fails.
>
>
> Thanks, Mike

Report Builder - Formatting numeric output - help

Hi -

I've worked a lot with SSRS 2000 - just starting with 2005. Report Builder is very cool. I build a Report Model - then built some reports biased on the model - all went well including filtering until I attempted to format the numeric data - specifically monetary data. I right clicked on the field in the designer and format was an option - but when I select format - all the numeric options are grayed out an unelectable.

The really interesting this is that if I then create a calculated field biased on tow of the numeric fields - like Total Sales Amount \ Total Orders - I CAN then format that new calculated field field. So - of course I then attempted to alter the formula of on of the base fields - like Total Sales Amount = Total Sales Amount * 1 to see if that would work - no - it did not.

I am stumped?

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

|||

Jim From Florida wrote:

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

Is this a matrix report baised on a Report Mode for ad hoc reporting - or a regular report matrix? I have had no problems formatting fields in regular matrix reports...

To answer your question - I have not resolved the Ad Hoc report model formating issue...

Report Builder - Formatting numeric output - help

Hi -

I've worked a lot with SSRS 2000 - just starting with 2005. Report Builder is very cool. I build a Report Model - then built some reports biased on the model - all went well including filtering until I attempted to format the numeric data - specifically monetary data. I right clicked on the field in the designer and format was an option - but when I select format - all the numeric options are grayed out an unelectable.

The really interesting this is that if I then create a calculated field biased on tow of the numeric fields - like Total Sales Amount \ Total Orders - I CAN then format that new calculated field field. So - of course I then attempted to alter the formula of on of the base fields - like Total Sales Amount = Total Sales Amount * 1 to see if that would work - no - it did not.

I am stumped?

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

|||

Jim From Florida wrote:

I am having the same problem with the Totals in a Matrix (cross-tab) report. Did you or anyone every find a solution?

Thanks in advance.

Is this a matrix report baised on a Report Mode for ad hoc reporting - or a regular report matrix? I have had no problems formatting fields in regular matrix reports...

To answer your question - I have not resolved the Ad Hoc report model formating issue...

Report automatically runs with null params allowed. SSRS 2000

I see that other people have had a problem with this, but I never saw
a solution or a work around. Has anyone found a work around to this
issue? I want to allow nulls in all the parameters, but I don't want
the report to run by itself in Report Manager.
And does anyone know if this is fixed in SSRS 2005? We'll be
migrating to that later this year.
TIAOn Sep 17, 10:20 am, beener <rmp_c...@.hotmail.com> wrote:
> I see that other people have had a problem with this, but I never saw
> a solution or a work around. Has anyone found a work around to this
> issue? I want to allow nulls in all the parameters, but I don't want
> the report to run by itself in Report Manager.
> And does anyone know if this is fixed in SSRS 2005? We'll be
> migrating to that later this year.
> TIA
As far as I know, this is still the case in SSRS 2005. I've seen
several posts requesting this functionality. The only thing I can
think of is to have one of the parameters not have a default value.
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Access over the internet

Hi,

I need to install and setup accounts so that external users can see the reports

over the internet. The SQL Server is behind a firewall and SSRS 2000 will be on a separate machine.

Would someone know how I can install RS and what kind of accounts need to be created and set up so users outside the network can see the reports?

Very much appreciate your help!

Take a look at using Forms Authentication with Reporting Services. This is the recommended way to access reports from the internet. There are other ways(enabling Anon access), but they are not recommended.

http://msdn2.microsoft.com/en-us/library/ms152899.aspx

http://blogs.msdn.com/bimusings/archive/2005/08/04/447939.aspx