Self-Servicing Reporting

I have a report I am trying to run, but for some reason I get garbage text for half the fields I try to query.

Just wondering what might be going on here and if there is any way to fix it. It looks like the value it returns is a unique identifier (as it appears in several other key-value pairs).

I want this unique identifier but I want the actual string it is supposed to correspond to (for example this value should equal a part number, say PART12345.)

Is there a better way to run custom reports in ARAS? Can you query the SQL database directly without using their interface?

I am new to all of this, any help would be appreciated.

Thanks.

Example garbage value (Part Number returns ~31 character string identifier instead of the actual part number which is <10 characters.)

91472922E234EFE8YD34F3E2A16KEE7

0 AngelaIp 3 年以上前

"Is there a better way to run custom reports in ARAS? Can you query the SQL database directly without using their interface?"

--> You can connect your Innovator with Microsoft SSRS so you have full flexibility when it comes to report. There is a guide available.

The main advantage of Aras internal report services is that they are incorporate with the permission model. Keep in mind that SSRS will directly work with SQL database data, so permission restrictions wouldn´t be taken in account.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel