Multi Page Report Help

Hello,

I need to create a report that will use a dataset as its datasource and display each row in that dataset in its own page. For example, if the dataset returned three rows, then the report would be three pages long with each page only displaying the data from one row. Any help would be greatly appreciated!!Right click the Details section, go to Section Expert and click 'New Page After'.sql

Mult Select in SQL Reporting Parameters

Is there anyway to have a parameter that can be a multi select. Example
something that will allow multiple states to be selected?Sql Server 2000 Reporting Services does not directly support this
functionality. It is on our wish list for inclusion in a future release.
However there is an solution to this post on the GotDotNet.com web site:
http://www.gotdotnet.com/Community/Resources/Default.aspx?AFXPath=/Resource%5b@.ResourceId='2E882C0A-8D2B-4EAD-81BE-8E66C0941A18'%5d
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:u4DuLTjqEHA.2612@.TK2MSFTNGP15.phx.gbl...
> Is there anyway to have a parameter that can be a multi select. Example
> something that will allow multiple states to be selected?
>|||Here's a similar thread:
http://groups.google.com/groups?hl=en&lr=&threadm=eW7vUsFsEHA.2952%40TK2MSFTNGP10.phx.gbl&rnum=9&prev=/groups%3Fq%3Djerrynixon%2540gmail.com%26num%3D100%26hl%3Den%26lr%3D%26group%3Dmicrosoft.public.sqlserver.reportingsvcs%26scoring%3Dd
Here's another similar thread:
http://groups.google.com/groups?hl=en&lr=&threadm=F2B6BAF3-1667-4E1F-8A1A-54D0FC08DEA6%40microsoft.com&rnum=7&prev=/groups%3Fhl%3Den%26lr%3D%26scoring%3Dd%26q%3Dmulti%2Bselect%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.reportingsvcs
One suggestion: if the parameter only needs TWO you could just have
two parameters that prompt the user for the same information. For
example, if you needed to select two months, you could have two month
parameters.
If you do not know the number to be selected - a custom interface is
the best solution - a free text with "1,2,3,4,5" entered by the user
is fine, though prone to error from human entry issues.
BR//Jerrysql

MS-SQL Related

Hello,

What is uniqueidentifier as a data type?

Also what is the data type for setting unique STRINGS ((nchar,
nvarchar), for example to be used for emails and user names in a user
registration system).

SQL Server does not allow me set primary keys for columns where data
types are not INT.

Thanks in advance.A uniqueidentifier is equivelent to a GUID, if you've ever used it in
any other programming language. As for SQL Server not allowing you to
use other data types than int, you must be misinterpreting the errror
message. What error message do you see?

Dot Net Daddy wrote:

Quote:

Originally Posted by

Hello,
>
What is uniqueidentifier as a data type?
>
Also what is the data type for setting unique STRINGS ((nchar,
nvarchar), for example to be used for emails and user names in a user
registration system).
>
SQL Server does not allow me set primary keys for columns where data
types are not INT.
>
Thanks in advance.

|||Dot Net Daddy (cagriandac@.gmail.com) writes:

Quote:

Originally Posted by

What is uniqueidentifier as a data type?

A uniqueidentifier is a 128-bit value, which is generated in such a way
that it is guaranteed to be unique in the whole universe. (Well, at least
this planet.) They are not specific to SQL Server, but Windows has them
all over the place, but calls them GUIDs.

Quote:

Originally Posted by

Also what is the data type for setting unique STRINGS ((nchar,
nvarchar), for example to be used for emails and user names in a user
registration system).
>
SQL Server does not allow me set primary keys for columns where data
types are not INT.

Huh? You can use almost any data type for primary keys. Since a primary
key is an index, the total key size may not execeed 900 bytes, so you
cannot use things like text or nvarchar(MAX).

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Great. It has done it. I was using nvarchar(MAX) as you told.

Now it is ok.

Thank you very much for your help guys.

Erland Sommarskog wrote:

Quote:

Originally Posted by

Dot Net Daddy (cagriandac@.gmail.com) writes:

Quote:

Originally Posted by

What is uniqueidentifier as a data type?

>
A uniqueidentifier is a 128-bit value, which is generated in such a way
that it is guaranteed to be unique in the whole universe. (Well, at least
this planet.) They are not specific to SQL Server, but Windows has them
all over the place, but calls them GUIDs.
>

Quote:

Originally Posted by

Also what is the data type for setting unique STRINGS ((nchar,
nvarchar), for example to be used for emails and user names in a user
registration system).

SQL Server does not allow me set primary keys for columns where data
types are not INT.

>
Huh? You can use almost any data type for primary keys. Since a primary
key is an index, the total key size may not execeed 900 bytes, so you
cannot use things like text or nvarchar(MAX).
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx