Good day all, I am trying to create a dynamic report to produce the time it take between starting an activity and ending an activity. I can get the information I am looking for by using SQL, but it will not limit the returns based on dates. I have tried…

Hi community, the release notes of Innovator 26 mentions following fixed issue: I-050277 Fixed an error that prevented Aras Innovator from connecting to SQL Server Reporting Services via HTTPS. I did a quick test in Release 2023 and noticed that…

Good day all, How do I run an Aras report from a Method? I have several reports that I have created in Aras (not MS Report Services) and I can't figure out how to run one from a method. I'm trying to create a Modal Dialog so the use can pick the report…

Hi, I am referencing this blog post: https://community.aras.com/b/english/posts/using-query-definitions-method-code I am running a query via method, how can I set the condition as the query seems to return all possible results without a context…

I've got an email that I'm calling from a "post" method on the Part lifecycle, but the default context that's passed to that email message isn't the Part, it instead seems to be the alphabetically first Identity in my database? Why is this happening…

Good day all. This error just started with a couple of our reports. I have not made any updates to the RDL files, so I don't understand why this is occurring. Any help would be greatly appreciated. Thank you.

Good day all, I am trying to figure out why I can't a couple of reports to run. I know part of the problem is that our database does not use the OOTB Part ItemType. Our Parts List is a document ItemType and it links (weirdly) to our Part. I have this…

I want to send a report using email notification on Aras how can i do that?

Aras 11 SP10 Good day all. I am trying to create a report that will pull all of the attached items from a document. I have a method that will get the information, but I can't get it to output correctly for the report (can't figure out the correct Stylesheet…

Hi, I am trying to develop a custom BOM Quantity Rollout report, we have been able to pull in all the information we need from the Parts and Part BOM however, we need help pulling in the Manufacturer Part from the Part AML, I need help in determining…

Good day all. I could use some advice on creating a cover page for our BOM report. If you have read some of my previous posts, you may know that our database is a bit messed up. I can't change our report. I have created another report and formatted it…

Good day all. I am having a hard time trying to create a report to find Documents without files attached. This is the current config. Aras v11 SP10 s_Document - Poly Source for the following ItemTypes. s_Delivered Document s_Drawing s_Parts…

Good day all. I ran a report for Inactive Users. I have a list of almost 3000 users that have never logged in. I would like to remove these accounts, but my boss wants to make sure that these accounts don't have any other relationships. Has anyone created…

Good day all. I would like to have the Workflow Process History report displayed as a tab in an ItemType. How would I go about doing that? I thought the Signoff ItemType/Forms would do this, but I don't have any results from that. Thanks for the help…

The user would like to select multiple items from the main search grid, and run an analysis report only for the selected items. The client method linked to the report is executed multiple times, depending on the number of items selected in the search…

Hi, I would like to create a new report. For some reason my xsl documents makes blank rows .. ***********Here is my report Query : <Item type="HG_Product_Model" action="get" > <related_id> <Item type="Part" id="{@id}" action="get" select="item_number…

Hello, I'm using Aras 11 SP12 and I was wondering if there's an easy way to print or export the default reports in Aras like the "Multilevel BOM Report" to get a pdf file or something else that can be used outside of Aras. Regards /Rick

Hi, this is not really an urgent topic, but it´s something I wanted to ask for an eternity. When we create a new Report (e.g. Multilevel BOM Report), we will always get an additional empty tab that works as helper window. User have to close the window…

Hi all, I'm using reports in my project where in one report I need to use the where used concept. I have used AML Query <Item type='Part' id='@id' action='getItemWhereUsed' /> which simply returns all the parts, but as  output doesn't contains any…

I struggling with the stylesheet to filter so that for each Part in the example below only return EHT_Part Charactheristics.eht_char_value where EHT_Part Charactheristics.eht_char_name equals "Mounting" else empty. Any suggestions? Best Regards Geir…