Workshops broaden your understanding of XLReporter. What Would You Like to Do? Report from Live Data A low-cost, easy reporting solution that does not require a historian or database. Read more Watch Video. Report from History Access raw data, summary values and industry specific metrics from a historians or databases.
Report On-demand Perform custom analysis by setting report parameters such as dates, tags, IDs and thresholds. Connect to Data. Compare Editions. This means you receive an immediate response to any question or issue about XLReporter. Next time you consider reporting software, ask the supplier a simple question "where is your software manufactured"?
First Class Support We recognize exceptional one-on-one technical support and service is as important as the product itself. Our support in Massachusetts, USA is one of the finest, receiving rave reviews year after year. Next time you consider reporting software, ask the supplier "is there a dedicated support team that will respond immediately? Put them to the test by contacting them. Design templates in the Design Studio available in Excel and apply familiar content like charts, formulas and formatting together with additional industry specific content provided by XLReporter.
Better still, import an existing Excel workbook such as one provided by government agencies. Exceptional Performance XLReporter does not impose artificial limits on tags, templates or reports. Our award winning reporting engine responds at incredible speeds producing Excel workbooks, encrypted PDF and web pages, automatically or on-demand, consistent with the template design.
Start Small and Grow XLReporter leverages live data, historical data and database data from over 80 built-in connectors. Regulatory Reports for Conformance XLReporter provides 21CFRPart11 features, key calculations and performance indicators for various regulatory reports to validate your business is within guidelines.
Automatic Reports and Distribution Produce reports automatically and distribute them e. Save valuable human resource and reduce cost by having the right report, at the fingertips of the right person, at the right time.
On-demand Reports and Dashboards Empower your workplace with information produced by on-demand reports from any device that supports a web browser. Be on top of your actuals, and in control of your budgets. If you can trust your numbers, you can trust your decisions. Is your company growing? More complexity, more data, more questions to answer? Are you dependent on spreadsheets, which have become too complex?
XLReporting combines all your data and gives you the right numbers at the right time. Some examples: Reporting across multiple companies or locations Managing multiple departments or cost centers Tracking categories in Xero and Quickbooks.
Are you rushing from deadline to deadline? Trying to move away from spreadsheets, but struggling to find the time to do it? Why not let us do it for you? We are finance experts and specialized in reporting and budgeting.
We understand your challenges and we speak your language. We'll help you with your implementation. We saved hours every week. Great support along the way. Click here for all client reviews. One thing to keep in mind when doing parameters is that you probably will run reports together in Report Packages. This was only used to restrict the data query and will no longer be used.
Next click on Parameters and enter values in the fields as shown in Figure PL 3. With Dimensions you can use the listed attributes on the parameter and with Expressions you can use the attributes with ranges in the selection. The Expression selection has the same functionality as the Report Composer with regard to columns and use of attributes. Now that you have the parameter we are going to Group the Amount, Budget Amount and Variance and apply the parameter. This will give us data from the rows that are restricted by the parameter that the user chooses.
First, click on column E and add a column summary. The reason that we want this is to restrict data in Column E to the parameter value. Next go to the Period Dimension and click the selection button and you will see the list that we have worked with before.
Choose the parameter tab instead and choose the parameter vCurrentMonth that you made in the step above. Click on Apply and you will see your selection in the Complete Selection area. Click on any transaction amount on your report and right click on drilldown which will take you to the Drilldown function. You should see February Transactions. Next go to cell E6. From the formula builder pick the PeriodEnd2 attribute of the Financial Period dimension.
This date can be shown by formatting by Month and Year or it can be shown as the last day of the month. This syntax allows you to show the selection period that you are using. This formula references the E6 month formula and will give you the last day of the month.
Other period syntax examples can be found in the help files and there is also a period syntax example on the iLytix Partner website. Next, we are going to show data from the last fiscal year for the same month. Once that is finished, select column H.
Go to the Financial Period dimension and select the lookup button. Reselect the vCurrentPeriod parameter. Then select the lookup button from the Value cell. Select Current Period of Previous Year from the list of period functions. We are going to use the same formulas that you used in the Report Composer in Exercise 4, except we are going to use them with a parameter instead of Period.
Use the same procedure as above by copying and pasting except for grouping, you are going to be adding a selection instead of a grouping. Hint: Use the Financial Period function lookup to easily create these formulas.
See Figure 3. Change the parameter to and you use the same value to filter the other columns. To do this we will use the same concept for rows that we did for columns except that we will change the segments from Revenues to the other Categories. First insert a row above row 8. Then copy and paste row 9 thru 11 to row Click on row 14 and check to see the selection criteria formulas were copied from row 9 to row Click your report and change your labels to COGS and execute your report.
This is done by the familiar Excel function of adding the two totals in the column. The rest of the PL Report is a matter of using the same technique as above and formatting in Excel. Additionally, you might want to use a check figure concept to ensure that your PL balances.
To do a check figure go to any row and copy a selection formula and go to the bottom of the report and click on a row. Go to the Advanced Report Builder and choose Selection instead of grouping. This will put in all your results in one row instead of multiple rows. Apply and run your report and then check figures should match your Net Income if you have included all of your Segments Correctly.
Your final report should look something like this. Next, we are going to do an exercise that fully uses the functions of XL Reporter and Excel. You are going to do a multi grouping with Drilldown to the Transaction Level. Refresh and then group by Department and Account and add totals. See Figure 1. Format the Report and Group with Excel Row Review the previous exercise if you forgot how to Group with Excel. Add an Account Description to Row 3. Next collapse row 10 and then Group line 9 to What you should have is three expansion groups.
See Figure 2. Then copy the account number from cell B9 to B Add a description to C11 if you want. Execute your Report. Now take columns C thru E and Group them. Collapse your report rows which one do you think makes most sense to collapse? This is very similar to the exercise that you just completed for a Profit Loss Statement.
Also drag Amount to the Report View area. Also drag and drop Financial Period and choose the first period in the list thru This is done for performance reasons and has data pulling from one instead of two dimensions. Your report should look like PL Figure 1. Figure 1 3. Delete the formula in the Report Default and click apply. Click on Row 8 and add totals and titles and format your data. Add Assets as your title and copy and paste and change row selection for the following Groupings.
Remember to Copy and then go to the row you want to paste to and then add a grouping and then paste the formula in the Complete Selection area and then paste. Next we are going to do a selection by Column instead of by Row. First Add a month Parameter. This formula will give you the account balances at the end of the period you select. Refer to earlier lessons with Report Composer if you need help with this.
Execute into Excel and do not use a template and save into AR Reports. Next, we are going to use the charting wizard to create three charts. First cut and paste rows 5 and 6 to rows 28 and 29 and insert a new column in front of column A to allow enough room for the charts on top. Then highlight C28 to E30 and click on the charts. Follow the wizard and place the chart. When you are in Data Range, click on Series. Change the values to Figure 2. Go through the same process and add a chart for Revenue and Gross Profit.
Add the Now function and parameter and your report should look like this. Next we will add DrillDown Functions. The Drilldown function is done using Hyperlinks in Excel. To accomplish this you need another Excel workbook and install dummy worksheet with the worksheet names and create the hyperlinks there.
The worksheet names will be the names of the reports. Copy and paste the hyperlinks to the XL Reporter report and save your report. Add the hyperlink and save in the Dashboard Reports, make sure that you name the report the same name as the Hyperlink you created.
Next, you will be ready to build a Report Package for your Dashboard. The function of the Report package is to group reports together. Each report within a Package will be a worksheet within Excel and the name of the Package will be the Workbook Name.
Also you can use Excel forbidden characters in the Report and Package names. Also you have a limit of 15 characters for name. Additionally the package has to be in a different folder than the book as when you create the report the book will be named after the package and you will receive an error. Reports stored in the grey folders will be available to run in the SBO menu system:. Exercise 3 Creating an Excel TemplateOpen Excel from your Windows desktop and create the following template to be used later when you design reports:.
Hints: Make row 7 your last header row, and format rows below this with account descriptions and numbers in mind. Also make the first 7 rows repeat by using the sheet tab in the page setup Save the file as an.
It will automatically be saved to a specific Excel template directory. Note: change the user name above to the user that logged on to the computer. If you are using Office XP, make sure that you have Service Pack 2 installed or you will not see your templates.
Data AreaThe data area is displayed in blue at the top of the window and consists of the modules with data fields within them. This may also be referred to as the module tab. Based upon the data schema in SBO, the module tab data fields are broken down into dimension, light dimension or measure categories. Each of these items has a name similar to the name utilized in SBO and are displayed by category, then alphabetically.
The difference between the categories is what you can choose with them, and is more evident when you add them to your query. The data fields are described with the following three icons: Dimension - similar to cards in SBO and have a lookup function in the Selections area. Additionally a dimension has attributes that supplement it. Account Description attributes. You can also do filtering of data in the Selections area based upon the dimension or attribute.
Light dimension - data that is transactional in nature but is not calculated see measures below. Light dimensions do not have a lookup function. If you drag the light dimension to the Selections area you will see that you do not have a lookup icon. Measures - data that is quantitative in nature and can be calculated. An example is Qty or Amount. A measure is required in your query if you move it to Excel.
You cannot drag measures into the Selections area. If you need to filter or refine a measure, you can do so in Excel via the Advanced Report Builder.
0コメント