Monday, March 12, 2012
Make a list box not reqired.
The list box gets its values from a table.
If the user does not coose anything from the list box and hits 'View Report'
It should be able to go and grab all data from the table.
How do I make RS do this?
I tried 'Allow Null Value' for that particular parameter, but it still does
not work.
Anyone knows how to do this?You could grap the value "%" as a default value of this list box and put it
in your query, nevertheless if you are usinga stored procedure you can
handle the "empty" paramters, or you use the ISNULL(Parameter,Value) in your
query. Today it´s kind of a hack to do this ;-)
HTH, Jens Süßmeyer.
--
http://www.sqlserver2005.de
--
"appu" <appu@.discussions.microsoft.com> schrieb im Newsbeitrag
news:6E985A61-49F3-4AE1-B504-29E0954EA649@.microsoft.com...
>I have a report that takes values from a list box to generate the report.
> The list box gets its values from a table.
> If the user does not coose anything from the list box and hits 'View
> Report'
> It should be able to go and grab all data from the table.
> How do I make RS do this?
> I tried 'Allow Null Value' for that particular parameter, but it still
> does
> not work.
> Anyone knows how to do this?|||Thanks! I got the answer.
I can do a union of 'all', '<select all>'
when I grab my parameters from the table.
"Jens Sü�meyer" wrote:
> You could grap the value "%" as a default value of this list box and put it
> in your query, nevertheless if you are usinga stored procedure you can
> handle the "empty" paramters, or you use the ISNULL(Parameter,Value) in your
> query. Today it´s kind of a hack to do this ;-)
> HTH, Jens Sü�meyer.
> --
> http://www.sqlserver2005.de
> --
> "appu" <appu@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:6E985A61-49F3-4AE1-B504-29E0954EA649@.microsoft.com...
> >I have a report that takes values from a list box to generate the report.
> > The list box gets its values from a table.
> > If the user does not coose anything from the list box and hits 'View
> > Report'
> > It should be able to go and grab all data from the table.
> > How do I make RS do this?
> > I tried 'Allow Null Value' for that particular parameter, but it still
> > does
> > not work.
> > Anyone knows how to do this?
>
>
make a copy of database
Hi:
I have installed sql server 2005 express and SQL Server Management Studio Express
How can I generate a database from another copying the structure and data?
For example I have a database named Customers, I need to make a copy of Customers named Customers2. Customers2 also will be attached to the same Database Engine Server where Customers is attached.
How I Can do it?
Thanks!
P.S.
I tryied to make a copy of mdf an ldf files from Windows Explorer and renamed these files but I could not attach to the same Database Engine Server because I got an error.
The easiest way to do it is with the Backup and Restore Wizard because during restore you can change the name of the new one to customer2, I do it all the time, email the .bak or restore the .bak with a new name for a different department. If you don't have the SQL Server Express Advanced download it from the link below to use the Backup and Restore Wizard. Hope this helps.
http://msdn.microsoft.com/vstudio/express/sql/download/