I am working with CTP release on SQL Server 2005 Reporting Service using SQL Server 2000 as data source in Report Model Project.
I was working with RS2000 earlier, since we are interested in "End user tool" for reporting building, I started working on RS2005.
I have created a model and trying build a Report using Report builder. I have more than 75 fields to select on single report.
My questions are,
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?
2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".
3. I am using "Report Builder" using keyboard and without mouse which makes it very difficult to work. Any shortcuts will be available for Report Manager (e.g. Menu Items: New Folder, New Data Source, Upload File, Report Builder etc.) or Report Builder (Explorer, Fields, Run Report, Design Report, Filter, selecting fields etc.)?
4. When will RS2005 will support export to Microsoft Word format?
5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?
6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.
Above queries are influenced by my client who is using our customised tool as a Report Engine which is tightly coupled with development team and often changing requirements.Comments inline:
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?
For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).
2. How to change print orientation of my report in to "landscape"? All of my reports will be printed on "landscape".
In Report Builder, it is in the page properties dialog (not sure if that was fully implemented in CTP June). In Report Designer, make your page width greater than your page height.
3. I am using "Report Builder" using keyboard and without mouse which makes it very difficult to work. Any shortcuts will be available for Report Manager (e.g. Menu Items: New Folder, New Data Source, Upload File, Report Builder etc.) or Report Builder (Explorer, Fields, Run Report, Design Report, Filter, selecting fields etc.)?
Shortcuts will be added for the released product.
4. When will RS2005 will support export to Microsoft Word format?
Unfortunately, we were not able to get it into RS 2005. This is high on the list for a future release.
5. I assume that database structure and Report Model are two separate things, and I can create my own relationship between existing entities in report Model. Is this correct?
Sort of. The relationship has to be defined in the DSV so that we can generate the SQL. You never have to modify the database schema itself.
6. I assume that RS 2005 Report Manager is accessible via web without any upgrades of Internet Explorer etc. is this correct? At present, I am not able to see all contents of Report Manager.
Report Manager works with IE 5.5 and later. Not sure what you are running into.|||
1. By using Report builder, I am selecting (by dragging fields) on report. While dragging first field, Report Builder > explorer is showing only directly dependant entities and its attributes. Here, I am not able to select attributes from Report Builder > explorer which are not dependant on other entities because explorer is not showing other entities. While dragging first attributes from one entity, explorer is not showing entities which are not depend on my first selected entities. How can I get other attributes available which is not relevant to my first selected attributes?
-->>For your report to make sense, you have to have a path between the entities in your report. You should be able to navigate between entities by clicking on them. You can also use the find button (not sure how well that was working in CTP June).
This couldn't be more wrong , if you have 2 fact table sales and customer, and dimension time and product , you can't do a report that show sales , customers that make that purchases by product and time .
This is a very basic feature that report builder can't do......
Plase give us a beter tool
No comments:
Post a Comment