Deleting Parameter From Preview Pain

Product: Reporting Services 2005

Visual Studio 2005

I've added parameters to my query in the Data Tab. Then removed one. The preview pane still shows the deleted parameter even though it does not exist in my query. I've tried opening the dataset settings and re-adding the parameter, saving, then deleting. This ghost parameter will not disappear from the Preview Pane. Is this a bug or am I not deleting it correctly.

Thanks,

Matt

To solve your preview pane pain, you need to remove the parameter from the Report Parameters collection.

Select Report from the toolbar and Report Parameters. When you add a query parameter a Report Parameter is automatically created for you, but the same is not true when your remove query parameters.

-chris

delete tables

I′m new with SQL. I have a CA product that creates every day 44 tables, awa
ys with the same name (RCXXXXX). But this program don′t delete this tables
after generate its. I need to delete this tables automatic whent they became
7 days old. Any one can he
lp?
Thanks,
LudTake a look in Books Online about 'cursors'. You can build a cursor against
all the user tables by reading from INFORMATION_SCHEMA.TABLES .
You can then build dynamic sql string and execute it like this from inside
the cursor.
exec('drop table xxx')
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Lud" <anonymous@.discussions.microsoft.com> wrote in message
news:9F3258D6-2B18-4899-B137-1D4E73C609BD@.microsoft.com...
> Im new with SQL. I have a CA product that creates every day 44 tables,
aways with the same name (RCXXXXX). But this program dont delete this
tables after generate its. I need to delete this tables automatic whent they
became 7 days old. Any one can help?
> Thanks,
> Lud|||Lud,
The below query would give the creation date of the tables whose name starts
with RC
SELECT crdate
FROM sysobjects
WHERE type='U'
AND [name] LIKE 'RC%'
You can schedule a sql job which will find the old ones (use DATEDIFF) and
drop them.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Lud" <anonymous@.discussions.microsoft.com> wrote in message
news:9F3258D6-2B18-4899-B137-1D4E73C609BD@.microsoft.com...
> Im new with SQL. I have a CA product that creates every day 44 tables,
aways with the same name (RCXXXXX). But this program dont delete this
tables after generate its. I need to delete this tables automatic whent they
became 7 days old. Any one can help?
> Thanks,
> Lud

delete tables

I´m new with SQL. I have a CA product that creates every day 44 tables, aways with the same name (RCXXXXX). But this program don´t delete this tables after generate its. I need to delete this tables automatic whent they became 7 days old. Any one can help?
Thanks,
LudTake a look in Books Online about 'cursors'. You can build a cursor against
all the user tables by reading from INFORMATION_SCHEMA.TABLES .
You can then build dynamic sql string and execute it like this from inside
the cursor.
exec('drop table xxx')
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Lud" <anonymous@.discussions.microsoft.com> wrote in message
news:9F3258D6-2B18-4899-B137-1D4E73C609BD@.microsoft.com...
> I´m new with SQL. I have a CA product that creates every day 44 tables,
aways with the same name (RCXXXXX). But this program don´t delete this
tables after generate its. I need to delete this tables automatic whent they
became 7 days old. Any one can help?
> Thanks,
> Lud|||Lud,
The below query would give the creation date of the tables whose name starts
with RC
SELECT crdate
FROM sysobjects
WHERE type='U'
AND [name] LIKE 'RC%'
You can schedule a sql job which will find the old ones (use DATEDIFF) and
drop them.
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Lud" <anonymous@.discussions.microsoft.com> wrote in message
news:9F3258D6-2B18-4899-B137-1D4E73C609BD@.microsoft.com...
> I´m new with SQL. I have a CA product that creates every day 44 tables,
aways with the same name (RCXXXXX). But this program don´t delete this
tables after generate its. I need to delete this tables automatic whent they
became 7 days old. Any one can help?
> Thanks,
> Lud

delete tables

I′m new with SQL. I have a CA product that creates every day 44 tables, aways with the same name (RCXXXXX). But this program don′t delete this tables after generate its. I need to delete this tables automatic whent they became 7 days old. Any one can he
lp?
Thanks,
Lud
Take a look in Books Online about 'cursors'. You can build a cursor against
all the user tables by reading from INFORMATION_SCHEMA.TABLES .
You can then build dynamic sql string and execute it like this from inside
the cursor.
exec('drop table xxx')
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Lud" <anonymous@.discussions.microsoft.com> wrote in message
news:9F3258D6-2B18-4899-B137-1D4E73C609BD@.microsoft.com...
> Im new with SQL. I have a CA product that creates every day 44 tables,
aways with the same name (RCXXXXX). But this program dont delete this
tables after generate its. I need to delete this tables automatic whent they
became 7 days old. Any one can help?
> Thanks,
> Lud
|||Lud,
The below query would give the creation date of the tables whose name starts
with RC
SELECT crdate
FROM sysobjects
WHERE type='U'
AND [name] LIKE 'RC%'
You can schedule a sql job which will find the old ones (use DATEDIFF) and
drop them.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Lud" <anonymous@.discussions.microsoft.com> wrote in message
news:9F3258D6-2B18-4899-B137-1D4E73C609BD@.microsoft.com...
> Im new with SQL. I have a CA product that creates every day 44 tables,
aways with the same name (RCXXXXX). But this program dont delete this
tables after generate its. I need to delete this tables automatic whent they
became 7 days old. Any one can help?
> Thanks,
> Lud