|
|
You're in the
sql server reporting services
group:Wishlist for Reporting Services
sql server reporting services:
Here is a consolidated list of features that would make this a GREAT product:
Top most requirement: Webforms for Parameter Menu - Ability to Specify the location of a parameter box on the menu bar - Explicitly define which parameters depend on which parameters. - Listbox / ComboBox/ Radiobuttons / Checkboxes - Tree control for parameters - Multi-Select Parameters - Date picker button so users select a date from a calendar Other very important requirements: 1. Functionality to freeze/float headers in reports 2. Export directly to PowerPoint and Export to word 3. Ability to export to Excel, and utilize formulas/charts within excel 4. Hide/show items based on render format (say hide in PDF but show in HTML) 5. Zero footprint report creation, (Maybe Active Views) 6. Expression to select Dataset in a Table/Matrix Expression to select Subreport in a Main report 8. Datasets based on datasets 9. Using macros 10. More advanced charting (Particularly Gauge) 11. Integrated BI portal/dashboard within the tool
Comments line.
-- Brian Welcker Group Program Manager Microsoft SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Harry" <harshwardhan@mailcity.com> wrote in message Under consideration for future release.news:e48fb32a.0411171712.b10ef2a@posting.google.com... > Here is a consolidated list of features that would make this a GREAT > product: > > > Top most requirement: > > Webforms for Parameter Menu > > - Ability to Specify the location of a parameter box on the menu bar [quoted text, click to view] > - Explicitly define which parameters depend on which parameters. Would like to understand this scenario. Are we guessing wrong?[quoted text, click to view] > - Listbox / ComboBox/ Radiobuttons / Checkboxes Under consideration for future release. [quoted text, click to view] > - Tree control for parameters Under consideration for future release. [quoted text, click to view] > - Multi-Select Parameters Planned for SQL 2005 version.[quoted text, click to view] > - Date picker button so users select a date from a calendar Planned for SQL 2005 version.[quoted text, click to view] > > > > Other very important requirements: > > 1. Functionality to freeze/float headers in reports Planned for SQL 2005 version. [quoted text, click to view] > > 2. Export directly to PowerPoint and Export to word Under consideration for future release. [quoted text, click to view] > 3. Ability to export to Excel, and utilize formulas/charts within Under consideration for future release.> excel [quoted text, click to view] > 4. Hide/show items based on render format (say hide in PDF but show > in HTML) Under consideration for future release. [quoted text, click to view] > 5. Zero footprint report creation, (Maybe Active Views) Hopefully, Report Builder (new name for ActiveViews) will meet your needs. [quoted text, click to view] > > 6. Expression to select Dataset in a Table/Matrix Under consideration for future release. [quoted text, click to view] > Expression to select Subreport in a Main report Under consideration for future release.[quoted text, click to view] > 8. Datasets based on datasets Don't quite understand this one. Union? Join?[quoted text, click to view] > Report Designer macros? Excel macros in rendering?> 9. Using macros [quoted text, click to view] > 3rd parties can do this in SQL 2005 version.> 10. More advanced charting (Particularly Gauge) [quoted text, click to view] > No plans here. Will improve SharePoint integration.> 11. Integrated BI portal/dashboard within the tool [quoted text, click to view] > Possible today with workaround. Explicit support is on the list for a future > 12. Event based capability to email a report release.
The "Datasets based on datasets" request sounds like something I'm looking
for. What I'd like to see is the ability to have better master-detail support within RS. For example, if I'm constructing a master-detail report of customers, their orders, and details about each order, I would likely have three datasets in RS. Unfortunately, however, RS doesn't know how these datasets are related (RS datasets seem more analagous to .Net DataTables). For example, if I create a list of customers and then create a table of orders inside that list, RS doesn't automatically filter the orders to just those related to that customer. The master-detail interface I'd like to see is similar to how .Net datasets and relationships work with WinForms binding. I can set up a grid and bind it to one DataTable in the DataSet, and then I can bind another grid to a foreign key relationship from the master table to a detail table. This automatically filters the list of detail items to just those relating to the selected master record. I'm hoping for this kind of support with the ability to run reports off .Net datasets in the 2005 rev. An additional high priority item for me is the ability to output rich text formatting (bold, italic, underline) within a single text box. Jeff Davis [quoted text, click to view] "Brian Welcker [MSFT]" <bwelcker@online.microsoft.com> wrote in message news:uw5S37UzEHA.1292@TK2MSFTNGP10.phx.gbl... > Comments line. > > -- > Brian Welcker > Group Program Manager > Microsoft SQL Server Reporting Services > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > "Harry" <harshwardhan@mailcity.com> wrote in message > news:e48fb32a.0411171712.b10ef2a@posting.google.com... >> Here is a consolidated list of features that would make this a GREAT >> product: >> >> >> Top most requirement: >> >> Webforms for Parameter Menu >> >> - Ability to Specify the location of a parameter box on the menu bar > Under consideration for future release. > >> - Explicitly define which parameters depend on which parameters. > Would like to understand this scenario. Are we guessing wrong? > >> - Listbox / ComboBox/ Radiobuttons / Checkboxes > > Under consideration for future release. > >> - Tree control for parameters > > Under consideration for future release. > >> - Multi-Select Parameters > Planned for SQL 2005 version. > >> - Date picker button so users select a date from a calendar > Planned for SQL 2005 version. > >> >> >> >> Other very important requirements: >> >> 1. Functionality to freeze/float headers in reports > > Planned for SQL 2005 version. > >> >> 2. Export directly to PowerPoint and Export to word > > Under consideration for future release. > >> 3. Ability to export to Excel, and utilize formulas/charts within >> excel > Under consideration for future release. > >> 4. Hide/show items based on render format (say hide in PDF but show >> in HTML) > > Under consideration for future release. > >> 5. Zero footprint report creation, (Maybe Active Views) > > Hopefully, Report Builder (new name for ActiveViews) will meet your needs. > >> >> 6. Expression to select Dataset in a Table/Matrix > > Under consideration for future release. > >> Expression to select Subreport in a Main report > Under consideration for future release. > >> 8. Datasets based on datasets > Don't quite understand this one. Union? Join? > >> >> 9. Using macros > Report Designer macros? Excel macros in rendering? > >> >> 10. More advanced charting (Particularly Gauge) > 3rd parties can do this in SQL 2005 version. > >> >> 11. Integrated BI portal/dashboard within the tool > No plans here. Will improve SharePoint integration. > >> >> 12. Event based capability to email a report > Possible today with workaround. Explicit support is on the list for a > future release. > >
Brian,
Thanks for the reply. Here is an explaination: [quoted text, click to view] > Explicitly define which parameters depend on which parameters. Would like to understand this scenario. Are we guessing wrong?a. If I create TWO sets of cascading parameters - where one set cascades independently of the other - changing a parameter from one set should not affect the parameters from the other set. b. Currently - all "expression based" parameters are assumed dependent. c. The best way to resolve this is - by using the "Parameter Map" as the basis for defining the dependency. If A PARAMETER based on a dataset is based on a SET of parameters - it should only be refreshed if ONE of the of parameters in the SET are refreshed. Otherwise - it should NOT be refreshed. [quoted text, click to view] > 8 Datasets based on datasets Don't quite understand this one. Union? Join?An ability to create TWO datasets, obtain the results for both and then be able to create a DATASOURCE on top of those - and create yet another data set. I think this can go a long way... [quoted text, click to view] > 9. Using macros I was referring to : Report Designer macros - to facililate rapid
Datasets of Datasets are easy. I do them all the time. Build an SP and do
the join on the server side. Workd great and will always be faster than two independent sets join later. [quoted text, click to view] "Harry" wrote:
> Brian, > > Thanks for the reply. Here is an explaination: > > > > Explicitly define which parameters depend on which parameters. > Would like to understand this scenario. Are we guessing wrong? > > > a. If I create TWO sets of cascading parameters - where one set > cascades independently of the other - changing a parameter from one > set should not affect the parameters from the other set. > > b. Currently - all "expression based" parameters are assumed > dependent. > > c. The best way to resolve this is - by using the "Parameter Map" as > the basis for defining the dependency. > > If A PARAMETER based on a dataset is based on a SET of parameters - > it should only be refreshed if ONE of the of parameters in the SET are > refreshed. > Otherwise - it should NOT be refreshed. > > > > 8 Datasets based on datasets > Don't quite understand this one. Union? Join? > > > An ability to create TWO datasets, obtain the results for both and > then be able to create a DATASOURCE on top of those - and create yet > another data set. > I think this can go a long way... > > > > 9. Using macros > > I was referring to : Report Designer macros - to facililate rapid > development.
[quoted text, click to view]
harshwardhan@mailcity.com (Harry) wrote in message news:<e48fb32a.0411171712.b10ef2a@posting.google.com>... <snip>> Here is a consolidated list of features that would make this a GREAT product: > <snip> > > 2. Export directly to PowerPoint and Export to word > 3. Ability to export to Excel, and utilize formulas/charts within excel Hi Harry... you can do Word and Excel now with SoftArtisans OfficeWriter: http://officewriter.softartisans.com/officewriter-250.aspx Best,
Hi,
Just wondering if MS Reporting Services or Report Builder will have the ability to create alerts (just like in Crystal Reports) based on the data. If alert condition is true then send email alert, or execute stored procedure. Also, it would be nice if a column heading (table header entity) or field entity can have the ability include a text box hint with value of another field name. So lets say I have a field name called "report name", I would like give my end user the ability to go over the report's name and display a text box hint with the value of "report description". Thanks Roman
EXPORT REPORT TO ACCESS (wtf, you have powerpoint, word, excel-- what about
Access??) SMARTER INSTALLER - dumb it down 10fold; make it more customizeable. Make it _WORK_ LESS LICENSING RESTRICTIONS - WTF DO YOU MEAN I CAN'T RUN RS STANDARD ON A DEVELOEPRS' EDITION OF SQL SERVER [quoted text, click to view] "Brian Welcker [MSFT]" <bwelcker@online.microsoft.com> wrote in message news:uw5S37UzEHA.1292@TK2MSFTNGP10.phx.gbl... > Comments line. > > -- > Brian Welcker > Group Program Manager > Microsoft SQL Server Reporting Services > > This posting is provided "AS IS" with no warranties, and confers no rights. > > "Harry" <harshwardhan@mailcity.com> wrote in message > news:e48fb32a.0411171712.b10ef2a@posting.google.com... > > Here is a consolidated list of features that would make this a GREAT > > product: > > > > > > Top most requirement: > > > > Webforms for Parameter Menu > > > > - Ability to Specify the location of a parameter box on the menu bar > Under consideration for future release. > > > - Explicitly define which parameters depend on which parameters. > Would like to understand this scenario. Are we guessing wrong? > > > - Listbox / ComboBox/ Radiobuttons / Checkboxes > > Under consideration for future release. > > > - Tree control for parameters > > Under consideration for future release. > > > - Multi-Select Parameters > Planned for SQL 2005 version. > > > - Date picker button so users select a date from a calendar > Planned for SQL 2005 version. > > > > > > > > > Other very important requirements: > > > > 1. Functionality to freeze/float headers in reports > > Planned for SQL 2005 version. > > > > > 2. Export directly to PowerPoint and Export to word > > Under consideration for future release. > > > 3. Ability to export to Excel, and utilize formulas/charts within > > excel > Under consideration for future release. > > > 4. Hide/show items based on render format (say hide in PDF but show > > in HTML) > > Under consideration for future release. > > > 5. Zero footprint report creation, (Maybe Active Views) > > Hopefully, Report Builder (new name for ActiveViews) will meet your needs. > > > > > 6. Expression to select Dataset in a Table/Matrix > > Under consideration for future release. > > > Expression to select Subreport in a Main report > Under consideration for future release. > > > 8. Datasets based on datasets > Don't quite understand this one. Union? Join? > > > > > 9. Using macros > Report Designer macros? Excel macros in rendering? > > > > > 10. More advanced charting (Particularly Gauge) > 3rd parties can do this in SQL 2005 version. > > > > > 11. Integrated BI portal/dashboard within the tool > No plans here. Will improve SharePoint integration. > > > > > 12. Event based capability to email a report > Possible today with workaround. Explicit support is on the list for a future > release. > >
RS ACTIVEX CONTROL FOR ALLOWING CONSUMPTION OF RS DATA IN OTHER LEGACY (VB)
APPS [quoted text, click to view] "Brian Welcker [MSFT]" <bwelcker@online.microsoft.com> wrote in message news:uw5S37UzEHA.1292@TK2MSFTNGP10.phx.gbl... > Comments line. > > -- > Brian Welcker > Group Program Manager > Microsoft SQL Server Reporting Services > > This posting is provided "AS IS" with no warranties, and confers no rights. > > "Harry" <harshwardhan@mailcity.com> wrote in message > news:e48fb32a.0411171712.b10ef2a@posting.google.com... > > Here is a consolidated list of features that would make this a GREAT > > product: > > > > > > Top most requirement: > > > > Webforms for Parameter Menu > > > > - Ability to Specify the location of a parameter box on the menu bar > Under consideration for future release. > > > - Explicitly define which parameters depend on which parameters. > Would like to understand this scenario. Are we guessing wrong? > > > - Listbox / ComboBox/ Radiobuttons / Checkboxes > > Under consideration for future release. > > > - Tree control for parameters > > Under consideration for future release. > > > - Multi-Select Parameters > Planned for SQL 2005 version. > > > - Date picker button so users select a date from a calendar > Planned for SQL 2005 version. > > > > > > > > > Other very important requirements: > > > > 1. Functionality to freeze/float headers in reports > > Planned for SQL 2005 version. > > > > > 2. Export directly to PowerPoint and Export to word > > Under consideration for future release. > > > 3. Ability to export to Excel, and utilize formulas/charts within > > excel > Under consideration for future release. > > > 4. Hide/show items based on render format (say hide in PDF but show > > in HTML) > > Under consideration for future release. > > > 5. Zero footprint report creation, (Maybe Active Views) > > Hopefully, Report Builder (new name for ActiveViews) will meet your needs. > > > > > 6. Expression to select Dataset in a Table/Matrix > > Under consideration for future release. > > > Expression to select Subreport in a Main report > Under consideration for future release. > > > 8. Datasets based on datasets > Don't quite understand this one. Union? Join? > > > > > 9. Using macros > Report Designer macros? Excel macros in rendering? > > > > > 10. More advanced charting (Particularly Gauge) > 3rd parties can do this in SQL 2005 version. > > > > > 11. Integrated BI portal/dashboard within the tool > No plans here. Will improve SharePoint integration. > > > > > 12. Event based capability to email a report > Possible today with workaround. Explicit support is on the list for a future > release. > >
You mean a tooltip? You can specify this on any textbox.
-- Brian Welcker Group Program Manager Microsoft SQL Server This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Roman K" <RomanK@discussions.microsoft.com> wrote in message news:05A3D51F-A16B-4F7D-820D-2B3AC877D857@microsoft.com... > Hi, > > Just wondering if MS Reporting Services or Report Builder will have the > ability to create alerts (just like in Crystal Reports) based on the data. > If > alert condition is true then send email alert, or execute stored > procedure. > > Also, it would be nice if a column heading (table header entity) or field > entity can have the ability include a text box hint with value of another > field name. So lets say I have a field name called "report name", I would > like give my end user the ability to go over the report's name and display > a > text box hint with the value of "report description". > > Thanks > > Roman > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |