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 |
|
smithicus
Starting Member
1 Post |
 Posted - 2009-07-10 : 16:36:35
|
| Hi there,I am in bit of a tight spot.. I am trying to sell Report Builder 2.0 as the best expert end user tool.. but the client has complex filter requirements which I fear are out of RS 2.0 league:The customer would need to be able to answer the following question using the Quesry Designer (example):- (All customers who have bought a car in 2006 for the first time)1 and (have bought a second car at least one year later.)2Using TSQL you would be able to answer the question. There is an dependancy between the year from result set 1 (2006).. and resultset 2 (at least one year later) which is 12 months from the buy date.So basicly resultset 2 is dependent on result 1Please, does anybody know how you would realize that in RS 2.0 using the User Interface (using the Group Filter func. etc)? Thanks in advance |
|
|
|
|
|
Report Builder 2.0: dependant resultsets