Hi, I changed a report to point to another dataset. Both the old and new
data sets are stored procs with parameters. The issue I'm getting is when I
try to preview the report it is still wants the old parameters. I changed
the dataset value in the table properties and hit refreshed in the data pane.
Any suggestions.Query parameters and report parameters are two different things. When you
are creating or modifying the dataset query parameters (or in your case
stored procedure) parameters are detected and report parameters are created.
The report parameters stick around unless you delete them. In layout view,
Report Menu->Report Parameters. Click on the parameter and delete it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Lisa" <Lisa@.discussions.microsoft.com> wrote in message
news:799D404D-0742-4B2D-B708-49F566AFA9D9@.microsoft.com...
> Hi, I changed a report to point to another dataset. Both the old and new
> data sets are stored procs with parameters. The issue I'm getting is when
> I
> try to preview the report it is still wants the old parameters. I changed
> the dataset value in the table properties and hit refreshed in the data
> pane.
> Any suggestions.
Showing posts with label point. Show all posts
Showing posts with label point. Show all posts
Thursday, March 22, 2012
Friday, February 24, 2012
Change SQL 2000 Server 64bit collation
Please point me to the procedure for changing the collation sequence on 64bit
installation of SQL Server 2000 (SP4). I can't find anything in KB or BOL.
Thanks,
Tom
Hi
Collations are a different levels, so there is not one place you will need
to change it. Changing the Collation of 64bit SQL Server is no different to
changing it on 32bit SQL Server. If this is a fresh install and you don't
have any databases to change then the best option is probably to re-install.
You can use rebuildm.exe to change the master database with a different
collation. Each database can have the collation changed using the ALTER
DATABASE command, this will not change the collation of existing columns that
have been set to the original collation. To do that you will need to run a
script that uses the ALTER TABLE command. If you the column are indexes or a
primary key, or have Foreign Keys pointing to them, the constraint will need
to be dropped. There are many threads on this for example
http://tinyurl.com/ky3q
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/arch...
Other links that may be useful:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/arch...
John
"T Morris" wrote:
> Please point me to the procedure for changing the collation sequence on 64bit
> installation of SQL Server 2000 (SP4). I can't find anything in KB or BOL.
> Thanks,
> Tom
|||Since I didn't find Rebuildm.exe in the binn folder for the 64bit
installation I thought there might be a different procedure.
But per your email, I use the same procedure. And I must find the
rebuildm.exe program.
Am I correct?
Thanks,
Tom
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Collations are a different levels, so there is not one place you will need
> to change it. Changing the Collation of 64bit SQL Server is no different to
> changing it on 32bit SQL Server. If this is a fresh install and you don't
> have any databases to change then the best option is probably to re-install.
> You can use rebuildm.exe to change the master database with a different
> collation. Each database can have the collation changed using the ALTER
> DATABASE command, this will not change the collation of existing columns that
> have been set to the original collation. To do that you will need to run a
> script that uses the ALTER TABLE command. If you the column are indexes or a
> primary key, or have Foreign Keys pointing to them, the constraint will need
> to be dropped. There are many threads on this for example
> http://tinyurl.com/ky3q
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/arch...
> Other links that may be useful:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/arch...
> John
> "T Morris" wrote:
|||Hi
I usually favour re-install rather than rebuildm.exe and on the 32 bit
version it is in the ...\80\tools\binn directory.
John
"T Morris" wrote:
[vbcol=seagreen]
> Since I didn't find Rebuildm.exe in the binn folder for the 64bit
> installation I thought there might be a different procedure.
> But per your email, I use the same procedure. And I must find the
> rebuildm.exe program.
> Am I correct?
> Thanks,
> Tom
> "John Bell" wrote:
installation of SQL Server 2000 (SP4). I can't find anything in KB or BOL.
Thanks,
Tom
Hi
Collations are a different levels, so there is not one place you will need
to change it. Changing the Collation of 64bit SQL Server is no different to
changing it on 32bit SQL Server. If this is a fresh install and you don't
have any databases to change then the best option is probably to re-install.
You can use rebuildm.exe to change the master database with a different
collation. Each database can have the collation changed using the ALTER
DATABASE command, this will not change the collation of existing columns that
have been set to the original collation. To do that you will need to run a
script that uses the ALTER TABLE command. If you the column are indexes or a
primary key, or have Foreign Keys pointing to them, the constraint will need
to be dropped. There are many threads on this for example
http://tinyurl.com/ky3q
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/arch...
Other links that may be useful:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/arch...
John
"T Morris" wrote:
> Please point me to the procedure for changing the collation sequence on 64bit
> installation of SQL Server 2000 (SP4). I can't find anything in KB or BOL.
> Thanks,
> Tom
|||Since I didn't find Rebuildm.exe in the binn folder for the 64bit
installation I thought there might be a different procedure.
But per your email, I use the same procedure. And I must find the
rebuildm.exe program.
Am I correct?
Thanks,
Tom
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Collations are a different levels, so there is not one place you will need
> to change it. Changing the Collation of 64bit SQL Server is no different to
> changing it on 32bit SQL Server. If this is a fresh install and you don't
> have any databases to change then the best option is probably to re-install.
> You can use rebuildm.exe to change the master database with a different
> collation. Each database can have the collation changed using the ALTER
> DATABASE command, this will not change the collation of existing columns that
> have been set to the original collation. To do that you will need to run a
> script that uses the ALTER TABLE command. If you the column are indexes or a
> primary key, or have Foreign Keys pointing to them, the constraint will need
> to be dropped. There are many threads on this for example
> http://tinyurl.com/ky3q
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/arch...
> Other links that may be useful:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/arch...
> John
> "T Morris" wrote:
|||Hi
I usually favour re-install rather than rebuildm.exe and on the 32 bit
version it is in the ...\80\tools\binn directory.
John
"T Morris" wrote:
[vbcol=seagreen]
> Since I didn't find Rebuildm.exe in the binn folder for the 64bit
> installation I thought there might be a different procedure.
> But per your email, I use the same procedure. And I must find the
> rebuildm.exe program.
> Am I correct?
> Thanks,
> Tom
> "John Bell" wrote:
Change SQL 2000 Server 64bit collation
Please point me to the procedure for changing the collation sequence on 64bi
t
installation of SQL Server 2000 (SP4). I can't find anything in KB or BOL.
Thanks,
TomHi
Collations are a different levels, so there is not one place you will need
to change it. Changing the Collation of 64bit SQL Server is no different to
changing it on 32bit SQL Server. If this is a fresh install and you don't
have any databases to change then the best option is probably to re-install.
You can use rebuildm.exe to change the master database with a different
collation. Each database can have the collation changed using the ALTER
DATABASE command, this will not change the collation of existing columns tha
t
have been set to the original collation. To do that you will need to run a
script that uses the ALTER TABLE command. If you the column are indexes or a
primary key, or have Foreign Keys pointing to them, the constraint will need
to be dropped. There are many threads on this for example
http://tinyurl.com/ky3q
http://msdn.microsoft.com/library/d...y/en-us/arch...
Other links that may be useful:
http://msdn.microsoft.com/library/d...y/en-us/arch...
John
"T Morris" wrote:
> Please point me to the procedure for changing the collation sequence on 64
bit
> installation of SQL Server 2000 (SP4). I can't find anything in KB or BOL.
> Thanks,
> Tom|||Since I didn't find Rebuildm.exe in the binn folder for the 64bit
installation I thought there might be a different procedure.
But per your email, I use the same procedure. And I must find the
rebuildm.exe program.
Am I correct?
Thanks,
Tom
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Collations are a different levels, so there is not one place you will need
> to change it. Changing the Collation of 64bit SQL Server is no different t
o
> changing it on 32bit SQL Server. If this is a fresh install and you don't
> have any databases to change then the best option is probably to re-instal
l.
> You can use rebuildm.exe to change the master database with a different
> collation. Each database can have the collation changed using the ALTER
> DATABASE command, this will not change the collation of existing columns t
hat
> have been set to the original collation. To do that you will need to run a
> script that uses the ALTER TABLE command. If you the column are indexes or
a
> primary key, or have Foreign Keys pointing to them, the constraint will ne
ed
> to be dropped. There are many threads on this for example
> http://tinyurl.com/ky3q
> http://msdn.microsoft.com/library/d...y/en-us/arch...
> Other links that may be useful:
> http://msdn.microsoft.com/library/d...y/en-us/arch...
> John
> "T Morris" wrote:
>|||Hi
I usually favour re-install rather than rebuildm.exe and on the 32 bit
version it is in the ...\80\tools\binn directory.
John
"T Morris" wrote:
[vbcol=seagreen]
> Since I didn't find Rebuildm.exe in the binn folder for the 64bit
> installation I thought there might be a different procedure.
> But per your email, I use the same procedure. And I must find the
> rebuildm.exe program.
> Am I correct?
> Thanks,
> Tom
> "John Bell" wrote:
>
t
installation of SQL Server 2000 (SP4). I can't find anything in KB or BOL.
Thanks,
TomHi
Collations are a different levels, so there is not one place you will need
to change it. Changing the Collation of 64bit SQL Server is no different to
changing it on 32bit SQL Server. If this is a fresh install and you don't
have any databases to change then the best option is probably to re-install.
You can use rebuildm.exe to change the master database with a different
collation. Each database can have the collation changed using the ALTER
DATABASE command, this will not change the collation of existing columns tha
t
have been set to the original collation. To do that you will need to run a
script that uses the ALTER TABLE command. If you the column are indexes or a
primary key, or have Foreign Keys pointing to them, the constraint will need
to be dropped. There are many threads on this for example
http://tinyurl.com/ky3q
http://msdn.microsoft.com/library/d...y/en-us/arch...
Other links that may be useful:
http://msdn.microsoft.com/library/d...y/en-us/arch...
John
"T Morris" wrote:
> Please point me to the procedure for changing the collation sequence on 64
bit
> installation of SQL Server 2000 (SP4). I can't find anything in KB or BOL.
> Thanks,
> Tom|||Since I didn't find Rebuildm.exe in the binn folder for the 64bit
installation I thought there might be a different procedure.
But per your email, I use the same procedure. And I must find the
rebuildm.exe program.
Am I correct?
Thanks,
Tom
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Collations are a different levels, so there is not one place you will need
> to change it. Changing the Collation of 64bit SQL Server is no different t
o
> changing it on 32bit SQL Server. If this is a fresh install and you don't
> have any databases to change then the best option is probably to re-instal
l.
> You can use rebuildm.exe to change the master database with a different
> collation. Each database can have the collation changed using the ALTER
> DATABASE command, this will not change the collation of existing columns t
hat
> have been set to the original collation. To do that you will need to run a
> script that uses the ALTER TABLE command. If you the column are indexes or
a
> primary key, or have Foreign Keys pointing to them, the constraint will ne
ed
> to be dropped. There are many threads on this for example
> http://tinyurl.com/ky3q
> http://msdn.microsoft.com/library/d...y/en-us/arch...
> Other links that may be useful:
> http://msdn.microsoft.com/library/d...y/en-us/arch...
> John
> "T Morris" wrote:
>|||Hi
I usually favour re-install rather than rebuildm.exe and on the 32 bit
version it is in the ...\80\tools\binn directory.
John
"T Morris" wrote:
[vbcol=seagreen]
> Since I didn't find Rebuildm.exe in the binn folder for the 64bit
> installation I thought there might be a different procedure.
> But per your email, I use the same procedure. And I must find the
> rebuildm.exe program.
> Am I correct?
> Thanks,
> Tom
> "John Bell" wrote:
>
Sunday, February 19, 2012
Change ReportServer database
We have installed Reporting Services on a new server using the local
database. Now we want to point to a ReportServer database on another
database server.
How can we change the server used for the ReportServer database to point to
a different server?
Thanks
--
RickIn SQL 2005:
Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
Tools/Reporting Services Configuration
This will open the Reporting Services Configuration Manager. Choose
"Database Setup" from the left column and set the server and database name.
In SQL 2000 run the following (see
http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
-p<password>
<ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
authentication of the service account SQLRS will use to connect to the
ReportServer database <UserName> & <Password> is the name/password of the
service account mentioned above.
Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
rsconfig can be found in the C:\Program Files\Microsoft SQL
Server\80\Tools\Binn folder.
This assumes that the report services db is a restore of the original. If
it's different then it get's a little more complicated as encryption keys and
versions need to match.
"Rick" wrote:
> We have installed Reporting Services on a new server using the local
> database. Now we want to point to a ReportServer database on another
> database server.
> How can we change the server used for the ReportServer database to point to
> a different server?
> Thanks
> --
> Rick|||Thanks.
--
Rick
"Limey" wrote:
> In SQL 2005:
> Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
> Tools/Reporting Services Configuration
> This will open the Reporting Services Configuration Manager. Choose
> "Database Setup" from the left column and set the server and database name.
> In SQL 2000 run the following (see
> http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
> rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
> -p<password>
> <ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
> authentication of the service account SQLRS will use to connect to the
> ReportServer database <UserName> & <Password> is the name/password of the
> service account mentioned above.
> Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
> rsconfig can be found in the C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn folder.
> This assumes that the report services db is a restore of the original. If
> it's different then it get's a little more complicated as encryption keys and
> versions need to match.
>
>
> "Rick" wrote:
> > We have installed Reporting Services on a new server using the local
> > database. Now we want to point to a ReportServer database on another
> > database server.
> >
> > How can we change the server used for the ReportServer database to point to
> > a different server?
> >
> > Thanks
> > --
> > Rick
database. Now we want to point to a ReportServer database on another
database server.
How can we change the server used for the ReportServer database to point to
a different server?
Thanks
--
RickIn SQL 2005:
Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
Tools/Reporting Services Configuration
This will open the Reporting Services Configuration Manager. Choose
"Database Setup" from the left column and set the server and database name.
In SQL 2000 run the following (see
http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
-p<password>
<ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
authentication of the service account SQLRS will use to connect to the
ReportServer database <UserName> & <Password> is the name/password of the
service account mentioned above.
Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
rsconfig can be found in the C:\Program Files\Microsoft SQL
Server\80\Tools\Binn folder.
This assumes that the report services db is a restore of the original. If
it's different then it get's a little more complicated as encryption keys and
versions need to match.
"Rick" wrote:
> We have installed Reporting Services on a new server using the local
> database. Now we want to point to a ReportServer database on another
> database server.
> How can we change the server used for the ReportServer database to point to
> a different server?
> Thanks
> --
> Rick|||Thanks.
--
Rick
"Limey" wrote:
> In SQL 2005:
> Open - Start/All Programs/Microsoft SQL Server 2005/Configuration
> Tools/Reporting Services Configuration
> This will open the Reporting Services Configuration Manager. Choose
> "Database Setup" from the left column and set the server and database name.
> In SQL 2000 run the following (see
> http://www.sqlservercentral.com/columnists/mpearson/recoveryplanningforsqlreportingservices.asp for more info):
> rsconfig -c -s<ServerName> -dReportServer -a<Authtype> -u<username>
> -p<password>
> <ServerName> is the new Server name <Authtype> is â'Windowsâ' or â'SQLâ'
> authentication of the service account SQLRS will use to connect to the
> ReportServer database <UserName> & <Password> is the name/password of the
> service account mentioned above.
> Eg : rsconfig -c â'sSQL01 -dReportServer -aWindows â'uSDM\svcSQLRS â'ppass@.word
> rsconfig can be found in the C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn folder.
> This assumes that the report services db is a restore of the original. If
> it's different then it get's a little more complicated as encryption keys and
> versions need to match.
>
>
> "Rick" wrote:
> > We have installed Reporting Services on a new server using the local
> > database. Now we want to point to a ReportServer database on another
> > database server.
> >
> > How can we change the server used for the ReportServer database to point to
> > a different server?
> >
> > Thanks
> > --
> > Rick
Tuesday, February 14, 2012
Change point sizes in Scatter Graph (SSRS 2005)
Is there a way to do conditional formatting on the size of points on a Scatter Graph in Reporting Services 2005?It is not currently possible to change the size of the Markers dynamically through RS.
Ian
Subscribe to:
Posts (Atom)