Migrating from Crystal Reports Charts using TopN and "Other" to Reporting Services

I am currently migrating several Crystal Reports that have charts. The chart series is set to use the TopN values in a count, and combine the rest of the series into one series titled "Other". I see how to filter the chart using TopN, however I need to still show the rest of the data grouped as "Other". I think the solution I need is to create a group expression that uses some sort of IIF function to create the "Other" group, but I haven't found a function that I can use to get the results I need. Any ideas?

Scott

I found the answer to my question in another forum.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1055659&SiteID=1

I used option 1.

Migrating from Crystal Reports Charts using TopN and "Other" to Reporting Services

I am currently migrating several Crystal Reports that have charts. The chart series is set to use the TopN values in a count, and combine the rest of the series into one series titled "Other". I see how to filter the chart using TopN, however I need to still show the rest of the data grouped as "Other". I think the solution I need is to create a group expression that uses some sort of IIF function to create the "Other" group, but I haven't found a function that I can use to get the results I need. Any ideas?

Scott

I found the answer to my question in another forum.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1055659&SiteID=1

I used option 1.

Middleware to access Sybase databases?

Does anyone use some kind of middleware or linked server
configuration to combine their MSSQL Server data with data
from other relational databases such as Sybase? Thanks
for any help.
SondraHi,
Multiple options , You can either use,
1. Linked server (create a linked server from SQL server to connect to
Sybase or any RDBMS )
2. DTS
3. BCP IN (Sybase), Export ( DB2) , SQLLDR (Oracle) to export data and use
BCP IN in sql server to load
Thanks
Hari
MCDBA
"Sondra" <anonymous@.discussions.microsoft.com> wrote in message
news:5e3801c3e5b3$fc362760$a401280a@.phx.gbl...
> Does anyone use some kind of middleware or linked server
> configuration to combine their MSSQL Server data with data
> from other relational databases such as Sybase? Thanks
> for any help.
> Sondra

Middleware to access Sybase databases?

Does anyone use some kind of middleware or linked server
configuration to combine their MSSQL Server data with data
from other relational databases such as Sybase? Thanks
for any help.
SondraHi,
Multiple options , You can either use,
1. Linked server (create a linked server from SQL server to connect to
Sybase or any RDBMS )
2. DTS
3. BCP IN (Sybase), Export ( DB2) , SQLLDR (Oracle) to export data and use
BCP IN in sql server to load
Thanks
Hari
MCDBA
"Sondra" <anonymous@.discussions.microsoft.com> wrote in message
news:5e3801c3e5b3$fc362760$a401280a@.phx.gbl...

quote:

---

> Does anyone use some kind of middleware or linked server
> configuration to combine their MSSQL Server data with data
> from other relational databases such as Sybase? Thanks
> for any help.
> Sondra

---