Compare Report

Hi there,

I want to set up a report tha will take my 30 best customers of Q1 2006 and that will display also the facts of Q1 2007.

Can I use a parameter to select these customers on 1 report instead of 30 different reports.

Thx

Is this a report built off of an MDX query or SQL?

For SQL, just use the SELECT TOP n syntax.

For MDX, you may have to use a query expression.

If you could elaborate on the structure of the data and what would define a best customer that would help.

cheers,

Andrew

|||

Yes, you can create a report with one parameter which will be multi-valued and its available values from a query which uses TOP 30 in its SQL text.

Shyam

command to backup database to null device for testing purpose? tha

command to backup database to null device for testing purpose? thaHi Brian
I am not at all sure how backing up to a NULL device will test anything?
You may want to use a small database or filegroup to do your tests. You will
not know that the backup has really worked unless you restore it!!!
John
"Brian Brian" wrote:

> --
> Brian|||Try AgileInfoSoftware DataStudio (http://www.agileinfollc.com) for moving
database to another database.
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:6C516CB3-B902-4A1D-97D4-AA9EA5384A60@.microsoft.com...[vbcol=seagreen]
> Hi Brian
> I am not at all sure how backing up to a NULL device will test anything?
> You may want to use a small database or filegroup to do your tests. You
> will
> not know that the backup has really worked unless you restore it!!!
> John
> "Brian Brian" wrote:
>|||Assuming you only want to test the syntax of your backup commands:
BACKUP DATABASE pubs TO DISK = 'nul'
The data is written to the "bit bucket".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
news:C6F64561-F058-425D-9B82-C7FBD7D9B6B1@.microsoft.com...
> --
> Brian

command to backup database to null device for testing purpose? tha

command to backup database to null device for testing purpose? thaHi Brian
I am not at all sure how backing up to a NULL device will test anything?
You may want to use a small database or filegroup to do your tests. You will
not know that the backup has really worked unless you restore it!!!
John
"Brian Brian" wrote:

> --
> Brian
|||Try AgileInfoSoftware DataStudio (http://www.agileinfollc.com) for moving
database to another database.
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:6C516CB3-B902-4A1D-97D4-AA9EA5384A60@.microsoft.com...[vbcol=seagreen]
> Hi Brian
> I am not at all sure how backing up to a NULL device will test anything?
> You may want to use a small database or filegroup to do your tests. You
> will
> not know that the backup has really worked unless you restore it!!!
> John
> "Brian Brian" wrote:
|||Assuming you only want to test the syntax of your backup commands:
BACKUP DATABASE pubs TO DISK = 'nul'
The data is written to the "bit bucket".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
news:C6F64561-F058-425D-9B82-C7FBD7D9B6B1@.microsoft.com...
> --
> Brian

command to backup database to null device for testing purpose? tha

--
BrianHi Brian
I am not at all sure how backing up to a NULL device will test anything?
You may want to use a small database or filegroup to do your tests. You will
not know that the backup has really worked unless you restore it!!!
John
"Brian Brian" wrote:
> --
> Brian|||Try AgileInfoSoftware DataStudio (http://www.agileinfollc.com) for moving
database to another database.
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:6C516CB3-B902-4A1D-97D4-AA9EA5384A60@.microsoft.com...
> Hi Brian
> I am not at all sure how backing up to a NULL device will test anything?
> You may want to use a small database or filegroup to do your tests. You
> will
> not know that the backup has really worked unless you restore it!!!
> John
> "Brian Brian" wrote:
>> --
>> Brian|||Assuming you only want to test the syntax of your backup commands:
BACKUP DATABASE pubs TO DISK = 'nul'
The data is written to the "bit bucket".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
news:C6F64561-F058-425D-9B82-C7FBD7D9B6B1@.microsoft.com...
> --
> Brian|||Thanks, that is what I am looking for.
--
Brian
"Tibor Karaszi" wrote:
> Assuming you only want to test the syntax of your backup commands:
> BACKUP DATABASE pubs TO DISK = 'nul'
> The data is written to the "bit bucket".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Brian Brian" <BrianBrian@.discussions.microsoft.com> wrote in message
> news:C6F64561-F058-425D-9B82-C7FBD7D9B6B1@.microsoft.com...
> >
> > --
> > Brian
>