I have a SPROC that returns any number of vehicle options for a specific
vehicle.
I want to display the information in a multi-column fashion like this...
4speed Auto Windows Floor mats
Radio Bucket Seats Wheels
NOT like this
4speed
Auto Windows
Floor mats
Radio
Bucket Seats
Wheels
What control should I use, and how do I do it? I've tried for a while now
and can't find a solution.
Thanks in advance!
BrianHave you tried using the Table control. In your case, I think you will need
to add a second detail row.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian Cesafsky" <brian.cesafsky@.autotrackerplus.com> wrote in message
news:O0IborWuFHA.2568@.TK2MSFTNGP15.phx.gbl...
>I have a SPROC that returns any number of vehicle options for a specific
>vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> What control should I use, and how do I do it? I've tried for a while now
> and can't find a solution.
>
> Thanks in advance!
> Brian
>
>|||yes, I tried that, but I must be doing something wrong... I just get the
same option repeated... like this...
4speed
4speed
Auto Windows
Auto Windows
Floor mats
Floor mats
Radio
Radio
Bucket Seats
Bucket Seats
Wheels
Wheels
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message
news:%23$aN0fiuFHA.2920@.TK2MSFTNGP10.phx.gbl...
> Have you tried using the Table control. In your case, I think you will
> need to add a second detail row.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Brian Cesafsky" <brian.cesafsky@.autotrackerplus.com> wrote in message
> news:O0IborWuFHA.2568@.TK2MSFTNGP15.phx.gbl...
>>I have a SPROC that returns any number of vehicle options for a specific
>>vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> What control should I use, and how do I do it? I've tried for a while
>> now and can't find a solution.
>>
>> Thanks in advance!
>> Brian
>>
>
Showing posts with label vehicle. Show all posts
Showing posts with label vehicle. Show all posts
Wednesday, March 7, 2012
Multiple columns - 3rd post...
I have a SPROC that returns any number of vehicle options for a specific
vehicle.
I want to display the information in a multi-column fashion like this...
4speed Auto Windows Floor mats
Radio Bucket Seats Wheels
NOT like this
4speed
Auto Windows
Floor mats
Radio
Bucket Seats
Wheels
Somone suggested using the Table control and to add a second detail row.
I tried that, but I must be doing something wrong... I just get the
same option repeated... like this...
4speed
4speed
Auto Windows
Auto Windows
Floor mats
Floor mats
Radio
Radio
Bucket Seats
Bucket Seats
Wheels
Wheels
Thanks in advance!Have you tried using the MATRIX feature?
Is there a MAX to how many features a vehicle can have?
"Brian Cesafsky" wrote:
> I have a SPROC that returns any number of vehicle options for a specific
> vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> Somone suggested using the Table control and to add a second detail row.
> I tried that, but I must be doing something wrong... I just get the
> same option repeated... like this...
> 4speed
> 4speed
> Auto Windows
> Auto Windows
> Floor mats
> Floor mats
> Radio
> Radio
> Bucket Seats
> Bucket Seats
> Wheels
> Wheels
> Thanks in advance!
>
>|||sorry, missed that last question... no, there is no MAX
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:5A0CD99C-62EB-4CCB-AA49-8DE962085186@.microsoft.com...
> Have you tried using the MATRIX feature?
> Is there a MAX to how many features a vehicle can have?
>
> "Brian Cesafsky" wrote:
>> I have a SPROC that returns any number of vehicle options for a specific
>> vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> Somone suggested using the Table control and to add a second detail row.
>> I tried that, but I must be doing something wrong... I just get the
>> same option repeated... like this...
>> 4speed
>> 4speed
>> Auto Windows
>> Auto Windows
>> Floor mats
>> Floor mats
>> Radio
>> Radio
>> Bucket Seats
>> Bucket Seats
>> Wheels
>> Wheels
>> Thanks in advance!
>>|||I did try that... didn't work...
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:5A0CD99C-62EB-4CCB-AA49-8DE962085186@.microsoft.com...
> Have you tried using the MATRIX feature?
> Is there a MAX to how many features a vehicle can have?
>
> "Brian Cesafsky" wrote:
>> I have a SPROC that returns any number of vehicle options for a specific
>> vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> Somone suggested using the Table control and to add a second detail row.
>> I tried that, but I must be doing something wrong... I just get the
>> same option repeated... like this...
>> 4speed
>> 4speed
>> Auto Windows
>> Auto Windows
>> Floor mats
>> Floor mats
>> Radio
>> Radio
>> Bucket Seats
>> Bucket Seats
>> Wheels
>> Wheels
>> Thanks in advance!
>>|||Brian,
You could use a list and in the list arrange the textboxes however you
wanted them. You would just need to make sure you had enough boxes for the
vehicle options.
Not sure if this is the correct solution for what you need, but just another
idea.
"Brian Cesafsky" wrote:
> I have a SPROC that returns any number of vehicle options for a specific
> vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> Somone suggested using the Table control and to add a second detail row.
> I tried that, but I must be doing something wrong... I just get the
> same option repeated... like this...
> 4speed
> 4speed
> Auto Windows
> Auto Windows
> Floor mats
> Floor mats
> Radio
> Radio
> Bucket Seats
> Bucket Seats
> Wheels
> Wheels
> Thanks in advance!
>
>|||Create a three column report, with a body so short it only holds the
one text box. Similar approach as would be used for mailing labels.|||I am trying this, but what happens is that I see Column2 and column3 to the
right of the first column, I place the text box in the first column, and
what I see in the out put is the very last option from my query and that is
it.
any ideas?
Thanks again!
"Parker" <psmith@.iquest.net> wrote in message
news:1128084282.571367.232050@.o13g2000cwo.googlegroups.com...
> Create a three column report, with a body so short it only holds the
> one text box. Similar approach as would be used for mailing labels.
>|||Modify your stored proc so that it returns a concatenated string wit
a carriage return after each third entry. Then display the result i
a text box and the text will wrap. The string should something lik
this
item1 & " " & item 2 & " " & item 3 & char(13
& char(10) & item4 ...
Most lilkely you will have to use a cursor to build the string an
also do some text manipulation to force column alignment
vehicle.
I want to display the information in a multi-column fashion like this...
4speed Auto Windows Floor mats
Radio Bucket Seats Wheels
NOT like this
4speed
Auto Windows
Floor mats
Radio
Bucket Seats
Wheels
Somone suggested using the Table control and to add a second detail row.
I tried that, but I must be doing something wrong... I just get the
same option repeated... like this...
4speed
4speed
Auto Windows
Auto Windows
Floor mats
Floor mats
Radio
Radio
Bucket Seats
Bucket Seats
Wheels
Wheels
Thanks in advance!Have you tried using the MATRIX feature?
Is there a MAX to how many features a vehicle can have?
"Brian Cesafsky" wrote:
> I have a SPROC that returns any number of vehicle options for a specific
> vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> Somone suggested using the Table control and to add a second detail row.
> I tried that, but I must be doing something wrong... I just get the
> same option repeated... like this...
> 4speed
> 4speed
> Auto Windows
> Auto Windows
> Floor mats
> Floor mats
> Radio
> Radio
> Bucket Seats
> Bucket Seats
> Wheels
> Wheels
> Thanks in advance!
>
>|||sorry, missed that last question... no, there is no MAX
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:5A0CD99C-62EB-4CCB-AA49-8DE962085186@.microsoft.com...
> Have you tried using the MATRIX feature?
> Is there a MAX to how many features a vehicle can have?
>
> "Brian Cesafsky" wrote:
>> I have a SPROC that returns any number of vehicle options for a specific
>> vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> Somone suggested using the Table control and to add a second detail row.
>> I tried that, but I must be doing something wrong... I just get the
>> same option repeated... like this...
>> 4speed
>> 4speed
>> Auto Windows
>> Auto Windows
>> Floor mats
>> Floor mats
>> Radio
>> Radio
>> Bucket Seats
>> Bucket Seats
>> Wheels
>> Wheels
>> Thanks in advance!
>>|||I did try that... didn't work...
"Scott" <Scott@.discussions.microsoft.com> wrote in message
news:5A0CD99C-62EB-4CCB-AA49-8DE962085186@.microsoft.com...
> Have you tried using the MATRIX feature?
> Is there a MAX to how many features a vehicle can have?
>
> "Brian Cesafsky" wrote:
>> I have a SPROC that returns any number of vehicle options for a specific
>> vehicle.
>>
>> I want to display the information in a multi-column fashion like this...
>> 4speed Auto Windows Floor mats
>> Radio Bucket Seats Wheels
>>
>> NOT like this
>> 4speed
>> Auto Windows
>> Floor mats
>> Radio
>> Bucket Seats
>> Wheels
>>
>> Somone suggested using the Table control and to add a second detail row.
>> I tried that, but I must be doing something wrong... I just get the
>> same option repeated... like this...
>> 4speed
>> 4speed
>> Auto Windows
>> Auto Windows
>> Floor mats
>> Floor mats
>> Radio
>> Radio
>> Bucket Seats
>> Bucket Seats
>> Wheels
>> Wheels
>> Thanks in advance!
>>|||Brian,
You could use a list and in the list arrange the textboxes however you
wanted them. You would just need to make sure you had enough boxes for the
vehicle options.
Not sure if this is the correct solution for what you need, but just another
idea.
"Brian Cesafsky" wrote:
> I have a SPROC that returns any number of vehicle options for a specific
> vehicle.
>
> I want to display the information in a multi-column fashion like this...
> 4speed Auto Windows Floor mats
> Radio Bucket Seats Wheels
>
> NOT like this
> 4speed
> Auto Windows
> Floor mats
> Radio
> Bucket Seats
> Wheels
>
> Somone suggested using the Table control and to add a second detail row.
> I tried that, but I must be doing something wrong... I just get the
> same option repeated... like this...
> 4speed
> 4speed
> Auto Windows
> Auto Windows
> Floor mats
> Floor mats
> Radio
> Radio
> Bucket Seats
> Bucket Seats
> Wheels
> Wheels
> Thanks in advance!
>
>|||Create a three column report, with a body so short it only holds the
one text box. Similar approach as would be used for mailing labels.|||I am trying this, but what happens is that I see Column2 and column3 to the
right of the first column, I place the text box in the first column, and
what I see in the out put is the very last option from my query and that is
it.
any ideas?
Thanks again!
"Parker" <psmith@.iquest.net> wrote in message
news:1128084282.571367.232050@.o13g2000cwo.googlegroups.com...
> Create a three column report, with a body so short it only holds the
> one text box. Similar approach as would be used for mailing labels.
>|||Modify your stored proc so that it returns a concatenated string wit
a carriage return after each third entry. Then display the result i
a text box and the text will wrap. The string should something lik
this
item1 & " " & item 2 & " " & item 3 & char(13
& char(10) & item4 ...
Most lilkely you will have to use a cursor to build the string an
also do some text manipulation to force column alignment
Subscribe to:
Posts (Atom)