Showing posts with label newbie. Show all posts
Showing posts with label newbie. Show all posts

Thursday, March 22, 2012

Does Reporting Services support this?

Hi. I'm a newbie to Reporting Services and have a few questions about it,
Does Reporting Services 2005 support export to PDF? How about Word and Excel?Is it possible to group items on a report, and have comments displayed for rows that have them, as a line indented below the main row? Here's an example, My Report
Northeast Region
Smith, Jane 2/15/2006 1211156
Comments: Jane wants to attend the next regional meeting.
Smith, Joe 1/11/2006 1194833

Southeast Region
Thomas, Helen 11/12/2005 9938672

Thank you.

1. Reporting services natively supports export to pdf and excel, not to word

2. Yes you can group items like you have listed above using drill down techniques and a well structured query...

Follow this link and watch the Introduction to Reporting Services 6 part series, you'll learn oogles!

http://www.microsoft.com/events/series/sqlserverbi.mspx

Good Luck!

|||

Thank you, Josh :)

I'm sold on SSRS -- just trying to get the folks in my department on board. They've used a product called Cognos, and their users hate -- plus it costs a bundle of money to buy and maintain. Our server support folks have it ready for our testing, just need to convince the folks here this is a solid, robust solution for reporting. Thanks again.

Monday, March 19, 2012

Does not exist or access denied

Newbie thing here. When you get the message (maybe not verbatim) "SQL Server
does not exist or access denied", is there a way to tell which one it is?
Problem is, client may type in the server name wrong, or may have wrong
password. It'd be nice to know if they had the correct instance name (Server
does not exist) or the wrong credentials (access denied).
Can I differentiate between the two?
TIA,
MikeMike,
That one means the machine was not found by that name.
If it was a login failure, you'd get "Login failed for user '%ls'"
%ls will be substituted by the login you supplied.
James Hokes
"Mike Hildner" <mhildner@.afweb.com> wrote in message
news:e7ZtDK01DHA.4060@.TK2MSFTNGP11.phx.gbl...
> Newbie thing here. When you get the message (maybe not verbatim) "SQL
Server
> does not exist or access denied", is there a way to tell which one it is?
> Problem is, client may type in the server name wrong, or may have wrong
> password. It'd be nice to know if they had the correct instance name
(Server
> does not exist) or the wrong credentials (access denied).
> Can I differentiate between the two?
> TIA,
> Mike
>

Does not exist or access denied

Newbie thing here. When you get the message (maybe not verbatim) "SQL Server
does not exist or access denied", is there a way to tell which one it is?
Problem is, client may type in the server name wrong, or may have wrong
password. It'd be nice to know if they had the correct instance name (Server
does not exist) or the wrong credentials (access denied).
Can I differentiate between the two?
TIA,
MikeMike,
That one means the machine was not found by that name.
If it was a login failure, you'd get "Login failed for user '%ls'"
%ls will be substituted by the login you supplied.
James Hokes
"Mike Hildner" <mhildner@.afweb.com> wrote in message
news:e7ZtDK01DHA.4060@.TK2MSFTNGP11.phx.gbl...
quote:

> Newbie thing here. When you get the message (maybe not verbatim) "SQL

Server
quote:

> does not exist or access denied", is there a way to tell which one it is?
> Problem is, client may type in the server name wrong, or may have wrong
> password. It'd be nice to know if they had the correct instance name

(Server
quote:

> does not exist) or the wrong credentials (access denied).
> Can I differentiate between the two?
> TIA,
> Mike
>