sql server reporting services: Snake columns -- sql server reporting services

You're in the

sql server reporting services

group:

Snake columns

drchips NO[at]SPAM nospam.nospam
2/9/2006 8:25:32 PM

sql server reporting services:

I have a table with three columns and I would like to snake all three
columns. Anyone know how to snake a table on a page?

RE: Snake columns

t-weilu NO[at]SPAM online.microsoft.com
2/10/2006 5:15:51 AM

Hi drchips,
Welcome to use MSDN Managed Newsgroup Support.

From your description, my understanding of this issue is: You wan to snake
the column in a table on a report. If i misunderstood your concern, please
feel free to point it out.

Unfortunately, you can not snake a column in table.

You can use a Multi-column Reports, but to view multi-column reports you
must use one the these renderers: Print Preview, PDF, or TIFF.
Preview, HTML, and Excel do not support multi-column rendering.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/ht
m/rcr_creating_layout_v1_4uwj.asp

Hope this will be helpful.
Thank you for your patience and cooperation. If there are further questions
on the issue, please feel free to let us know. Have a great day!

Sincerely yours,

Wei Lu
Microsoft Online Partner Support
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Snake columns

drchips NO[at]SPAM nospam.nospam
2/10/2006 9:44:04 AM

I saw your link in help before I wrote this - but don't understand what it
is saying. Maybe if they offered a couple step by steps - I could hang my
hat on something.

I'm very familiar with SQL Reports and have written over a hundred reports
using it including matrices, graphs etc. Somehow - I'm missing what they
are saying here and there's very little on the web about it. (Probably
because it's so easy - there's nothing to say.)

[quoted text, click to view]

Re: Snake columns

drchips NO[at]SPAM nospam.nospam
2/10/2006 5:30:14 PM

Nevermind - figured it out again.

Thanks.

[quoted text, click to view]

Re: Snake columns

drchips NO[at]SPAM nospam.nospam
2/10/2006 6:15:14 PM

I've got that working. I've set my page to three inches high - and the
column widths equal to a couple inches. It renders perfectly.

I drop it as a sub report onto another report and now - my three inch high
formatting is gone - it renders out as a single column and it pushes out
onto another page. (I've read the previous posts where it has to be rendered
to something other than HTML)

I was trying to contain it within something where I could turn the "CanGrow"
property off - but couldn't find anything.

Any suggestions?

Thanks,

David

[quoted text, click to view]

Re: Snake columns

t-weilu NO[at]SPAM online.microsoft.com
2/13/2006 12:00:00 AM

Hi David,

Thanks for your update.

By design, the only object which can contain a subreport is Rectangle, but
it does not have CanGrow property.

The render will expand the subreport to fit the report height.

If you want to present something on eachpage, i think the best way is to
put it in the Page Head or Page Footer.

Thank you for your patience and cooperation. I appreciate your
understanding on this.

Sincerely yours,

Wei Lu
Microsoft Online Partner Support
======================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Snake columns

drchips NO[at]SPAM nospam.nospam
2/13/2006 12:00:00 AM

Oh - I didn't realize this was a known issue. I have a list of indications
I'm trying to print. I need
this at the bottom of the patient's one page report.

I put the sub report on the page footer as you suggested. SR doesn't like
data regions or sub reports in there.

Has anyone been able to pull this off?

Is there a fix on the way? Will it fix the old version of SQL Reports
because they are not going to be able to update our SQL server till some of
our vendors update their SQL.

[quoted text, click to view]

Re: Snake columns

t-weilu NO[at]SPAM online.microsoft.com
2/14/2006 12:00:00 AM

Hi David,

Thanks for the update.

Unfortunately, SQL Server Reporting Services does not propagate any
sub-report page
info (columns, margins, page size) to the parent. For the master report the
sub-report is just another report item. I have added your comments to our
feature wish list.

For now, If it has much business impact on you, I recommend that you open
a Support incident
with Microsoft Customer Service and Support (CSS) so that a dedicated
Support Professional can work with you in a more timely and efficient
manner. If you need any help in this regard, please let me know.

For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>

If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.

If there are further questions on the issue, please feel free to let us
know. Have a great day!

Sincerely yours,

Wei Lu
Microsoft Online Partner Support
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn