BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

 
Lead By Knowing (Opens a new window)  

General Notice: No events within the next 45 days.

Cell Merge in WebI Report


 
Search this topic... | Search WebIntelligence XI... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Author Message
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 539
Location: USA



PostPosted: Tue Apr 11, 2006 6:24 pm 
Post subject: Cell Merge in WebI Report

Hi,
How to merge two cell (more than two cell) in one cell in WebI Xi Report?
Actually I would like to Merge 3 cell to one cell.
Back to top
mlaan
Forum Member
Forum Member



Joined: 24 Feb 2006

Posts: 11



PostPosted: Wed Apr 12, 2006 6:45 am 
Post subject: Re: Cell Merge in WebI Report

Select both cells (click - ctrl/click)
right mouse click
merge cells
Back to top
chris_c
Principal Member
Principal Member



Joined: 10 Jan 2006

Posts: 272
Location: Milwaukee WI


flag
PostPosted: Wed Apr 12, 2006 8:26 am 
Post subject: Re: Cell Merge in WebI Report

COOL! icon_cool.gif

I have been wishing for that one for years!!!!

Small improvement but much needed.
Back to top
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 539
Location: USA



PostPosted: Wed Apr 12, 2006 8:52 pm 
Post subject: Re: Cell Merge in WebI Report

I tried as you said but There is no option like Merge Cell.
Back to top
tkdrocks
Principal Member
Principal Member



Joined: 09 Jun 2003

Posts: 371


flag
PostPosted: Wed Apr 12, 2006 8:59 pm 
Post subject: Re: Cell Merge in WebI Report

Are you on Webi XI R2?
_________________
SAP BI 4.0 SP04 FP3 Patch (are you kidding me?);

Crystal 2011; 2008; XI
Data Services
Windows 2008
Oracle 10G& 11G/SQL Server 2005/2008
Back to top
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 539
Location: USA



PostPosted: Wed Apr 12, 2006 10:06 pm 
Post subject: Re: Cell Merge in WebI Report

No... R1
Back to top
tkdrocks
Principal Member
Principal Member



Joined: 09 Jun 2003

Posts: 371


flag
PostPosted: Thu Apr 13, 2006 8:17 am 
Post subject: Re: Cell Merge in WebI Report

I believe the cell merging is a feature introduced in Webi XI R2.
_________________
SAP BI 4.0 SP04 FP3 Patch (are you kidding me?);

Crystal 2011; 2008; XI
Data Services
Windows 2008
Oracle 10G& 11G/SQL Server 2005/2008
Back to top
Jeanne Mackey
Senior Member
Senior Member



Joined: 17 Oct 2002

Posts: 80
Location: Ann Arbor, MI: 23 sq. miles surrounded by reality


flag
PostPosted: Fri Apr 14, 2006 9:50 am 
Post subject: Re: Cell Merge in WebI Report

Hi all,
When I try to do the merge cell function, I get this message:

"The selected cells contain multiple values. Merging will keep the contents of the first selected cell only. Merge anyway?"

I thought the purpose of merging cells is to merge the contents. What am I missing?

Thanks,

_________________
Jeanne Mackey
University of Michigan
Back to top
tkdrocks
Principal Member
Principal Member



Joined: 09 Jun 2003

Posts: 371


flag
PostPosted: Fri Apr 14, 2006 9:58 am 
Post subject: Re: Cell Merge in WebI Report

Jeanne Mackey wrote:
Hi all,
When I try to do the merge cell function, I get this message:

"The selected cells contain multiple values. Merging will keep the contents of the first selected cell only. Merge anyway?"

I thought the purpose of merging cells is to merge the contents. What am I missing?

Thanks,


I think this is just a CYA warning. I do not think you are missing anything.

_________________
SAP BI 4.0 SP04 FP3 Patch (are you kidding me?);

Crystal 2011; 2008; XI
Data Services
Windows 2008
Oracle 10G& 11G/SQL Server 2005/2008
Back to top
Jeanne Mackey
Senior Member
Senior Member



Joined: 17 Oct 2002

Posts: 80
Location: Ann Arbor, MI: 23 sq. miles surrounded by reality


flag
PostPosted: Fri Apr 14, 2006 10:01 am 
Post subject: Re: Cell Merge in WebI Report

tkdrocks wrote:


I think this is just a CYA warning. I do not think you are missing anything.


But when I proceed, the merged cell only includes the content from the first cell and loses the 2nd. So I don't get the point of merging.

Thanks,

_________________
Jeanne Mackey
University of Michigan
Back to top
Dave Rathbun
Forum Advocate
Forum Advocate



Joined: 06 Jun 2002
ASUG Icon
speaker.gif*16
Posts: 21977
Location: Dallas, Texas


flag
PostPosted: Fri Apr 14, 2006 10:23 am 
Post subject: Re: Cell Merge in WebI Report

Merging cells works like it does in Excel, it allows you to take a series of cells and turn them into one cell for example titles and so on. It doesn't capture the data from cells 2 through "n", it overwrites them.
_________________
Dave's Adventures in Business Intelligence Image link

Latest Blog Posts
• 2014-08-22 Yes, Virginia, You Can Refresh One Data Provider At A Time
• 2014-07-08 Airlines Could Save Millions in Fuel Costs By Providing Everyone An iPad
• 2014-06-24 Did Florida State Win National Championship By Using Big Data?
Back to top
Jeanne Mackey
Senior Member
Senior Member



Joined: 17 Oct 2002

Posts: 80
Location: Ann Arbor, MI: 23 sq. miles surrounded by reality


flag
PostPosted: Fri Apr 14, 2006 10:31 am 
Post subject: Re: Cell Merge in WebI Report

Thanks for clarification. It's a nice feature, but not quite as nice as what I was imagining...
_________________
Jeanne Mackey
University of Michigan
Back to top
DJ06482
Forum Associate
Forum Associate



Joined: 22 Nov 2002

Posts: 961
Location: CT


flag
PostPosted: Fri Apr 14, 2006 11:55 am 
Post subject: Re: Cell Merge in WebI Report

Jeanne Mackey wrote:
Thanks for clarification. It's a nice feature, but not quite as nice as what I was imagining...

If you're looking to sum the information in two colums, you could create a variable that would look something like this:
Code:
=[object in column 1] + [object in column 2]

HTH -

DJ
Back to top
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 539
Location: USA



PostPosted: Fri Apr 14, 2006 3:27 pm 
Post subject: Re: Cell Merge in WebI Report

Hi Mackey,
Are u working in R2? Because I am unable to merge cell in R1.
Back to top
Jeanne Mackey
Senior Member
Senior Member



Joined: 17 Oct 2002

Posts: 80
Location: Ann Arbor, MI: 23 sq. miles surrounded by reality


flag
PostPosted: Mon Apr 17, 2006 6:54 am 
Post subject: Re: Cell Merge in WebI Report

MikeBO wrote:
Hi Mackey,
Are u working in R2? Because I am unable to merge cell in R1.


Hi,
Yep, I'm in R2. If you read the 4/13 comment above, you'll note that the merge cell feature was introduced in R2.

_________________
Jeanne Mackey
University of Michigan
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0508 seconds using 17 queries. (SQL 0.0030 Parse 0.0354 Other 0.0125)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo