Multiple DataSets w/multiple Lists controls

I understand I can have multiple DataSets in a single report. (Which I've
tried in a test report).
Maybe I'm missing something...but can't I use nested list controls to build
a hierarchical report?
We have
Organization -> Region -> Branch -> Office
Note that I am able to cobble up a report using nested sub reports. Is that
the way it's supposed to be done?
Kyle!Yes. Subreports is how you should do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kyle Jedrusiak" <kjedrusiak@.princetoninformation.com> wrote in message
news:eBoUqs3RGHA.5728@.tk2msftngp13.phx.gbl...
>I understand I can have multiple DataSets in a single report. (Which I've
>tried in a test report).
> Maybe I'm missing something...but can't I use nested list controls to
> build a hierarchical report?
> We have
> Organization -> Region -> Branch -> Office
> Note that I am able to cobble up a report using nested sub reports. Is
> that the way it's supposed to be done?
> Kyle!
>

Multiple Column Lists

I'm trying to create a Report with a sub report of items that needs to be
listed in multilple columns. The data is brought in through a sql query into
the sub report. The list contains anywhere between 1 and 30 items. I can
not get the list to do more than one column. I've tried setting the page
margins to limit the length of the list, but when it reaches the bottom of
the page, instead of wrapping to the second column it continues the list on
another page. Each column is set to 1.95 inches with a .1 inch spacing and
the page length is set to 1.5 inches and width of 4 inches. I've tried
varying the page sizes and nothing seems to work. Any suggestions?In the layout of your subreport, pull in a Table form, then set your fields
in the columns that you want them in. This should format your multiple
columns.
Catadmin
--
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
"rb69" wrote:
> I'm trying to create a Report with a sub report of items that needs to be
> listed in multilple columns. The data is brought in through a sql query into
> the sub report. The list contains anywhere between 1 and 30 items. I can
> not get the list to do more than one column. I've tried setting the page
> margins to limit the length of the list, but when it reaches the bottom of
> the page, instead of wrapping to the second column it continues the list on
> another page. Each column is set to 1.95 inches with a .1 inch spacing and
> the page length is set to 1.5 inches and width of 4 inches. I've tried
> varying the page sizes and nothing seems to work. Any suggestions?|||Ok,the multiple columns is just one field being listed in both columns. It
needs to wrap between columns. If I am using a table, can I set two columns
to display half the data in the first column and then the other half in the
second column? i.e. I have a list of 30 different amenities associated with
an apartment and I need it to display the first 15 in the first column then
the last 15 in the second column, but depending on the apartment the
amenities range between 0 & 30, each apartment is different, so the length of
the list varies. I can do it in Access by setting the columns to two and
then placing a list box in the first column of a subreport. It automatically
wraps the list to the second column. But it doesn't work in SQL Server
Reports although according to every manual I've gotten my hands on it should.
"Catadmin" wrote:
> In the layout of your subreport, pull in a Table form, then set your fields
> in the columns that you want them in. This should format your multiple
> columns.
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
>
> "rb69" wrote:
> > I'm trying to create a Report with a sub report of items that needs to be
> > listed in multilple columns. The data is brought in through a sql query into
> > the sub report. The list contains anywhere between 1 and 30 items. I can
> > not get the list to do more than one column. I've tried setting the page
> > margins to limit the length of the list, but when it reaches the bottom of
> > the page, instead of wrapping to the second column it continues the list on
> > another page. Each column is set to 1.95 inches with a .1 inch spacing and
> > the page length is set to 1.5 inches and width of 4 inches. I've tried
> > varying the page sizes and nothing seems to work. Any suggestions?|||The only thing I can think of to do is to merge the cells of the columns,
like in Excel. Given your description of your issue, though, I'm not sure if
that will work for you or not.
Unfortunately, SQL RS is picky about the way it expands a field for more
details. Because the fields work like they do in Excel, the auto-increase
feature will increase the field height, not width, and it won't go over into
the next column unless you merge the cells. The only other option I can
think of is a table within a table so that you can adjust the columns for
your amenities independently of the columns in the outside table.
Catadmin
"RB69" wrote:
> Ok,the multiple columns is just one field being listed in both columns. It
> needs to wrap between columns. If I am using a table, can I set two columns
> to display half the data in the first column and then the other half in the
> second column? i.e. I have a list of 30 different amenities associated with
> an apartment and I need it to display the first 15 in the first column then
> the last 15 in the second column, but depending on the apartment the
> amenities range between 0 & 30, each apartment is different, so the length of
> the list varies. I can do it in Access by setting the columns to two and
> then placing a list box in the first column of a subreport. It automatically
> wraps the list to the second column. But it doesn't work in SQL Server
> Reports although according to every manual I've gotten my hands on it should.
> "Catadmin" wrote:
> > In the layout of your subreport, pull in a Table form, then set your fields
> > in the columns that you want them in. This should format your multiple
> > columns.
> >
> > Catadmin
> > --
> > MCDBA, MCSA
> > Random Thoughts: If a person is Microsoft Certified, does that mean that
> > Microsoft pays the bills for the funny white jackets that tie in the back?
> > @.=)
> >
> >
> > "rb69" wrote:
> >
> > > I'm trying to create a Report with a sub report of items that needs to be
> > > listed in multilple columns. The data is brought in through a sql query into
> > > the sub report. The list contains anywhere between 1 and 30 items. I can
> > > not get the list to do more than one column. I've tried setting the page
> > > margins to limit the length of the list, but when it reaches the bottom of
> > > the page, instead of wrapping to the second column it continues the list on
> > > another page. Each column is set to 1.95 inches with a .1 inch spacing and
> > > the page length is set to 1.5 inches and width of 4 inches. I've tried
> > > varying the page sizes and nothing seems to work. Any suggestions?

Multiple character separation

Here's my situation, I have a database of stock trades that I need to separate into two lists. one containing trades in stocks that have 4 letters in thier symbols, and the other which has any trades in symbols that have 1,2,or 3 symbols.

I cant seem to figure this one out, can anyone offer any help?Can you give an example of what is stored in your database and what you want the output to be ?|||select * from trade_table where datalength(cast(stock_symbol as varchar(4))) = 4

select * from trade_table where datalength(cast(stock_symbol as varchar(4))) < 4|||thanks, that looks to be exactly what I needed.

-Chamber