Replies posted by Tracy Norwillo

111 Replies

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Report Designer - Last Page Footer Size

@ashen_malaka_ranasinghe I’m going to add some pictures to clarify what I’m asking.I have a Repeat Page with a Repeating Footer set to 1.5 cm.I have a Last Page where I have the footer set to 4 cm. I did this by initially setting the Repeat Page to 4 cm. The value of 4 cm was defaulted into the Last Page Page Footer. I then went back and adjusted the Repeating page to 1.5 cm.I removed the table from my Last Footer container and just left it with a red background color. I can see that there are no visible properties for Last Footer in the Report Designer tool, but if I check the xml, it does show the different sizes. If I print the report, the last page footer is not the full 4 cm, and it gets jammed to the bottom and cut off. So what’s the intended functionality of the footers? Should I be able to have two different sizes?

6 months ago

kacperifsSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Editing report IFS Report Designer

@kacperifs When you run the report, are you choosing Yes or No for the Detailed parameter? Can you check in the report archive and view the xml to see what’s populated there? Look in the TRANSACTION_DETAIL section as @Technical Toby shows above.

7 months ago

kacperifsSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Editing report IFS Report Designer

@kacperifs Okay, that’s what I thought. Unless @Technical Toby has thoughts on why it’s not showing up in the original position in the TRANSACTION_DETAIL section of the report, we’re back to checking to see if there’s an INVOICE_NO value in the report view for your result_key. If you are connected as the app owner, you should be able to see what’s in the view.

7 months ago

kacperifsSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Editing report IFS Report Designer

@kacperifs Putting aside where you tried to re-add the invoice_no, you should be seeing the invoice_no in the original report position as long as you satisfy the visible condition and the value is being pulled into the report_view.Will you please clarify if you ARE or are NOT seeing a value for the invoice_no in the original report position in the TRANSACTION_DETAIL section? Above you stated you could not see the invoice_no there even if you removed the visible condition so we started down a line of trouble-shooting to see if the value for the invoice_no is in the report view.

7 months ago

kacperifsSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Editing report IFS Report Designer

@kacperifs @Technical Toby For my own edification, please…kacperifs stated that the field which was already in the TRANSACTION_DETAIL section wasn’t showing up. “If I leave Invoice_No in its original position, it still does not display any data, even if I change/remove the conditions.”I’m curious to know why it’s showing up now?

7 months ago

kacperifsSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Editing report IFS Report Designer

@kacperifs I’m going to give you some general guidance to help get you unstuck because I’m not familiar with the Cash Box Report…There is security on the report views that only allows certain users to see the results. You’ll either see it directly at the end of the report for or at the end of the info_services_rpv view, if that’s the original source. You must be connected as an allowed user to see the results. If you are and you can’t, then maybe you are not entering the correct result_key. It’s a simple task to take that parameter off of the sql and run a select *.If the field is not populated in the report view, then check the report RPI to see what logic populates the field in the view. You should see it’s coming from mixed_payment_ledger_trans_tab and is the ledger_item_series_id and ledger_item_id. Check these against your IFS source.

7 months ago

kacperifsSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Editing report IFS Report Designer

@kacperifs Is there an actual value (ie: data) for the invoice_no in the view for all rows for your result_key?select result_key, row_no, invoice_no from cash_box_report_rep where result_key = :my_result_key

7 months ago

kacperifsSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Editing report IFS Report Designer

@kacperifs For your result key, does the INVOICE_NO show as populated in the original position - in the TRANSACTION_DETAIL?For your result key, is the INVOICE_NO populated for all of the records in in the view?

7 months ago

kacperifsSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Editing report IFS Report Designer

@kacperifs For your result_key in the cash_box_report_rep view, do you see the invoice_no populated?If no, then it’s not populated for your transaction. If yes, then how did you add the INVOICE_NO to the report in the spot you’re showing above? It’s currently available for this report at the transaction_detail level and you’ve added it to one level above. Check that the path to the INVOICE_NO is correct. It should be tns:TRANSACTION_DETAILS/tns:TRANSACTION_DETAIL/tns:INVOICE_NO not simply tns:INVOICE_NO. Is there a 1 to 1 relationship between the TRANSACTION and TRANSACTION_DETAIL in the report? I’m not familiar with the subject matter, but you could figure that out by looking at the cash_box_report_rep view. If it’s not 1 to 1 and you can have multiple detail records per transaction with only some of the details having the invoice_no populated, then you’ll need to adjust how you pull the invoice_no to conform to your business logic.

7 months ago

SHAUN_KERSLAKEHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

EE Profile Issue Post Delivery Deployment

@SHAUN_KERSLAKE It looks like you have a number of custom fields on the page. Have you tried copying the Layout branch from a known good profile to the personal profiles with the issues? Windows/Features/frmWoFaultReportCustOrder/LayoutRMBCopy Values to Profiles<pick a troubled profile>Copy Behavior = Make Exact CopyOK button

7 months ago

Zuha SamsudeenHero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Set an accounting structure as default in BR

@Zuha Samsudeen Hi Zuha - You can set the default structure using a filter set at the workbook level. Put the sample IS report into Design Mode, then navigate to the Report Book tab to set the filter.

7 months ago

JannetteCHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Schedule a job 4 days after the period end date

@JannetteC This seems to work for me in Apps 10 assuming you’re scheduling a database task and using a custom schedule: accounting_period_api.get_until_date_for_year_period('102',accounting_period_api.get_curr_acc_year_period('102')) + 4.25

7 months ago

DominikaM

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Overwriting database packages and xsd files of operational reports after release update

@DominikaM From what I understand, since layered application architecture is not supported for operational reports, putting the modified files in the appropriate Cust folders and committing them to the repository, should protect the files from overwrite.

7 months ago

ronDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to resolve row level security on on access views

@ron The documentation seems to support that idea, that the user accessing the data needs to have the correct permissions. But is also says that identical views owned by the IFSINFO user are created for each Access View. You’d have to take a look at those IFSINFO views and see what the security checks are in those. It’s been a while, but last time I checked, some of the security clauses for HR and Finance had the option of the user simply having admin rights to see the data.https://docs.ifs.com/techdocs/22r2/050_reporting/256_br_and_a/050_integrations/080_external_access/010_access_views/010_cremanageaccessviews/#security_remarkshttps://docs.ifs.com/techdocs/22r2/050_reporting/256_br_and_a/050_integrations/080_external_access/010_access_views/010_cremanageaccessviews/#technical_remarks

8 months ago

SPierpointDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Report Designer Training Apps10

@SPierpoint The Report Designer tool itself, did not change all that much for the IFS Cloud. You should be able to take that course and still come out with some good training for the tool.

9 months ago

addperpesDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

The image used as standard logotype (ifslogbw.gif) overrides other images in the reports

@addperpes Have you checked the properties for the added image and image container in the report layout? I can’t think of a way that the standard logo would replace the new image unless you reused the container or placeholder for the standard IFS logo.

9 months ago

Kaylsmuk1Do Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Business Reporter Error when opening saved file

@Kaylsmuk1 If you move the file to a local trusted location, does it open without error?

3 months ago

JustinJDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter client allows access to all reports

@JustinJ In the BR client, these people should be able to see reports:Creator of the reportPerson who last updated the reportAnyone granted access to the (Aurena) projection Anyone with Administrator system privilegeAnyone having the BA_REPORT_ADMIN permission set directly or indirectly granted

9 months ago

JannetteCHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Error message when deploying an IAL

@JannetteC I think the things to check are the differences between what happens when you run the SQL in your developer and what happens when you try to create the IAL table. Duplicate column names - this would be evident in the query results as the second appearance would appear as COLUMN_1 Oracle limits on table names and column names (30 characters) IFSINFO (assuming that’s your &IAL owner) grants to custom objects IFS grants for IFSINFO - check the permission setsYour query is a little long and has a lot of custom fields which makes reproducing the issue a little trouble-some for anyone trying to help. If none of the above helps, I suggest that you comment out part of your code and retry. I usually comment out half, if the error persists, I know the issue is in the uncommented part.

9 months ago

hburkettDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Custom Field error - not an approved persistent Custom Attribute

@hburkett I had something similar for a custom field I created recently. In your case, source_ref1 isn’t in JT_TASK_LOV and it isn’t in JT_TASK_CFT, but it is in JT_TASK. Check the Approved Detail Views to see if JT_TASK_UIV is approved. If it is, you may need to toggle it off and on again. Then retry the validation on the new custom field.And I’m not sure if it matters or not, but I’ve never used “v.” in front of my Arguments list. It may be fine, I’ve just never done it that way.

9 months ago

cmdriordanSidekick (Employee)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to add a command to execute a Quick Report using the Page Designer in 22R1

@cmdriordan See the following post for a couple of workarounds.

9 months ago

golo.naitoSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Report definition - Design time

@golo.naito Assuming you’re looking at a custom layout, this thread may help.

9 months ago

KPalmieriDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

BR Single Filter Issue

@KPalmieri If you don’t get any responses to your initial question, a few more details may help.Which Information Source are you using in your report?At what level is the filter defined? Can you include a screen-shot of the “single” filter?Can you clarify what you mean by “the report does not run”?

9 months ago

smelansonSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Custom field not showing on Functional Object

@smelanson If you go to the Custom Pages tab that’s behind the Attributes tab, right click on your custom page and there should be a refresh option. That should bring the field into your custom page and then into your tab.

9 months ago

SKA123Do Gooder

asked in Insights (Business Reporter and Analysis Models, EOI)

Modify RDF PLSQL in IFS Cloud 22R2

Look in the Core folder in your Git repository using File Explorer. The model will be in order/model. The layouts and schemas are in order/server/report. The rdfs are in order/source/order/database.

11 months ago

Page 2 / 5

Replies posted by Tracy Norwillo

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded