Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
 Posted - 2008-12-30 : 17:15:12
|
| I am creating a report where I have to read data from a Sybase DB. The query needed has to use a table joining with a derived table.When I'm creating a new dataset the query runs fine giving required resultset, but when I move to the layout tab I dont see any fields for the dataset.I read that derived tables were not supported in earlier versions of sybase, then why is it running while creating a new data set but failing when I want to use that dataset in the design?Has anyone faced such problem before, is there a work around? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-31 : 03:22:07
|
| have you tried refreshing the dataset in data tab and seen if it correctly taken fields in design tab? If it still doesnt work, use a temporary table, put the results of derived table in it and join to it rather than using derived table. |
 |
|
|
|
|
|
Reporting Services: Sybase derived table issue