Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Make everything in a dataset only show one letter?
Make everything in a dataset only show one letter? [message #1708858] Mon, 21 September 2015 23:54 Go to next message
Megg Gawat is currently offline Megg GawatFriend
Messages: 6
Registered: September 2015
Junior Member
So there's this dataset with a bunch of values. How do you make it so that a select of them only show one letter, instead of having to make individual computed columns for each value?

Example:
Dataset 1
Name | Value
Test | True
Blah | False

Imagine there's like 20x as much information. How do you only get T or F for each of them, without having to make a computed column for each value?

Report message to a moderator

Re: Make everything in a dataset only show one letter? [message #1708918 is a reply to message #1708858] Tue, 22 September 2015 13:11 Go to previous messageGo to next message
Megg Gawat is currently offline Megg GawatFriend
Messages: 6
Registered: September 2015
Junior Member
Another solution besides computed columns is to use dynamic text, make it something like this:

information = row["test"]
information.substr(0,1)


That might be slightly faster than creating computed columns for each data! But it still takes a long time. Is there a faster way?

Report message to a moderator

Re: Make everything in a dataset only show one letter? [message #1708938 is a reply to message #1708858] Tue, 22 September 2015 15:48 Go to previous messageGo to next message
Jerry Sheets is currently offline Jerry SheetsFriend
Messages: 76
Registered: July 2009
Location: Salt Lake City, UT
Member
In Oracle, I would define the query as
Select
Name,
substr(value,1,1) as Value
From ....

Report message to a moderator

Re: Make everything in a dataset only show one letter? [message #1709049 is a reply to message #1708938] Wed, 23 September 2015 14:39 Go to previous message
Megg Gawat is currently offline Megg GawatFriend
Messages: 6
Registered: September 2015
Junior Member
Oracle the software company? I have no idea what you're talking about...

How do you do it in BIRT?

Report message to a moderator

Previous Topic:Cannot generate xlsx using birt runtime version 4.4.2
Next Topic:Connecting to Oracle Database Via OJDBC Slow
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 08:38:04 GMT 2024

Powered by FUDForum. Page generated in 0.02783 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly