nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Integration between Report design and data source

medini_1042557991

Hello ,

I have js files and report design , could you please guide me to populate values from js file to Report designer with clear example .

queries:

1) what type of data source need to select

2) what is resource file to select

3) how to write scripting to populate values from external js to report designer

Expected output:

The count value(from js file) should populate in report design as summary's value

Find more posts tagged with

medini

medini legacy

Accepted answers

All comments

medini_1042557991

How to create scripted data source from external Js file.

medini_1024169437

Hi Mattevada, not sure, but seems that this is more or less the same question as your (colleague?) has asked in a separate thread. I posted the hint in a separate thread, please check it out.

Happy Reporting

Jan

medini_1042557991

I'm not clear with that example , can you please give me an other example step by step.

can you please answer my questions which I mentioned below

1) what type of data source to be select?

2) how to write scripting to populate values from external js to report designe.

3) can you give short script for assigning value ?

4) how to write scripted data source using js file?

medini_1042557991

In open method of the scripted data set i wrote

number = 575 ;
name = "vijay";

In fetch method of the scripted data set i wrote

row["Name"] = name;
row["Number"] = number;

but when i tried to see the preview , I unable to see preview its showing like blank

medini_1042557991

In open method of the scripted data set i wrote

number = 575 ;
name = "vijay";

In fetch method of the scripted data set i wrote

row["Name"] = name;
row["Number"] = number;

but when i tried to see the preview, unable to see the preview its showing like blank

medini_1042557991

Hi Jan

Here i have mentioned my blocking point along with screenshots,

Case1: Created report as shown in "1_Medni_Report.jpg" in that report design the location, projects and summary values should be populate. for that i have created data source and dataset, in the data set(2_medini_datasetScript.png) written script(values are hard coded) for populate values.

Case 2: same as case 1 but here the value(summary value should populate at report design ) should take from external js file(3_MediniJSFile.png)

medini_1024169437

Hi Mattevada,

I think I now see clearer. First of all: I strongly recommend NOT to create your own scripted data sets to access anything from the medini projects. We prepared data sources and data sets for that purpose, just check the standard report of the samples here in the community (also in the mentioned article) and copy & paste data sources and sets to your report design. In best case you only need the OCL data source and sets.

Scripted data sets I only use sometimes here in the forum to prepare some dummy data to explain something in BIRT that is independent on medini. You will not be able to pull the data from medini in your own scripted sets (for example the "Global" singleton is not available in the BIRT JS environment!

Maybe you check this article as a starting point.

Greetings

Jan

medini_1042557991

Hi Jan,

As you said i have created " OLC data sorce " but for that what is the context type ,query text and result type to create data set.

1) how to select js file as source file to get parameters which are included in external js file

medini_1024169437

Mattevada,

well, that should be the metaclass of the object you want to query for example a requirement or safety goal.

If you copy paste it from the design I mentioned you have that fields filled. The script in its simplest case is just "self".

See my separate article https://medini.freshdesk.com/a/forums/ for where to place scripts.

Jan

medini_1042557991

Hi Jan,

You have created analyze project as data source and respectively created data set named as "SafetyrequirementsDiagramsDS" i didn't get how data set filled with parameters(like asil, custom ,name,description)

can you explain me how did you get those parameters in data set

medini_1024169437

Well, there are different data sources and data sets supported by medini, they are well explained in the training slides, which to my knowledge should be available to you. Please have a look and these slides.

Anyway, OCL based data sets should be sufficient for your problem I think.

Happy Reporting

Jan

medini_1042557991

Hello Jan,

1) In report design file I have created like table format but when i'm trying to generate report I am unable to see in the table format , simply in text format its showing

2) in report design file I have created table , but when I generate report the table will not be shown

attached screen shots

medini_1042557991

Hi Jan,

I Unable to populate the value from js file, attached screen shot can you please check it once

exception which i have got is : failed to execute javascript :script execution was stopped by engine or runtime

medini_1042557991

Hi Jan,

I Unable to populate the value from js file, attached screen shot and javascript file could you please check it once .

Exception which i have got is : failed to execute javascript :script execution was stopped by engine or runtime

medini_1024169437

Well I do not exactly why the script is stopped but the code in line 2 is certainly wrong:

The script just defines the function, the call is in the derived (profile) property.

Why your table is not shown is also not clear. Do you have a screenshot of the derived report?

You put the metrics section to the table footer, hm, maybe that#s the reason although this is the right way if you do not have something to populate.

Jan

medini_1042557991

Hi Jan,

I have followed as per your instructions but i have got exception as shown in screen shot, could you please check once

medini_1042557991

Hello Jan,

As you said i have called function in profile property but still getting same error.

medini_1024169437

Hi Srikanth,

in this case I think I need the complete error log. Please open the "Error Log" view and paste the latest error here.

Second idea: one guess is that load() in a loaded script may not work. Could you try to avoid the load("Utils.js") and try to have the code from Util.js in the js library?

Maybe that way the error goes away?

Jan

medini_1042557991

Hello Jan,

I have included entire code in one script as you said, still unable to populate

Attached screen shot with clear information (error log)

medini_1024169437

Hello Srikanth,

2 things: what is shown if you hover the error in the "Profile" tab? I mean in the tooltip...

Second: try setting some pragmas in your script. Please see this article. Note that the pragma MUST go into the profile script, not the .js file.

Jan

medini_1042557991

Hello Jan,

Please find the below error message.

Attached the script file for reference.

medini_1024169437

Hm, strange. Looks like you have an endless loop somewhere or a timeout.

Could you check line:

var onAnyDia = onAnyDiagramInScope(finder.scope, event, result);

I think you do not use "finder" but "myPrjFinder ".

Jan

medini_1042557991

Hello Jan,

I have tried using "myPrjFinder" but still not yet solved.

could you please find attachment.

medini_1024169437

I have no clue. Try to reduce the code till a point it works.

For example do not use the onAnyDiagramInScope call but assume "true" for all events first.

Jan

medini_1042557991

Hello Jan,

already i discussed with you about table format not generated in final report,

in the report design i have created table but when i am trying to generate report the table format not supported as shown in the attachment

can you please check the attachment file

medini_1024169437

Looks like the table is there. So I assume you mean, you do not see the "table borders". The designer shows gray borders to help editing the design but that actually are no borders, similar to Word.

Please select a row or column or table and edit the "Border" properties.

Jan

medini_1042557991

Hello Jan,

Table format issue solved , thanks

One more doubt in populating dynamic text in between static text...

I have attached screen shot, in that case in the place of "project name" and "basline Name" we need to populate values from .js file , can you help me to get it

Thanks in advance

medini_1024169437

Hello Srikanth,

you basically can use a "Dynamic text" here, bind it to the respective data set (most likely a project data set)

Then you can create dynamic strings using Java Script by concatenating fixed text with data from the DS.

Happy Reporting

Jan

medini_1042557991

Hello Jan,

Now i am able to export the report by commenting onAnyDiagramInScope(), basically this function is used to identify the events with background now i am loosing this criteria.I have noticed another problem while exporting into word.I am unable to wrap the cell text.I tried something below.

var evetnsIds = row["@self"].getObject().getProfilePropertyValue("swAD").get(0)[3];

var wrappedText = '';

while (evetnsIds.length > 0) {

wrappedText += evetnsIds.substring(0,40) + '\n';

evetnsIds = evetnsIds.substring(40);

}

But it is not populating the values. Can you please help me on this?

Attached screen shot for better understand

medini_1042557991

Hello Jan,

we have an issue while exporting the report into word document , when i export into word document the long length doesn't appeared but when export in pdf format the long length text populating , can you please help me to get it?

Attached screenshot for better understand

What i have tried is :

if (dataSetRow["SwRSEventsRationalIds"]== null) { '' }

else {

function wrap(longStr,width)

{

length = longStr.length;

if(length <= width)

return longStr;

return (longStr.substring(0, width) + "\n" + wrap(longStr.substring(width, length), width)); }

wrap(dataSetRow["SwRSEventsRationalIds"], 20);

}