How to insert multiple values in a single column

I need to display output as shown below. In Col1, Col2 and Col3 I want to insert values from subqueries. But do not want to use sub-reports... is there any alternative to subqueries.

In Col1, Col2 and Col3 there can be any number of values.

Company

Bank Col1 Col2 Col3
AstroTech ICICI
1
2
3
5
3
4
MindTree HDFC  
5
4
8
         

Pardeep Bogra (MCA, MCAD)
Systems Develper
1
PardeepBogra
10/19/2007 7:09:57 AM
asp.net.ssrs 4514 articles. 1 followers. Follow

6 Replies
1311 Views

Similar Articles

[PageSpeed] 52
Get it on Google Play
Get it on Apple App Store

 why don't you want to use a sub-report?

0
dhassen
10/19/2007 11:15:49 AM

It takes very long time, because i have 17 columns in the report.. its not fisible to insert 15 sub-reports


Pardeep Bogra (MCA, MCAD)
Systems Develper
0
PardeepBogra
10/19/2007 12:09:14 PM

 Ah I understand, and agree. Not sure how else to implement this though...could you insert another table into your main table's cells?

0
dhassen
10/19/2007 12:59:30 PM

Not resolved yet... any ideas...


Pardeep Bogra (MCA, MCAD)
Systems Develper
0
PardeepBogra
12/10/2007 12:33:25 PM

One idea would be to build your data using a view.  Capture the main data (Company, Bank, ID) and then capture each columns’ data (based on the ID in first query).  Select from the view.

 

I think your data would be more like:

 

ID   Company   Bank   ManagerNames    BranchOffices    TopSalesNames

1  CompanyA   BankOne  Jerry, Ted, Lisa    Omaha, Chicago    Fred, Mary

2  CompanyB   BankTwo  Paul                    Lincoln, Springfield, Florence  William, John

 

Not sure if this meets your needs.  You may be able to format the multi-value rows once in the report.   Hope this helps.


- Corwin
(My Blog - www.ballhead.com/corwin)
0
Corwin
12/10/2007 6:42:27 PM

thanks... I will try this


Pardeep Bogra (MCA, MCAD)
Systems Develper
0
PardeepBogra
12/13/2007 2:27:37 PM
Reply:

Web resources about - How to insert multiple values in a single column - asp.net.ssrs

Multiple sequence alignment - Wikipedia, the free encyclopedia
A multiple sequence alignment (MSA) is a sequence alignment of three or more biological sequences , generally protein , DNA , or RNA . In many ...

Queensland news: Bus rollover in Cannonvale leaves multiple passengers in critical condition - The Courier-Mail ...
A TEENAGER is dead, one person has lost a limb and others have suffered head injuries after a bus rolled on Queensland’s Whitsunday Coast.

Women Share How They Reach Multiple Orgasms In New Study 5
... triple) the pleasure. For some, it's just a notion and for others it's part of their sex lives, but research suggests anyone can achieve multiple ...

1Password’s new family plan lets multiple users easily share passwords
... out 9to5Mac for more breaking coverage of Apps , app , and 1Password . What do you think? Discuss "1Password’s new family plan lets multiple ...

Multiple Account Support for Facebook Messenger; SMS Option Testing
Facebook Messenger jumped aboard the multiple-account-support bandwagon, and the social network is testing an SMS option for the Android version ...

It’s official: Instagram for iOS now supports multiple account switching
Instagram has officially announced that it has begun rolling out support for switching between multiple accounts in its iOS app, without requiring ...

Ole Miss Football Reportedly Cited for Multiple Violations by NCAA
Bleacher Report Ole Miss Football Reportedly Cited for Multiple Violations by NCAA Bleacher Report The NCAA charged Ole Miss with a slew of ...

According to multiple reports, the Orlando Magic have traded Tobias Harris to the Detroit Pistons in
According to multiple reports , the Orlando Magic have traded Tobias Harris to the Detroit Pistons in exchange for Brandon Jennings and Ersan ...

Facebook is testing SMS, multiple accounts in Messenger
Facebook has slowly beefed up its Messenger offering over the past year, with not only the ability to send payments and hail an Uber ride, but ...

Instagram App Now Allows Multiple Accounts. Here's How To Do It
... its most eagerly anticipated features. Much to the delight of bloggers and business users everywhere, it’s now possible to switch between multiple ...

Resources last updated: 2/17/2016 5:43:47 PM