... the scope(s) ZohoInventory.items.READ (add some more if you're unsure...)
Give it a connection name and note down the connection link name. I'm calling mine joel_zoho
Authorize it, etc.
Make a ...
... has not been tested extensively. Do not use if you are unsure it is calculating correctly. I use these to store the values in a table that can be double-checked at a later date.
Source(s):
Joel ...
... is an accepted answer over the web because as soon as I put a WHERE clause in the statements and check the numbers, only method 1 and 2 return the correct number. I'm still unsure as to why WHERE...GROUP ...
... will refer to this and allow you to specify the related SMG
Run SMG from the menu system
Enter a CODE (in our demo "CAPCHG")
Enter a Short Name (unsure of how this is used)
Enter a descriptive ...
... source" and test the connection.
Ensure unattended system account scheduled to run and email the report can access the datasource (ask a DBA if you're unsure).
Shared DataSource
Upload ...
... if you are unsure this will work)
Add a key to this one called "command"
Under the "command" key, there should be a new string value called "(Default)". If there isn't create a New "String Value", name ...
... in the next screenshot. Note how all our variables are hidden and cannot be NULL.
If you're unsure, right-click on your dataset and bring up its properties...
Specify the query type as "Stored Procedure" ...
... the Application value type c:\windows\system32\cmd.exe (this will be different on winnt, browse if unsure to your cmd.exe program)
Click on OK > OK > Close
Notes:
Added by default since ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.