Eclipse Community Forums: BIRT » Translating from Reorting Services to BIRT

Help

Home

Home » Archived » BIRT » Translating from Reorting Services to BIRT

Show: Today's Messages :: Show Polls :: Message Navigator

Translating from Reorting Services to BIRT [message #760265]

Thu, 01 December 2011 17:39

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.

Report message to a moderator

Re: Translating from Reorting Services to BIRT [message #760393 is a reply to message #760265]

Fri, 02 December 2011 09:32

nlajka -

Messages: 61
Registered: April 2011

Member

More than 200 views and not a single hint, idea or info?

Report message to a moderator

Re: Translating from Reorting Services to BIRT [message #760442 is a reply to message #760393]

Fri, 02 December 2011 11:46

donino donino

Messages: 183
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

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 152 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

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.

Report message to a moderator

Re: Translating from Reorting Services to BIRT [message #764706 is a reply to message #764600]

Mon, 12 December 2011 17:50

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.