Order Group in specified order

Hi all,
We have recently migrated from Crystal Reports to SSRS. We are converting
all our company reports from one format to another. Some of our reports have
groupings in a specified order. When you sort order in Crystal you can select
"Specified Order" and then pick the names of the groups and place them in a
specified order to appear on the report, as opposed to ascending alphabetical
order for example.
How can I specify "Specified Order" when creating a Reporting Services report?
Thanks
JHI have never used Crystal Reports. But I think I understand what you
are asking. I had a similar issue where I had to explicity specify the
order of matrix columns. Neither RS nor my SQL SELECT ORDER BY did the
trick because I could do only Ascending/Descending or ASC/DESC
respectively. I would like to believe RS has some way to control
explicit order, but I sure cannot find it.
I solved my problem by doing the following
1) returned a dummy INT column from my SELECT statement. Made sure rows
in the dataset returned appropriate value for this column based on the
column data.
2) Changed the Column group in my matrix to Sort Ascending on THIS INT
column instead of using a data field.
Kludgy perhaps, but at the moment I could care less.
HTH.
Best.
JH wrote:
> Hi all,
> We have recently migrated from Crystal Reports to SSRS. We are converting
> all our company reports from one format to another. Some of our reports have
> groupings in a specified order. When you sort order in Crystal you can select
> "Specified Order" and then pick the names of the groups and place them in a
> specified order to appear on the report, as opposed to ascending alphabetical
> order for example.
> How can I specify "Specified Order" when creating a Reporting Services report?
> Thanks
> JH

Oracle support and Report Builder

Can anyone confirm whether Oracle support for Report Builder will be in SSRS 2005/SP1?

I think a long time (6-7 months) ago this was kicked around as a possibility, but as far as I know there are currently no plans to include direct access to Oracle via Report Builder in SP1.

You could do this by using a UDM/Cube in SSAS (which points to Oracle) or linking Oracle tables into SQL, though...

|||

|||

I have been trying to create a new report builder model. I would like the data source to be Oracle 10g, I'm not having any joy. Were you able to get it working.

|||Do not waste your time. It will not work against Oracle. A huge disappointment.|||

Oracle support for Report Builder didn't make it RS 2005 SP1. We are working on it, and hope to be able to announce more details soon.

Stay tuned.

Thanks

Tudor Trufinescu

|||We really need this feature Microsoft.

Oracle support and Report Builder

Can anyone confirm whether Oracle support for Report Builder will be in SSRS 2005/SP1?

I think a long time (6-7 months) ago this was kicked around as a possibility, but as far as I know there are currently no plans to include direct access to Oracle via Report Builder in SP1.

You could do this by using a UDM/Cube in SSAS (which points to Oracle) or linking Oracle tables into SQL, though...

|||

|||

I have been trying to create a new report builder model. I would like the data source to be Oracle 10g, I'm not having any joy. Were you able to get it working.

|||Do not waste your time. It will not work against Oracle. A huge disappointment.|||

Oracle support for Report Builder didn't make it RS 2005 SP1. We are working on it, and hope to be able to announce more details soon.

Stay tuned.

Thanks

Tudor Trufinescu

|||We really need this feature Microsoft.

Oracle support and Report Builder

Can anyone confirm whether Oracle support for Report Builder will be in SSRS 2005/SP1?

I think a long time (6-7 months) ago this was kicked around as a possibility, but as far as I know there are currently no plans to include direct access to Oracle via Report Builder in SP1.

You could do this by using a UDM/Cube in SSAS (which points to Oracle) or linking Oracle tables into SQL, though...

|||

|||

I have been trying to create a new report builder model. I would like the data source to be Oracle 10g, I'm not having any joy. Were you able to get it working.

|||Do not waste your time. It will not work against Oracle. A huge disappointment.|||

Oracle support for Report Builder didn't make it RS 2005 SP1. We are working on it, and hope to be able to announce more details soon.

Stay tuned.

Thanks

Tudor Trufinescu

|||We really need this feature Microsoft.

oracle support - Report Model

If my understanding is correct, Oracle is not yet supported as a data source
for report models in SSRS 2005 (and thus not available for report builder).
Is there a timeframe estimate to when this might be available?I would also like to know. Also if there are any APIs to develop one. Can we
develop own application which can use Oracle database to build report model?
Thank you - Ashok
"chicagoclone" wrote:
> If my understanding is correct, Oracle is not yet supported as a data source
> for report models in SSRS 2005 (and thus not available for report builder).
> Is there a timeframe estimate to when this might be available?|||I burned a MSDN Developer Incident on this one. Basically I was able to ceate
a Report Model by using a Linked Server and creating a view on the linked
server. From there I used the Linked View in the report Modeler, it is a wee
it slow (30-45 seconds for 18,000 rows over a T-1) however until they support
Oracle it's how I am going to apporach it. Hope this helps...
"Ashok" wrote:
> I would also like to know. Also if there are any APIs to develop one. Can we
> develop own application which can use Oracle database to build report model?
> Thank you - Ashok
> "chicagoclone" wrote:
> > If my understanding is correct, Oracle is not yet supported as a data source
> > for report models in SSRS 2005 (and thus not available for report builder).
> > Is there a timeframe estimate to when this might be available?|||Oracle support is scheduled to be added in SP2.
"chicagoclone" wrote:
> If my understanding is correct, Oracle is not yet supported as a data source
> for report models in SSRS 2005 (and thus not available for report builder).
> Is there a timeframe estimate to when this might be available?|||Thank you Bob! This is great news.
"Bob Meyers - MSFT" wrote:
> Oracle support is scheduled to be added in SP2.
> "chicagoclone" wrote:
> > If my understanding is correct, Oracle is not yet supported as a data source
> > for report models in SSRS 2005 (and thus not available for report builder).
> > Is there a timeframe estimate to when this might be available?