MS - How About Some Answers?

Hey MS,

I realize that this a free forum, but given the number of people who have problems with SSRS configuration and the fact that there are virtually no solutions posted on MSDN, I would think that MS would be more responsive to these forum posts. The most recent post from someone who can't get SSRS working had 1,154 views, but no answers--similar to the other posts by those who can't get the product to work. There seem to be responses to the "easy" questions, like features and techniques.

Unlike the SQK2K version, this version has a GUI-based config tool. That should guarantee proper configuration, but it doesn't. The online knowledge base is not yet adequate to support installation and configuration. So I think that MS should be more responsive to post requesting configuration help.

Hi rlo,

Good post. I like your comments. RS configuration is a sore spot for both MS and for our customers. We have made and are continuing to make configuration better. The Configuration Tool in RS 2005 is a start, but not the panacea for configuration problems. Each version, we will definately work to make configuration easier. And sadly, there is no one solution to configuration problems.

In regards to getting answers for configuration problems via helper forums:

1. Clarify the problem in excrutiating detail. Little detail and most MS employees will move to the next post to help out.

2. Be polite. We have feelings too.

3. Bump the post if you do not get an answer within the first page.

The Reporting Services team takes great pride in helping customers. But do remember there are only a couple handfulls of us, while there are many thousands of you. Your help in responding to customers is as important as ours.

Moving rows to columns

I've seen this answered a number of times in the group, but now that I
actually need the answer I don't know where to look or what to put in
the search.

The question is this:

I have a query that produces these reults:

Col1 Col2
A B
A C
A D
B A
B C
B D

I would like take the above reults, manipulate them and get these:

Col1 Col2 COl3 Col4
A B C D
B A C D

Right now I've got a loop through a cursor, which is ok. It works,
but I'm worried about it because if I end up with a large table in the
future, the longer it will take to run the query with the curors.

Can someone help me please - point me to previous answers to this
question?

Thanks,
JenniferHi

I would search for crosstab!

Maybe a starter?

http://tinyurl.com/i9mt

John

"Jennifer" <jennifer1970@.hotmail.com> wrote in message
news:3358f49d.0310060601.1ca0ebf3@.posting.google.c om...
> I've seen this answered a number of times in the group, but now that I
> actually need the answer I don't know where to look or what to put in
> the search.
> The question is this:
> I have a query that produces these reults:
>
> Col1 Col2
> A B
> A C
> A D
> B A
> B C
> B D
>
> I would like take the above reults, manipulate them and get these:
> Col1 Col2 COl3 Col4
> A B C D
> B A C D
>
> Right now I've got a loop through a cursor, which is ok. It works,
> but I'm worried about it because if I end up with a large table in the
> future, the longer it will take to run the query with the curors.
> Can someone help me please - point me to previous answers to this
> question?
> Thanks,
> Jennifer

Moving Report Builder reports to new server

I have a development server setup with Report Builder that our users have been testing out. They have a number of reports that they have created on this dev server.

We now have our live environment all setup and I'd like to move their Report Builder reports to the new server for them so they don't have to recreate them.

Is this possible? If so, how?

Thanks.

The Report Builder reports are stored in the report catalog just like the Report Designer reports. There are several options available for moving report definitions ranging from manually exporting and uploading them one by one to handling this programatically. I would recommend you try the Jasper Smith's Report Scripter to automate the process. Remember to script and deploy not only the report definitions but the the data source and the model.