"The sub-reports in an Alchemex union report run from the bottom up i.e. in the Report Manager click on the Sub Reports Tab and you will be able to change the order of your sub reports.
REMEMBER - The bottom report runs first"
Riekie Roux's Discussions
Pass Through Variable on SQL Query Container
5 Replies
Started this discussion. Last reply by Stephen Coull May 9.
Alchemex for X3 - Standard report
3 Replies
Started this discussion. Last reply by Stephen Coull Apr 15.
Pass Through variable for date
2 Replies
Started this discussion. Last reply by Riekie Roux Dec 19, 2011.
Riekie Roux's Page
Latest Activity
Michael Camacho replied to Riekie Roux's discussion Pass Through Variable on SQL Query Container"This worked fine on my test environment as i was able to get my report with the pass through variables to run before the second report which depended on these variables but when trying on the live environment i was unsuccessful.
Is there…"
Michael Camacho replied to Riekie Roux's discussion Pass Through Variable on SQL Query Container"Hi All,
Please ignore my earlier post as i was able to achive this.
Only the one report needs the parameters and as long as this report runs first then the SQL query will pick up the variables.
Regards,"
Michael Camacho replied to Riekie Roux's discussion Pass Through Variable on SQL Query Container"Hi Stephen,
Just to add to Riekie's post, we are using 2 different data containers and only the one having a pass through variable for example @region@. When trying to place the parameter in the SQL query under the where clause we receive an…"
Stephen Coull replied to Riekie Roux's discussion Pass Through Variable on SQL Query Container"You will need to build your filter into your SQL query, say for example as a where clause
Where region = @region@ and region is what you are capturing at run time as a parameter prompt"
Riekie Roux posted a discussionPass Through Variable on SQL Query Container
I have 2 reports, sharing the same parameter. Both reports have been written of SQL Query (so the Filter tab is not available in the Rerport Manager). Can I still use a pass through variable in order to have the parameter selection only pop up once? How do I go about it if there is not Filter tab?See More
Stephen Coull replied to Riekie Roux's discussion Alchemex for X3 - Standard report"Hi Riekie,
Reports attached - please send me your email address as I seem to have lost it, thanks."
Riekie Roux replied to Riekie Roux's discussion Alchemex for X3 - Standard report"Hi Steve, please can you send me the reports? I have to finish these reports this week, so do not actually have any time to spare. I will have a look at the SQL user in the meanwhile."
Stephen Coull replied to Riekie Roux's discussion Alchemex for X3 - Standard report"Alchemex for X3 is being re-launched in mid April as Sage Intelligence - Financial Reporting for Sage ERP X3, and has all the latest and greatest new reports and functionality like reporting trees and advanced distribution.
Let me know if you…"
Riekie Roux posted a discussionAlchemex for X3 - Standard report
I installed the standard report Analytical Financial Reports Designed 1-9 (x3v6). Now I am trying to run the report, but when I want to select any of the parameter, I get the attached error. I am also unable to create a brand new report off that container, it comes up with "Incorrect syntax near keyword 'THEN'" Is there an updated report that is working? Please assist.See More
Riekie Roux replied to Riekie Roux's discussion Pass Through variable for date"Hi Terence, I will try this. I'm looking for 365 days specifically."
Terence Hinrichsen replied to Riekie Roux's discussion Pass Through variable for date"Do you specifically want 365 days or would you not rather just use 1 year. I am just thinking out loud ( if that makes sense), but can't you take the SUBSTRING (@PTVAR@,6,4)-1 [or something like that] to just get the year out and then create a…"
Riekie Roux posted a discussionPass Through variable for date
I have a varchar pass through variable for a date with format (31/12/2011). In my columns, I also have a date, originally 20111231, which I converted to 31/12/2011 through SQL. If I try to use these on my parameters and filters, on the equal to and not equal to works. However, I need to be able to only draw the figures for the past 365 days from run date. Any ideas on how I could do this?See More
Riekie Roux replied to Riekie Roux's discussion Pivot table layout"Hi Steve, thank for the feedback, in the end it worked when I put in a formula to concatenate the Division, Item Number and Lot Number, i.e. get a unique record, then put that in column B and hide."
Stephen Coull replied to Riekie Roux's discussion Pivot table layout"Riekie - assuming that "Division" is in column A and "Item Number" is in column B, I would add "Expiry Date" to the report manager columns twice (Sage Intelligence allows this) and would include the 2nd iteration of…"
Riekie Roux replied to Riekie Roux's discussion Pivot table layout"When I go to Report Layout, I only get Compact, Outline, Tabular. No other options. Using Excel 2007
"
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Sage Accpac Intelligence
- Where did you hear about us?
- Invitation
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
