Is it possible to change the value of one perticular cell in Business Objects(Reports) after retriving data from Database.
Say i have retived 100 names from Databas (100 Rows),now I want to add some comment after the name in couple of cells , how to do this !!!
Thanx
Arun
Listserv Archives (BOB member since 2002-06-25)
Hello Arun,
If it is based on a value in another column you can use the IF statement.
eg.
If ( =“OVERDUE” ) Then ( + " - DEFAULTER" ) Else
Were you looking for something like this or want to manipulate it directly without any basis on any other column ?
Thanks & Regards,
Unni
Is it possible to change the value of one perticular cell in Business Objects(Reports) after retriving data from Database.
Say i have retived 100 names from Databas (100 Rows),now I want to add some
comment after the name in couple of cells , how to do this !!!
Thanx
Arun
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!):
listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================
Listserv Archives (BOB member since 2002-06-25)
Dear Unni,
I have the following formate .
*1.0 ASA Communicatoin ’ Queue Name
Listserv Archives (BOB member since 2002-06-25)
Hi everyone,
Can you do something similar to this on the summary row of a table? I have a master-detail report that has a summary row that shows the averages of certain columns. I wanted to add a second summary row to show the median of those columns, but since BO 4.1.3 does not have a median function, I thought I would try to manually enter the medians in their own cells. When I try what is recommended below, I get #MULTIVALUE in the cell, I guess because I am referring to a field in the table rather than something in the summary row. Does anyone have any suggestions?
Thanks,
Mike Camillone
From: K. Unnikrishnan Nair [SMTP:K.Unnikrishnan.Nair@ERCGROUP.COM] Sent: Thursday, March 09, 2000 11:42 AM
Hello Arun,
If it is based on a value in another column you can use the IF statement.
eg.
If ( =“OVERDUE” ) Then ( + " - DEFAULTER" ) Else
Were you looking for something like this or want to manipulate it directly without any basis on any other column ?
Thanks & Regards,
Unni
Is it possible to change the value of one perticular cell in Business Objects(Reports) after retriving data from Database.
Say i have retived 100 names from Databas (100 Rows),now I want to add some
comment after the name in couple of cells , how to do this !!!
Thanx
Arun
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!):
listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!): listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Listserv Archives (BOB member since 2002-06-25)
In a message dated 00-03-09 11:29:42 EST, you write:
Is it possible to change the value of one perticular cell in Business
Objects(Reports) after retriving data from Database.
Say i have retived 100 names from Databas (100 Rows),now I want to add some comment after the name in couple of cells , how to do this !!!
The short answer is, “No, you cannot do this.”
The medium answer is, “Well, maybe, but not without some work.”
The long answer is:
Unlike a spreadsheet, BusObj does not have individual cells in a block. Each cell is a repeated value for each row in the result set. This is best demonstrated by putting your report into “Structure” mode. (Use View + Structure from the menu).
Now, how many cells are there? Only one! So, how can you put different values into a single cell? Again, the short answer is, “You cannot.” That explains the #MULTIVALUE error; you are trying to put too many values into a single cell.
Having said that, there are some tricks. Someone has already suggested using an “If” statement. In other words, “If Then <display some value”. That is a possibility, but it may require extensive coding if you have a lot of different values to check.
Another possibility is to use an Alerter. An Alerter can alter the contents of a cell based on other values in the row. However, it too could require a lot of work for lots of different values.
The best answer is to provide the extra value in the database. Create an object for that data, and add the object to your query. Now you have an object that refers to a column that contains the data you need to display, which means no more work on the report.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)
Hello Arun,
Try this in its cell,
=If (substr(, pos(,“(”), pos(,“)”) - pos(,“(”) + 1 ) = “(3)” ) Then “(ArunChawra)” Else If (substr(, pos(,“(”), pos(,“)”) - pos(,“(”) + 1 ) = “(4)” )Then “(Four)” Else
Thanks & Regards,
Unni
Dear Unni,
I have the following formate .
*1.0 ASA Communicatoin ’ Queue Name
SSN Created Datein DateDue
… … … …
… … … …
*2.0 SA Research (3) ’ Queue Name
SSN Created Datein DateDue
… … … …
… … … …
I want to Replace (3) with some name, (In some of the queue there are no
numbers (i.e (1))
Thanx
Arun
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
Web archives (24 hrs. a day now!):
listserv.aol.com/archives/busob-l.html
OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
====================================
Listserv Archives (BOB member since 2002-06-25)