Feature Request: 2005 Beta 2

Greetings,
I have a feature request for the Enterprise Studio.
We have about 500+ stored procedures in our CRM application and opening up
Enterprise Manager (in 2000) or Enterprise Studio (2005) I have to look at a
huge list of stored procedures and find the one I'm specifically looking
for. Granted, in 2005 there is a "filter" it is rather unintuitive.
I'd like to request the abililty to add my own "folder" to the list where I
can create categories to group my stored procedures. for example, I can
create a "Invoices" group where all my invoice related SP's go, and a
"Policies" group where all my policies related SP's will go. In addition to
this, we have more tables than SPs, so we should be able to group any
object, Table, SP, View, etc.
Not sure if you've considered this already but the filtering isn't as
intuitive. It requires me to have to constantly enter in new filters to
filter the list before I can browse around. I'd like to browse directly to
what I'm looking for.
Thanks,
Shawn
Hi Shawn,
Have you considered using Schemas for this? (Introduced in SQL Server 2005
also).
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Shawn B." <leabre@.html.com> wrote in message
news:OLcOBc6zEHA.1564@.TK2MSFTNGP09.phx.gbl...
> Greetings,
> I have a feature request for the Enterprise Studio.
> We have about 500+ stored procedures in our CRM application and opening up
> Enterprise Manager (in 2000) or Enterprise Studio (2005) I have to look at
> a
> huge list of stored procedures and find the one I'm specifically looking
> for. Granted, in 2005 there is a "filter" it is rather unintuitive.
> I'd like to request the abililty to add my own "folder" to the list where
> I
> can create categories to group my stored procedures. for example, I can
> create a "Invoices" group where all my invoice related SP's go, and a
> "Policies" group where all my policies related SP's will go. In addition
> to
> this, we have more tables than SPs, so we should be able to group any
> object, Table, SP, View, etc.
> Not sure if you've considered this already but the filtering isn't as
> intuitive. It requires me to have to constantly enter in new filters to
> filter the list before I can browse around. I'd like to browse directly
> to
> what I'm looking for.
>
> Thanks,
> Shawn
>
|||What are schemas in this context? after a cursory google and help topics
lookup, I have no clue what they can do for me.
Thanks,
Shawn
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:e8NiNJ8zEHA.2528@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Hi Shawn,
> Have you considered using Schemas for this? (Introduced in SQL Server 2005
> also).
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Shawn B." <leabre@.html.com> wrote in message
> news:OLcOBc6zEHA.1564@.TK2MSFTNGP09.phx.gbl...
up[vbcol=seagreen]
at[vbcol=seagreen]
where[vbcol=seagreen]
addition
>
|||I believe this has been suggested before but to make sure please send the
details of your request to sqlwish@.microsoft.com
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Shawn B." <leabre@.html.com> wrote in message
news:OLcOBc6zEHA.1564@.TK2MSFTNGP09.phx.gbl...
> Greetings,
> I have a feature request for the Enterprise Studio.
> We have about 500+ stored procedures in our CRM application and opening up
> Enterprise Manager (in 2000) or Enterprise Studio (2005) I have to look at
> a
> huge list of stored procedures and find the one I'm specifically looking
> for. Granted, in 2005 there is a "filter" it is rather unintuitive.
> I'd like to request the abililty to add my own "folder" to the list where
> I
> can create categories to group my stored procedures. for example, I can
> create a "Invoices" group where all my invoice related SP's go, and a
> "Policies" group where all my policies related SP's will go. In addition
> to
> this, we have more tables than SPs, so we should be able to group any
> object, Table, SP, View, etc.
> Not sure if you've considered this already but the filtering isn't as
> intuitive. It requires me to have to constantly enter in new filters to
> filter the list before I can browse around. I'd like to browse directly
> to
> what I'm looking for.
>
> Thanks,
> Shawn
>
|||Hi Shawn,
Take a look at the Northwind sample database in SQL Server 2005 Beta if you
have access to it from the MSDN site. Whereas Northwind's tables, procs,
etc. before were just one big list, now there are separate schemas for
HumanResources, etc. with only those objects relevant to that part of the
app in them.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Shawn B." <leabre@.html.com> wrote in message
news:OWVSG5A0EHA.1192@.tk2msftngp13.phx.gbl...
> What are schemas in this context? after a cursory google and help topics
> lookup, I have no clue what they can do for me.
>
> Thanks,
> Shawn
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:e8NiNJ8zEHA.2528@.TK2MSFTNGP10.phx.gbl...
> up
> at
> where
> addition
>
|||Sorry, brain explosion - meant to point you to the Adventureworks sample,
not Northwind.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:OLy2UoU0EHA.3244@.TK2MSFTNGP10.phx.gbl...
> Hi Shawn,
> Take a look at the Northwind sample database in SQL Server 2005 Beta if
> you have access to it from the MSDN site. Whereas Northwind's tables,
> procs, etc. before were just one big list, now there are separate schemas
> for HumanResources, etc. with only those objects relevant to that part of
> the app in them.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Shawn B." <leabre@.html.com> wrote in message
> news:OWVSG5A0EHA.1192@.tk2msftngp13.phx.gbl...
>

Fails to Render

RS works fine locally.
When accessed from the internet, I can see the report folders; I can select
a report; it processes "Opening...."; then (briefly) "Finding site xxxx";
then nothing. No circular icon that says "Processing Report", just a big
blank page.
I have tried it as Administrator, and from both an XP/IE and Windows 2003
Server box.
RS is running on IIS 6.0, Windows 2003.
I don't know what SP is on RS. How do I find that out?
Any suggestions will be appreciated.On Fri, 22 Apr 2005 10:56:04 -0700, "JohnWoll"
<JohnWoll@.discussions.microsoft.com> wrote:
>RS works fine locally.
>When accessed from the internet, I can see the report folders; I can select
>a report; it processes "Opening...."; then (briefly) "Finding site xxxx";
>then nothing. No circular icon that says "Processing Report", just a big
>blank page.
>I have tried it as Administrator, and from both an XP/IE and Windows 2003
>Server box.
>RS is running on IIS 6.0, Windows 2003.
>I don't know what SP is on RS. How do I find that out?
>Any suggestions will be appreciated.
Version info:
http://www.tfosorcim.org/archives/000351.html
Andrew Watt
MVP - InfoPath|||Thank you, Andrew, for the help in determining the SP. I am running the
latest release (8.00.878.00).
I still have the original problem: The report does not render, nor is there
any error message. The report renders fine when inside the intranet.
Please advise the best way to proceed to resolve this. I have several
clients who would like to use Reporting Services - but first I have to show
that it works!
"JohnWoll" wrote:
> RS works fine locally.
> When accessed from the internet, I can see the report folders; I can select
> a report; it processes "Opening...."; then (briefly) "Finding site xxxx";
> then nothing. No circular icon that says "Processing Report", just a big
> blank page.
> I have tried it as Administrator, and from both an XP/IE and Windows 2003
> Server box.
> RS is running on IIS 6.0, Windows 2003.
> I don't know what SP is on RS. How do I find that out?
> Any suggestions will be appreciated.|||Are you using fully qualified domain names or NetBIOS names? Can you browse
to http://server/reportserver instead of using the Report Manager UI?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> Thank you, Andrew, for the help in determining the SP. I am running the
> latest release (8.00.878.00).
> I still have the original problem: The report does not render, nor is
> there
> any error message. The report renders fine when inside the intranet.
> Please advise the best way to proceed to resolve this. I have several
> clients who would like to use Reporting Services - but first I have to
> show
> that it works!
> "JohnWoll" wrote:
>> RS works fine locally.
>> When accessed from the internet, I can see the report folders; I can
>> select
>> a report; it processes "Opening...."; then (briefly) "Finding site
>> xxxx";
>> then nothing. No circular icon that says "Processing Report", just a big
>> blank page.
>> I have tried it as Administrator, and from both an XP/IE and Windows 2003
>> Server box.
>> RS is running on IIS 6.0, Windows 2003.
>> I don't know what SP is on RS. How do I find that out?
>> Any suggestions will be appreciated.|||Thanks for the response, Brian!
I am using fully qualified domain names.
I tried going straight to reportserver, instead of using Report Manager UI.
When I do, the report renders normally: I see the icon and message, and it
renders. I greatly appreciate the suggestion, and shame on me for not
thinking of trying that.
The question remains, why Report Manager does not render. Any suggestions?
"Brian Welcker [MSFT]" wrote:
> Are you using fully qualified domain names or NetBIOS names? Can you browse
> to http://server/reportserver instead of using the Report Manager UI?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> > Thank you, Andrew, for the help in determining the SP. I am running the
> > latest release (8.00.878.00).
> >
> > I still have the original problem: The report does not render, nor is
> > there
> > any error message. The report renders fine when inside the intranet.
> >
> > Please advise the best way to proceed to resolve this. I have several
> > clients who would like to use Reporting Services - but first I have to
> > show
> > that it works!
> >
> > "JohnWoll" wrote:
> >
> >> RS works fine locally.
> >> When accessed from the internet, I can see the report folders; I can
> >> select
> >> a report; it processes "Opening...."; then (briefly) "Finding site
> >> xxxx";
> >> then nothing. No circular icon that says "Processing Report", just a big
> >> blank page.
> >>
> >> I have tried it as Administrator, and from both an XP/IE and Windows 2003
> >> Server box.
> >>
> >> RS is running on IIS 6.0, Windows 2003.
> >> I don't know what SP is on RS. How do I find that out?
> >> Any suggestions will be appreciated.
>
>|||Most likely, you need to set the ReportServerExternalUrl property. This is
described in the docs somewhere but I don't have the link handy.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> Thanks for the response, Brian!
> I am using fully qualified domain names.
> I tried going straight to reportserver, instead of using Report Manager
> UI.
> When I do, the report renders normally: I see the icon and message, and it
> renders. I greatly appreciate the suggestion, and shame on me for not
> thinking of trying that.
> The question remains, why Report Manager does not render. Any suggestions?
> "Brian Welcker [MSFT]" wrote:
>> Are you using fully qualified domain names or NetBIOS names? Can you
>> browse
>> to http://server/reportserver instead of using the Report Manager UI?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
>> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
>> > Thank you, Andrew, for the help in determining the SP. I am running the
>> > latest release (8.00.878.00).
>> >
>> > I still have the original problem: The report does not render, nor is
>> > there
>> > any error message. The report renders fine when inside the intranet.
>> >
>> > Please advise the best way to proceed to resolve this. I have several
>> > clients who would like to use Reporting Services - but first I have to
>> > show
>> > that it works!
>> >
>> > "JohnWoll" wrote:
>> >
>> >> RS works fine locally.
>> >> When accessed from the internet, I can see the report folders; I can
>> >> select
>> >> a report; it processes "Opening...."; then (briefly) "Finding site
>> >> xxxx";
>> >> then nothing. No circular icon that says "Processing Report", just a
>> >> big
>> >> blank page.
>> >>
>> >> I have tried it as Administrator, and from both an XP/IE and Windows
>> >> 2003
>> >> Server box.
>> >>
>> >> RS is running on IIS 6.0, Windows 2003.
>> >> I don't know what SP is on RS. How do I find that out?
>> >> Any suggestions will be appreciated.
>>|||Hi,
In the Report Manager, Site Settings try increasing the Report Execution
Timeout period
Mandar
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:enfGsNvSFHA.2336@.TK2MSFTNGP12.phx.gbl...
> Most likely, you need to set the ReportServerExternalUrl property. This is
> described in the docs somewhere but I don't have the link handy.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> > Thanks for the response, Brian!
> >
> > I am using fully qualified domain names.
> >
> > I tried going straight to reportserver, instead of using Report Manager
> > UI.
> > When I do, the report renders normally: I see the icon and message, and
it
> > renders. I greatly appreciate the suggestion, and shame on me for not
> > thinking of trying that.
> >
> > The question remains, why Report Manager does not render. Any
suggestions?
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Are you using fully qualified domain names or NetBIOS names? Can you
> >> browse
> >> to http://server/reportserver instead of using the Report Manager UI?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> >> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> >> > Thank you, Andrew, for the help in determining the SP. I am running
the
> >> > latest release (8.00.878.00).
> >> >
> >> > I still have the original problem: The report does not render, nor is
> >> > there
> >> > any error message. The report renders fine when inside the intranet.
> >> >
> >> > Please advise the best way to proceed to resolve this. I have several
> >> > clients who would like to use Reporting Services - but first I have
to
> >> > show
> >> > that it works!
> >> >
> >> > "JohnWoll" wrote:
> >> >
> >> >> RS works fine locally.
> >> >> When accessed from the internet, I can see the report folders; I can
> >> >> select
> >> >> a report; it processes "Opening...."; then (briefly) "Finding site
> >> >> xxxx";
> >> >> then nothing. No circular icon that says "Processing Report", just a
> >> >> big
> >> >> blank page.
> >> >>
> >> >> I have tried it as Administrator, and from both an XP/IE and Windows
> >> >> 2003
> >> >> Server box.
> >> >>
> >> >> RS is running on IIS 6.0, Windows 2003.
> >> >> I don't know what SP is on RS. How do I find that out?
> >> >> Any suggestions will be appreciated.
> >>
> >>
> >>
>|||I tried increasing the Report Execution Timeout period. It did not make any
difference.
"IB Ghost" wrote:
> Hi,
> In the Report Manager, Site Settings try increasing the Report Execution
> Timeout period
> Mandar
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:enfGsNvSFHA.2336@.TK2MSFTNGP12.phx.gbl...
> > Most likely, you need to set the ReportServerExternalUrl property. This is
> > described in the docs somewhere but I don't have the link handy.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> > news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> > > Thanks for the response, Brian!
> > >
> > > I am using fully qualified domain names.
> > >
> > > I tried going straight to reportserver, instead of using Report Manager
> > > UI.
> > > When I do, the report renders normally: I see the icon and message, and
> it
> > > renders. I greatly appreciate the suggestion, and shame on me for not
> > > thinking of trying that.
> > >
> > > The question remains, why Report Manager does not render. Any
> suggestions?
> > >
> > > "Brian Welcker [MSFT]" wrote:
> > >
> > >> Are you using fully qualified domain names or NetBIOS names? Can you
> > >> browse
> > >> to http://server/reportserver instead of using the Report Manager UI?
> > >>
> > >> --
> > >> Brian Welcker
> > >> Group Program Manager
> > >> Microsoft SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> > >> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> > >> > Thank you, Andrew, for the help in determining the SP. I am running
> the
> > >> > latest release (8.00.878.00).
> > >> >
> > >> > I still have the original problem: The report does not render, nor is
> > >> > there
> > >> > any error message. The report renders fine when inside the intranet.
> > >> >
> > >> > Please advise the best way to proceed to resolve this. I have several
> > >> > clients who would like to use Reporting Services - but first I have
> to
> > >> > show
> > >> > that it works!
> > >> >
> > >> > "JohnWoll" wrote:
> > >> >
> > >> >> RS works fine locally.
> > >> >> When accessed from the internet, I can see the report folders; I can
> > >> >> select
> > >> >> a report; it processes "Opening...."; then (briefly) "Finding site
> > >> >> xxxx";
> > >> >> then nothing. No circular icon that says "Processing Report", just a
> > >> >> big
> > >> >> blank page.
> > >> >>
> > >> >> I have tried it as Administrator, and from both an XP/IE and Windows
> > >> >> 2003
> > >> >> Server box.
> > >> >>
> > >> >> RS is running on IIS 6.0, Windows 2003.
> > >> >> I don't know what SP is on RS. How do I find that out?
> > >> >> Any suggestions will be appreciated.
> > >>
> > >>
> > >>
> >
> >
>
>|||THANK YOU BRIAN! That is exactly what the problem was.
In the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager folder I changed the RSWebApplication.config file by
adding a line tagged with ReportServerExternalUrl:
<ReportServerExternalURL>http://MyDomain.com/ReportServer</ReportServerExternalURL>
"Brian Welcker [MSFT]" wrote:
> Most likely, you need to set the ReportServerExternalUrl property. This is
> described in the docs somewhere but I don't have the link handy.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> news:C359A949-2907-4FE5-A9F4-86EAA915A8FA@.microsoft.com...
> > Thanks for the response, Brian!
> >
> > I am using fully qualified domain names.
> >
> > I tried going straight to reportserver, instead of using Report Manager
> > UI.
> > When I do, the report renders normally: I see the icon and message, and it
> > renders. I greatly appreciate the suggestion, and shame on me for not
> > thinking of trying that.
> >
> > The question remains, why Report Manager does not render. Any suggestions?
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Are you using fully qualified domain names or NetBIOS names? Can you
> >> browse
> >> to http://server/reportserver instead of using the Report Manager UI?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "JohnWoll" <JohnWoll@.discussions.microsoft.com> wrote in message
> >> news:13B3183D-F808-4369-AB7F-F10BEDC05368@.microsoft.com...
> >> > Thank you, Andrew, for the help in determining the SP. I am running the
> >> > latest release (8.00.878.00).
> >> >
> >> > I still have the original problem: The report does not render, nor is
> >> > there
> >> > any error message. The report renders fine when inside the intranet.
> >> >
> >> > Please advise the best way to proceed to resolve this. I have several
> >> > clients who would like to use Reporting Services - but first I have to
> >> > show
> >> > that it works!
> >> >
> >> > "JohnWoll" wrote:
> >> >
> >> >> RS works fine locally.
> >> >> When accessed from the internet, I can see the report folders; I can
> >> >> select
> >> >> a report; it processes "Opening...."; then (briefly) "Finding site
> >> >> xxxx";
> >> >> then nothing. No circular icon that says "Processing Report", just a
> >> >> big
> >> >> blank page.
> >> >>
> >> >> I have tried it as Administrator, and from both an XP/IE and Windows
> >> >> 2003
> >> >> Server box.
> >> >>
> >> >> RS is running on IIS 6.0, Windows 2003.
> >> >> I don't know what SP is on RS. How do I find that out?
> >> >> Any suggestions will be appreciated.
> >>
> >>
> >>
>
>