Reporting Services

Where can I download Reporting Services Beta 2? This beta product was due for release on Oct 16.www.microsoft.com/sql/reporting/default.asp
-- Mary
MCW Technologies
http://www.mcwtech.com
On Wed, 22 Oct 2003 11:36:17 -0700, shailesh valera
<shailesh_valera@.hotmail.com> wrote:
>Where can I download Reporting Services Beta 2? This beta product was due for release on Oct 16.|||You can go to www.betaplace.com and if you have signed up and included in
the beta program you will need to login with your passport and you can
download it, if you have not signed up for the program I think there is a
link to do so.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"shailesh valera" <shailesh_valera@.hotmail.com> wrote in message
news:53CA664B-08ED-4F62-BAFA-47C29B686AC2@.microsoft.com...
> Where can I download Reporting Services Beta 2? This beta product was due
for release on Oct 16.

reporting service client and column selection

can I use excel as a client for my reporting service? I see some docs on it,
but can't find the actual product. I want the user to be able to select what
column to be displayed. Is that possible now? how about sql 2005.Reporting Services 2000 can export to Excel format.
Reporting Services 2005 can too.
Office 12 (due in about a year?) has some additional Business
Intelligence functionality. There isn't much public yet about what
that will consist of, but it looks likely that Excel will do some
interesting things with Analysis Services information.
Can you elaborate on your column-related question? I am not sure
precisely what you are asking.
Thanks
Andrew Watt
MVP - InfoPath
On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
<NewSPUser@.discussions.microsoft.com> wrote:
>can I use excel as a client for my reporting service? I see some docs on it,
>but can't find the actual product. I want the user to be able to select what
>column to be displayed. Is that possible now? how about sql 2005.|||I don't mean export, I mean using excel directly connect to a reporting
server. basically, excel acting as a fat client.
column selection: if the report dispaly a table which consists of 10
columns, however, some user may not be interested in seeing all 10 columns.
Can the end user have the ability to hide/collapse that column? i.e. make the
report to display 5 columns instead of ten.
"Andrew Watt [MVP - InfoPath]" wrote:
> Reporting Services 2000 can export to Excel format.
> Reporting Services 2005 can too.
> Office 12 (due in about a year?) has some additional Business
> Intelligence functionality. There isn't much public yet about what
> that will consist of, but it looks likely that Excel will do some
> interesting things with Analysis Services information.
> Can you elaborate on your column-related question? I am not sure
> precisely what you are asking.
> Thanks
> Andrew Watt
> MVP - InfoPath
> On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
> <NewSPUser@.discussions.microsoft.com> wrote:
> >can I use excel as a client for my reporting service? I see some docs on it,
> >but can't find the actual product. I want the user to be able to select what
> >column to be displayed. Is that possible now? how about sql 2005.
>|||I don't know precisely what BI in Office 12 will consist of but I
would expect to see more off-the-shelf functionality/integration of
SQL Server (2005?) BI apps with Office apps, including Excel then.
I believe you can use Excel (not sure which versions) to connect to a
Web Service. Since RS has a Web Service it should be possible to
produce a custom Excel app if you have the relevant VBA etc skills.
It's not something I have explored in detail.
Andrew Watt
MVP - InfoPath
On Sat, 15 Oct 2005 17:20:23 -0700, NewSPUser
<NewSPUser@.discussions.microsoft.com> wrote:
>I don't mean export, I mean using excel directly connect to a reporting
>server. basically, excel acting as a fat client.
>column selection: if the report dispaly a table which consists of 10
>columns, however, some user may not be interested in seeing all 10 columns.
>Can the end user have the ability to hide/collapse that column? i.e. make the
>report to display 5 columns instead of ten.
>"Andrew Watt [MVP - InfoPath]" wrote:
>> Reporting Services 2000 can export to Excel format.
>> Reporting Services 2005 can too.
>> Office 12 (due in about a year?) has some additional Business
>> Intelligence functionality. There isn't much public yet about what
>> that will consist of, but it looks likely that Excel will do some
>> interesting things with Analysis Services information.
>> Can you elaborate on your column-related question? I am not sure
>> precisely what you are asking.
>> Thanks
>> Andrew Watt
>> MVP - InfoPath
>> On Fri, 14 Oct 2005 11:55:02 -0700, NewSPUser
>> <NewSPUser@.discussions.microsoft.com> wrote:
>> >can I use excel as a client for my reporting service? I see some docs on it,
>> >but can't find the actual product. I want the user to be able to select what
>> >column to be displayed. Is that possible now? how about sql 2005.
>>

reporting on BLOB fields

Hello,
I am hoping that someone can help me out with this.
I am trying to debug a product that I support, the application creates its
own SQL when executing reports. The report I am trying to execute requires
a
field that is a BLOB, see the SQL below, the result is not what I was
expecting... From the application the report comes up with a black for the
PSL_NOTES field but if i execute the the SQL is Query Analyzer this is the
error I get:
"Server: Msg 306, Level 16, State 2, Line 1
The text, ntext, and image data types cannot be compared or sorted, except
when using IS NULL or LIKE operator.
"
SQL statement:
SELECT C.PRJ_NAME,D.CHH_CODE,B.PSL_NOTES,SUM(PSDETAIL.PSD_MIN) AS PSD_MIN
FROM
PSDETAIL,PSLINES B,TCPROJ C,CHRHIS D WHERE
PSDETAIL.PSD_PSL = B.PSL_KEY AND B.PSL_PRJ *= C.PRJ_KEY AND B.PSL_CHH=
D.CHH_KEY GROUP BY
C.PRJ_NAME,D.CHH_CODE,B.PSL_NOTES ORDER BY C.PRJ_NAME ASC,D.CHH_CODE
ASC,B.PSL_NOTES ASC
Thx!
MarcSince you haven't posted DDL, it's impossible to know which column(s) might
be causing the problem. But the error message says it all. If you have
TEXT, NTEXT, or IMAGE columns in your result set, they can't be ordered,
compared, or grouped. This means that your GROUP BY is probably the issue.
One workaround, if you don't mind some data truncation (if your data is over
8000 characters) is to use the SUBSTRING function to truncate the LOB data.
So insead of:
SELECT YourLOBCol
FROM YourTable
GROUP BY YourLobCol
You could do:
SELECT SUBSTRING(YourLobCol, 1, 8000) AS YourCol
FROM YourTable
GROUP BY SUBSTRING(YourLobCol, 1, 8000)
There are some other workarounds, depending on what your actual business
requirement is. Post DDL and sample data (please, keep the LOB data small)
if you need more assistance.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Marc" <Marc@.discussions.microsoft.com> wrote in message
news:CEB1B459-2832-4766-950B-1872C53115F1@.microsoft.com...
> Hello,
> I am hoping that someone can help me out with this.
> I am trying to debug a product that I support, the application creates its
> own SQL when executing reports. The report I am trying to execute
requires a
> field that is a BLOB, see the SQL below, the result is not what I was
> expecting... From the application the report comes up with a black for
the
> PSL_NOTES field but if i execute the the SQL is Query Analyzer this is the
> error I get:
> "Server: Msg 306, Level 16, State 2, Line 1
> The text, ntext, and image data types cannot be compared or sorted, except
> when using IS NULL or LIKE operator.
> "
>
> SQL statement:
> SELECT C.PRJ_NAME,D.CHH_CODE,B.PSL_NOTES,SUM(PSDETAIL.PSD_MIN) AS PSD_MIN
> FROM
> PSDETAIL,PSLINES B,TCPROJ C,CHRHIS D WHERE
> PSDETAIL.PSD_PSL = B.PSL_KEY AND B.PSL_PRJ *= C.PRJ_KEY AND B.PSL_CHH=
> D.CHH_KEY GROUP BY
> C.PRJ_NAME,D.CHH_CODE,B.PSL_NOTES ORDER BY C.PRJ_NAME ASC,D.CHH_CODE
> ASC,B.PSL_NOTES ASC
> Thx!
> Marc|||Thanks Adam,
That will help alot!!
Marc
"Adam Machanic" wrote:

> Since you haven't posted DDL, it's impossible to know which column(s) migh
t
> be causing the problem. But the error message says it all. If you have
> TEXT, NTEXT, or IMAGE columns in your result set, they can't be ordered,
> compared, or grouped. This means that your GROUP BY is probably the issue
.
> One workaround, if you don't mind some data truncation (if your data is ov
er
> 8000 characters) is to use the SUBSTRING function to truncate the LOB data
.
> So insead of:
> SELECT YourLOBCol
> FROM YourTable
> GROUP BY YourLobCol
> You could do:
> SELECT SUBSTRING(YourLobCol, 1, 8000) AS YourCol
> FROM YourTable
> GROUP BY SUBSTRING(YourLobCol, 1, 8000)
> There are some other workarounds, depending on what your actual business
> requirement is. Post DDL and sample data (please, keep the LOB data small
)
> if you need more assistance.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Marc" <Marc@.discussions.microsoft.com> wrote in message
> news:CEB1B459-2832-4766-950B-1872C53115F1@.microsoft.com...
> requires a
> the
>
>