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 |
|
blas53
Starting Member
15 Posts |
 Posted - 2005-10-04 : 18:36:48
|
| Hello,I'm using reporting services and I have designed a report that extracts data from multiple datasets (in stored procedures). But I need that the report and all of its elements and data, repeats as many times as results in the query. To be clearer here is an example: the report shows all the data describing a position (job) and it uses multiple datasets to collect all the data. It receives a list of the positions to be included in the report. I use this list of ID's to bring all the data related to each position and I need the report to be repeated for each of the positions in the ID list. Basically to display all the data of each of the positions requested, for example all data for the position marketing, sales, CIO, etc. in different pages, tables or whatever can be used to separate them.I hope I have been clear enough.Thanks a lot for your collaboration. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-04 : 18:54:01
|
| Could you provide a data example?Tara |
 |
|
|
blas53
Starting Member
15 Posts |
Posted - 2005-10-05 : 09:51:57
|
| Hello,What I'm trying to do is this:For marketing job the data includes:Job name, bussines, dependency, boss job, localization, review date, job objective, job functions, job responsabilities, job requisites, relationships, etc.The report is created for only one job. There is a parameter that receives the list of ID's of job to include in the report.The idea is to generate as many of these reports as job ID's in the parameter. So the above data would be repeated for each job.I hope this helps. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-07 : 17:52:29
|
| How about doing a page break on every change of the ID, and making other elements headers or footers that repeat on every page?---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
|
|
Reporting serices doubt