Report parameter dropdown

I bound a report parameter to a combobox. I tried to configure default
parameter as null several ways
in report parameters properties dialog but could not.
How can i specify default value of null for a combobox parameter? thxOn Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> I bound a report parameter to a combobox. I tried to configure default
> parameter as null several ways
> in report parameters properties dialog but could not.
> How can i specify default value of null for a combobox parameter? thx
If the default value of null does not work in the Report Parameters
dialog, I would suggest unioning your dataset against an empty/null
record and then use a default of the dataset and make sure that the
empty/null value is listed first. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||thx!
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
>> I bound a report parameter to a combobox. I tried to configure default
>> parameter as null several ways
>> in report parameters properties dialog but could not.
>> How can i specify default value of null for a combobox parameter? thx
>
> If the default value of null does not work in the Report Parameters
> dialog, I would suggest unioning your dataset against an empty/null
> record and then use a default of the dataset and make sure that the
> empty/null value is listed first. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Apr 18, 1:51 pm, "nkg" <x...@.yahoo.com> wrote:
> thx!"EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> > On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> >> I bound a report parameter to a combobox. I tried to configure default
> >> parameter as null several ways
> >> in report parameters properties dialog but could not.
> >> How can i specify default value of null for a combobox parameter? thx
> > If the default value of null does not work in the Report Parameters
> > dialog, I would suggest unioning your dataset against an empty/null
> > record and then use a default of the dataset and make sure that the
> > empty/null value is listed first. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" wrote:
> On Apr 18, 1:51 pm, "nkg" <x...@.yahoo.com> wrote:
> > thx!"EMartinez" <emartinez...@.gmail.com> wrote in message
> >
> > news:1176856481.241478.187380@.b58g2000hsg.googlegroups.com...
> >
> > > On Apr 17, 2:09 pm, "nkg" <x...@.yahoo.com> wrote:
> > >> I bound a report parameter to a combobox. I tried to configure default
> > >> parameter as null several ways
> > >> in report parameters properties dialog but could not.
> >
> > >> How can i specify default value of null for a combobox parameter? thx
> >
> > > If the default value of null does not work in the Report Parameters
> > > dialog, I would suggest unioning your dataset against an empty/null
> > > record and then use a default of the dataset and make sure that the
> > > empty/null value is listed first. Hope this helps.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. Software Consultant
>
> You're welcome. Let me know if I can be of further assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Instead of modifying my datasource, I chose to change the parameter. A small
function injects the null value into the selected list before filtering my
data.
here's how :
http://pderop.blogspot.com/2007/05/ssrs-multivalue-and-nulls.html
cheers

Report Model Filter

Hi,
When creating a report model, is it possible to configure a field so
that a user must apply a filter when they create reports in Report
Builder?
In my case, I have a simple report model that contains summarized data
grouped by date and then by hour. Due to the amount of data in the
underlying table, I would like for users to be forced to filter on
either a specific date or a range of dates if possible. Even better
would be for me to be able to set a default date range for the date in
the model.
Does anyone know if what I am attempting is possible or has anyone
done something similar?
Thanks in advance,
Shane.You can use couple of things, depending on your requirement.
1. "Prompt" where it will wait for user input. but there is no multi select.
2. "From...to" this will be suitable for your requirement where in the user
can give the from and to date so that it will filter the required.
Amarnath, MCTS
"shanejokeeffe" wrote:
> Hi,
> When creating a report model, is it possible to configure a field so
> that a user must apply a filter when they create reports in Report
> Builder?
> In my case, I have a simple report model that contains summarized data
> grouped by date and then by hour. Due to the amount of data in the
> underlying table, I would like for users to be forced to filter on
> either a specific date or a range of dates if possible. Even better
> would be for me to be able to set a default date range for the date in
> the model.
> Does anyone know if what I am attempting is possible or has anyone
> done something similar?
> Thanks in advance,
> Shane.
>

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager Virtual Directory

I am trying to configure the Report Manager Virtual Directory but cannot do it. In the Configure Report Server screen, the option is greyed out (there is a tick next to it to say that it has been configured, but this is greyed out too)!

Any ideas?

Thanks

Tom

Service started ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||I think so - although this is the first time I have ever used it. - I was following a video tutorial and did everything that was said on the video!|||

Use Reporting Services Configuration (SS 2005). This will tell you if the service is properly initialized. This is where you should manage the Virtual Directory and setup the SS2K5 RS database.

What video tutorial are you using?

|||

Look in the services. Is there a service with the name "Report%" (wehere the % is for any characters following). Is the Service started ? If yes, whats the Service name ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I am expereincing this same issue, with an install of SQL 2005 Workgroup Edition. I have looked and I do not have a service called "Report%".

|||

SQL Server Reporting Services is an optional service that can be installed with any version of SQL Server--even the Express Edition. It, like any service must be running to be functional. This means you must use one of the SQL Server configuration tools or services.msc to start the service (once it's installed). These tools can configure the service to start when the system starts or on demand (by a program like SC).

SC Start reportserver$ss2k5

This command-line function starts the reportserver service for the SQL Server instance SS2K5.

hth

|||

Hi,

thanks for all the responces.

Ok, i'll try and answer all the questions so far:

1) Looking in "SQL Server 2005 Services" there does appear to be a reporting service running, but it is not called "Report%" it is called "SQLEXPRESS". This Service Type is named "ReportServer"

2) Looking in the "Reporting Services Configuration Manager", it does state that the report server is running

Instance Name: SQL EXPRESS

Initialized: Yes

Service Status: running

3) On the left hand side all of the Options have been configured. Most of them are green and you can click on the ones that are. however, "Report Manager Virtual Directory" and "Initialization" are greyed out and you cannot click on them to set up the directory (although they both have ticks against them, in grey)

Thanks

Tom

|||

Okay, I created a VPC (XP) and installed SQL Server Express Advanced Services edition to simulate what you (apparently have). This installed SQL Server Express as the SQLExpress instance and the Reporting Services service on that instance. Using the Reporting Services Configuration Manager I found that the initial Report Server and Report Manager virtual directories had not been created but the dialog to create them was not grayed out. If I clicked "new" it permitted me to create a "ReportServer" and "Reports" virtual directories.

Question: do you have IIS installed on the target system? Is the service running? To see, use the Adminstrative Tools | Internet Information Services utility to drill down to the default web site to see if it's running. If not, you'll need to install IIS (Control Panel | Add Windows Applications.

|||

Hi,

thanks for the reply.

I decided to uninstall the SQL instance and re-install. Hey presto - it now works!! I must have installed it incorrectly as I can now create everything I need to.

Thanks for everyones help though!

Tom

|||

Hi,

I am having that same problem.

Did you just uninstall SQL server or the reporting services also?

It's frustrating!

|||I uninstalled everything to do with SQL and started again!|||Thank you, I will try it.

Report Manager CreationDate...Display !New

Is there a way to configure how long to display the "!New" icon in the Report
Manger?The icon will display for 48 hours. It is not configurable.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"tjhazel" <tjhazel@.discussions.microsoft.com> wrote in message
news:D9E01423-83AB-43A6-AD8C-24531A09F2DC@.microsoft.com...
> Is there a way to configure how long to display the "!New" icon in the
> Report
> Manger?
>