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

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

Translating from Reorting Services to BIRT [message #760265]

Thu, 01 December 2011 12:39

Eclipse User

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 04:32

Eclipse User

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 06:46

Eclipse User

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 06:51] by Moderator

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

Fri, 09 December 2011 05:49

Eclipse User

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 176 times)

[Updated on: Fri, 09 December 2011 05:51] by Moderator

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

Mon, 12 December 2011 09:00

Eclipse User

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 12:50

Eclipse User

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.

Attachment: conditionalvaluebasedonparameter.zip
(Size: 2.73KB, Downloaded 172 times)

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

Wed, 14 December 2011 06:37

Eclipse User

It wasn't exactly what I needed, but it pointed me to the right direction.

Thank you Jason once again!

Previous Topic:	How to use some variable in Report Parameter input before starting report?
Next Topic:	BIRT development

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 22:36:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter