row too long when exporting to PDF

if I have a table with 3 rows and 3 columns and the columns are wide so that
2 columns just fit on one page.By default reporting server, when exporting to
PDF, puts first 3 rows and 2 columns on one page and last column for all the
rows on second
first page:
header1 header2
1row 1col 1row 2 col
2row 1 col 2row 2 col
second page:
header 3
1 row 3 col
2 row 3 col
Is it possible to do so that it splits the data for all rows separately:
header 1 header 2
1 row 1 col 1 row 2 col
header 3
1 row 3 col
header 1 header 2
2 row 1 col 2 row 2 col
header 3
2 row 3 colOn May 16, 9:49 am, pardik <par...@.discussions.microsoft.com> wrote:
> if I have a table with 3 rows and 3 columns and the columns are wide so that
> 2 columns just fit on one page.By default reporting server, when exporting to
> PDF, puts first 3 rows and 2 columns on one page and last column for all the
> rows on second
> first page:
> header1 header2
> 1row 1col 1row 2 col
> 2row 1 col 2row 2 col
> second page:
> header 3
> 1 row 3 col
> 2 row 3 col
> Is it possible to do so that it splits the data for all rows separately:
> header 1 header 2
> 1 row 1 col 1 row 2 col
> header 3
> 1 row 3 col
> header 1 header 2
> 2 row 1 col 2 row 2 col
> header 3
> 2 row 3 col
You might try grouping on a report item at the row level. Then set
'Page break at end' as part of the grouping. If this does not work,
you could try using a matrix control and rearranging your dataset
(query/stored procedure) output to format the matrix in the above
format. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Row level Locking

To All:
I like to know if Row-level Locking is set by default. For example ... if
thousands of users regularly update a table, is it gauranteed that Sql
Server does a row level lock or something needs to be defined?
Thanks,
TunjiLocking models are dynamic in SQL Server. No there is no guarantee a row
lock will be chosen. SQL will do what it thinks is best according to a large
body of information that is documented in BOL amonth other places.
Do you have a specific problem? Or just trying to understand the locking
model better?
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Tunji" <Tunj@.hotmail.com> wrote in message
news:efYBulfAEHA.2212@.TK2MSFTNGP10.phx.gbl...
> To All:
> I like to know if Row-level Locking is set by default. For example ... if
> thousands of users regularly update a table, is it gauranteed that Sql
> Server does a row level lock or something needs to be defined?
> Thanks,
> Tunji
>|||Brain,
Yes, i just like to know the effect and result of having thousands of users
updating a particular table before putting it into test and production.
Most importantly how locks are handled in this kind of situation.
Thanks for your contribution to the Swl Server world and great Articles in
Sql Server Magazine.
Tunji
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:%23b%23wsvfAEHA.3316@.TK2MSFTNGP11.phx.gbl...
> Locking models are dynamic in SQL Server. No there is no guarantee a row
> lock will be chosen. SQL will do what it thinks is best according to a
large
> body of information that is documented in BOL amonth other places.
> Do you have a specific problem? Or just trying to understand the locking
> model better?
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Tunji" <Tunj@.hotmail.com> wrote in message
> news:efYBulfAEHA.2212@.TK2MSFTNGP10.phx.gbl...
if
>

Row level Locking

To All:
I like to know if Row-level Locking is set by default. For example ... if
thousands of users regularly update a table, is it gauranteed that Sql
Server does a row level lock or something needs to be defined?
Thanks,
TunjiLocking models are dynamic in SQL Server. No there is no guarantee a row
lock will be chosen. SQL will do what it thinks is best according to a large
body of information that is documented in BOL amonth other places.
Do you have a specific problem? Or just trying to understand the locking
model better?
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Tunji" <Tunj@.hotmail.com> wrote in message
news:efYBulfAEHA.2212@.TK2MSFTNGP10.phx.gbl...
> To All:
> I like to know if Row-level Locking is set by default. For example ... if
> thousands of users regularly update a table, is it gauranteed that Sql
> Server does a row level lock or something needs to be defined?
> Thanks,
> Tunji
>|||Brain,
Yes, i just like to know the effect and result of having thousands of users
updating a particular table before putting it into test and production.
Most importantly how locks are handled in this kind of situation.
Thanks for your contribution to the Swl Server world and great Articles in
Sql Server Magazine.
Tunji
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:%23b%23wsvfAEHA.3316@.TK2MSFTNGP11.phx.gbl...
> Locking models are dynamic in SQL Server. No there is no guarantee a row
> lock will be chosen. SQL will do what it thinks is best according to a
large
> body of information that is documented in BOL amonth other places.
> Do you have a specific problem? Or just trying to understand the locking
> model better?
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Tunji" <Tunj@.hotmail.com> wrote in message
> news:efYBulfAEHA.2212@.TK2MSFTNGP10.phx.gbl...
> > To All:
> >
> > I like to know if Row-level Locking is set by default. For example ...
if
> > thousands of users regularly update a table, is it gauranteed that Sql
> > Server does a row level lock or something needs to be defined?
> >
> > Thanks,
> >
> > Tunji
> >
> >
>

Rotate report

I have a report that I'd like to display across the page (as opposed to down
as is default). Can someone tell me if there's any way to rotate a table?
Thanks in advance,
DuncLet me know if you've found a way to do this. I've looked everywhere and
can't find a solution.
Crystal Reports does this nicely.
"Dunc" wrote:
> I have a report that I'd like to display across the page (as opposed to down
> as is default). Can someone tell me if there's any way to rotate a table?
> Thanks in advance,
> Dunc
>
>