@mwilson - You were on the right track. I figured out that one of the entries is for the preview results and one is for the print results. I think this is because two documents are generated - one for the preview and one for the print. Only the print document (Print Job ID 2120) is evaluated as TRUE. This must have to do with when the report xml is available to be evaluated by my expression.
Thanks for the reply. Is the list of values functionality for SQL type Quick Reports that is mentioned in the 21r1 tech docs inaccurate too?
Okay, just to clarify, are both of these statements true?In Aurena SQL Quick Reports, the Query Flag functionality described in the Cloud tech doc does not work.SELECT * from customer_info where customer_category_db LIKE '&[-CS--]CUSTOMER_INFO.CUSTOMER_CATEGORY_DB'In Aurena SQL Quick Reports, the Default Values functionality described in the Cloud tech doc does not work.SELECT * from customer_info where customer_category_db = '&CUSTOMER_INFO.CUSTOMER_CATEGORY_DB'
Okay, thank you very much for looking into this for me.
Thanks @hamalk , that makes sense for the database objects. Are the “404 Not Found” errors for the examples just a temporary thing or have examples not yet been created for the tech docs? I was looking for an example of the clear script.Is there any advice on removing the report model related files like the .rdf, xsd, and report projection?
Thanks again @hamalk, I did find an existing clear script to reference on one of our client’s instances. I also found the database_sys.obsolete_table procedure. This isn’t related to my question, but on Cloud 21r2, I could not find the database_sys.obsolete_column procedure that’s referenced in the tech doc.
@hamalk and @ChanakaAmarasekara - Thanks to both of you.
@SaraCrankGo to the Custom Logical Unit screen, not the Custom Fields screen and see if the Create Projection box is there.Solution Manager>User Interface>Custom Objects>Custom Logical Unit.If it’s also not there, right click on the page and navigate to Properties/Layout and see if the Create Projection box is ticked. If it’s there but not ticked, check the Use customized screen layout box at the top left and then tick the Create Projection box.
@kavinduxo Thanks for the link, it’s always interesting to see someone else trying to solve the same issue.I did some more testing with Report_SYS.Define_Report_Layout_ and found that in addition to creating the layout with Design Time set to TRUE, it was also incrementing my layout order each time I deployed. So that wasn’t going to work for me.I ended up using a check to see if the layout existed and then just manually adding the attributes. I don’t know if this is the “right” approach, but it seems to work for me. IF NOT report_layout_definition_api.exists(report_id_,layout_name_) client_sys.add_to_attr(….) Report_Layout_Definition_API.Add_Report_Layout_Definition(attr_)
We found a couple of workarounds that may work for others while we wait for the functionality to be added…1. Create an external navigation link to the SSRS server report passing in the parameters with ampersands.http://your-ssrs-server/ReportServer/ ..path to your report/your report name&parameter1=p1&parameter2=p2&… rest of parametersWhen you paste this into the Page Designer, you will be prompted to map the parameters.The resulting url should look something like this:http://your-ssrs-server/ReportServer/Pages/ReportViewer.aspx?%2fPublished+Reports%2fMyCustomerOrderReport&rs:Command=Render&ORDER_NO=${OrderNo}&LINE_NO=${LineNo}&REL_NO=${RelNo}&LINE_ITEM_NO=${LineItemNo} 2. Create a generic operational report containing generic text, number, and date parameters, plus a parameter for the report name. The purpose of the report is to pass parameters. Otherwise, the report has no content.To make this work, I had to also create .rpls for each SSRS report an
@Kelum Pradeep Kumara Thanks, I’ll let the customer know it’s been deprecated.
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.
@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.
@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”?
@golo.naito Assuming you’re looking at a custom layout, this thread may help.
@cmdriordan See the following post for a couple of workarounds.
@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.
@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.
@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
@Kaylsmuk1 If you move the file to a local trusted location, does it open without error?
@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.
@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.
@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
@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.
@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
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
