Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Translating from Reorting Services to BIRT
Translating from Reorting Services to BIRT [message #760265] Thu, 01 December 2011 17:39 Go to next message
nlajka - is currently offline nlajka -
Messages: 61
Registered: April 2011
Member
Hello,

I am trying to create a report that would have functionality of the report that we have created in Microsoft Reporting Services.

One of the fields in the report has this code in it:

=IIF(Parameters!strCurr.Value=First(Fields!csymbol.Value, "dsHeading"),"",
First(Parameters!strCurr.Value, "dsHeading") & " " &
Format(Fields!val_accepted_converted.Value,"#,##0.00"))


csymbol is coming from data set dsHeading and val_accepted_converted is coming from anoher data set.

How to get the same value in the field in BIRT?

Thanks.
Re: Translating from Reorting Services to BIRT [message #760393 is a reply to message #760265] Fri, 02 December 2011 09:32 Go to previous messageGo to next message
nlajka - is currently offline nlajka -
Messages: 61
Registered: April 2011
Member
More than 200 views and not a single hint, idea or info?
Re: Translating from Reorting Services to BIRT [message #760442 is a reply to message #760393] Fri, 02 December 2011 11:46 Go to previous messageGo to next message
donino donino is currently offline donino donino
Messages: 162
Registered: July 2011
Senior Member
Hi,

I suppose you can manage that by creating a joined dataset between dsHeading and val_accepted_converted's dataset.

You may also consider using expression
params["strCurr"].displayText

[Updated on: Fri, 02 December 2011 11:51]

Report message to a moderator

Re: Translating from Reorting Services to BIRT [message #763203 is a reply to message #760442] Fri, 09 December 2011 10:49 Go to previous messageGo to next message
nlajka - is currently offline nlajka -
Messages: 61
Registered: April 2011
Member
Thanks dpardon for your info.

What exactly I am trying to do is shown in the picture.
If the value from the parameter (params["strCurr"].value) is the same like in the field (row["csymboldsHeading"].value) than leave the data field empty.
But, if the value from the parameter (params["strCurr"].value) is the same like in the field (row["csymboldsHeading"].value) than show the data from two fields formated together (row["csymboldsHeading"].value & " " & dataSetRow["dsActivity2::val accepted converted"].value). So the compare is done with a field in one data set and after evaluation I want either to show no data, leave it blank, or show data from another data set.

I know of Joined Data Sets, but I can't join these two sets since data is quite different.

Is this possible? Some other way to do it?

Thanks!

P.S. Picture shows the same MAP twice, so you can see the full text of the "Then display following value:" box.
  • Attachment: map.JPG
    (Size: 74.35KB, Downloaded 80 times)

[Updated on: Fri, 09 December 2011 10:51]

Report message to a moderator

Re: Translating from Reorting Services to BIRT [message #764600 is a reply to message #763203] Mon, 12 December 2011 14:00 Go to previous messageGo to next message
nlajka - is currently offline nlajka -
Messages: 61
Registered: April 2011
Member

What am I doing wrong? Can somebody point me to the right direction? I don't have experience in Java Script, but I am looking at scripting for a data object and trying to make it look like this but I am not sure if scripting can (if not, please let me know what can be used in order to have this valuation and presentation possible):

if(Parameters!Name.Value = Field1FromTable1.Value, DataSet1)
Show nothing,
ELSE Show ("Field1FromTable1.Value, DataSet2" + "Field2FromTable1.Value, DataSet2")

Your help is much appreciated.
Re: Translating from Reorting Services to BIRT [message #764706 is a reply to message #764600] Mon, 12 December 2011 17:50 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I am not 100% on what you are looking for. Look at the expression on
the attached example for the data item with the red background. Is this
what you are looking for?

Jason

On 12/12/2011 9:00 AM, nlajka wrote:
>
> What am I doing wrong? Can somebody point me to the right direction? I
> don't have experience in Java Script, but I am looking at scripting for
> a data object and trying to make it look like this but I am not sure if
> scripting can (if not, please let me know what can be used in order to
> have this valuation and presentation possible):
>
> if(Parameters!Name.Value = Field1FromTable1.Value, DataSet1)
> Show nothing,
> ELSE Show ("Field1FromTable1.Value, DataSet2" + "Field2FromTable1.Value,
> DataSet2")
>
> Your help is much appreciated.
Re: Translating from Reorting Services to BIRT [message #765613 is a reply to message #764706] Wed, 14 December 2011 11:37 Go to previous message
nlajka - is currently offline nlajka -
Messages: 61
Registered: April 2011
Member
It wasn't exactly what I needed, but it pointed me to the right direction.

Thank you Jason once again!
Previous Topic:Problem with date params
Next Topic:BIRT development
Goto Forum:
  


Current Time: Thu Oct 23 06:53:27 GMT 2014

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

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