Order Date prompt descending doesn't work

Hi,

In the report model I'm defining attribute date as ValueSelection: dropdown and SortDirection: Descending.

In the report builder I define the field as a prompt.

When I execute the report the values in the prompt date are order ascending and not descending.

This occur all over my model, can't order date field as ascending.

Any idea?

Thanks,

Assaf

In the report builder: There is a button "Sort and Group". Did you set the "Sort by" property of the date? I think that has to be set in order to sort right.|||

Hi,

Thanks for your reply.

The "Sort by" sort the records on the report.

My problem is that the sort in the prompt itself is always stay ascesnding although in the .NET I set it to descending

Any Idea?

Assaf

sql

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 error witrh Report Builder

Hi
I am doing reports and UDMs from a DW in Oracle and it is great (some
doubt expressed in another post).
I tried Report Builder but the new model wizard comes back with the
error:
ORA 02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ
COMMITTED }
The data source file (.ds) has been configured with most of the
connections to Oracle available (e.g. .NET Providers Oracleclient Data
provider; Microsoft OLE DB Provider for ORacle etc.) with same error.
The strange thing is that I can create the .dsv with no problem, browse
the tables, refresh with no problems.
What I am doing wrong?
cheers
EnzoYou are not doing anything wrong. Oracle is not supported for the Report
Builder (note that it is supported for the Report Designer).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Enzo M" <emartoglio@.gmail.com> wrote in message
news:1141724038.842766.151540@.j33g2000cwa.googlegroups.com...
> Hi
> I am doing reports and UDMs from a DW in Oracle and it is great (some
> doubt expressed in another post).
> I tried Report Builder but the new model wizard comes back with the
> error:
> ORA 02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ
> COMMITTED }
> The data source file (.ds) has been configured with most of the
> connections to Oracle available (e.g. .NET Providers Oracleclient Data
> provider; Microsoft OLE DB Provider for ORacle etc.) with same error.
> The strange thing is that I can create the .dsv with no problem, browse
> the tables, refresh with no problems.
> What I am doing wrong?
> cheers
> Enzo
>|||Work-around for Report Builder:
1. Create linked server connection to Oracle database using the
OraOLEDB.Oracle provider(more up-to-date than Microsoft's).
2. Create a Data Source using the native SQL provider to the SQL Server
where you created in step 1.
3. Create a data source view; do not select objects.
4. Right-click in the DSV designer pane and create a New Named Query. Build
your query against the linked server (i.e. use 4-part names: select * from
linkedservername..schema.object). Repeat step 4 for each object you wish to
add to your model.
5. Add logical keys where applicable.
6. Build your model.
7. Deploy & build reports using Report Builder :-)
X