You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 7
Next »
Which formats of reports can be generated using Sigma?
Sigma enables generation of reports in following formats - CSV, DOCX, HTML, PDF, TXT, XLS, and XML.
Does all the formats automatically enabled for all reports?
No. The report designers (Sigma Studio users) can configure or enable specific formats for each reports. Report consumers or generators (Sigma Application users) can generate the reports in the enabled formats only.
What are the integration options Sigma provides for functional data required for reports?
Sigma Studio provides following integration options for fetching functional data - Database, REST Web Services, Excel Import, and Google Sheets.
What level of control Sigma provides for the report columns?
Using Sigma Studio you can configure the following for report columns:
- Column positions
- Column alignment (by default number/amount columns of float data type are automatically right-aligned)
- Column width
- Column data aggregation - average, count, maximum, minimum, and sum
- Display name for columns
- Column visibility
- Column datatype
- Date and time, currency formats
Can the configuration to change the font size be turned off?
Not enabled as of now. It is always turned ON.
Does reports have RTL support?
Can Charts be included in the report?
Yes. The App Designer feature in the Sigma Studio can be used to create the chart as a individual app (widget). The Template Designer in Report configuration can be used to map the chart to the report. The generated report displays the chart and the report data. Refer Improve Business Reports with Charts.
How to view a report generated a week back?
In Sigma portal, on the Generated Reports tab, you can use the 24 Hours, 3 Days, and 7 days filters to view older reports.
Can the template used to render the report be modified?
In Sigma Studio, the HTML editor in Template Designer can be used to design the reports. Refer Template Designer Configuration.
In the data builder what is the difference between record and object?
Record is a combined selection of rows in the table.
Object is an individual selection of an item in the table.
Can data entitlements be controlled, e.g. Generate the reports for a specific set of clients?
Yes, based on system filter and default filter.
What is the maximum number of columns that can be configured in the report?
You can add columns without limits, however column length (width) should be specified appropriately to avoid error scenarios.
For example, if your specify 10 characters for an address column, the values for that column should not exceed that limit. Also, depending upon the number of columns, the report page size and orientation needs to be configured accordingly.
When the report / data source configuration changes is it enough to run the generated report again or should a child report be created?
When the data is updated, it gets reflected when you run the report. However, the structure of the database should not be changed.
In cases where data is aggregated and there are no child records, instead of printing an empty page with no data message, enable a configuration to avoid adding it in the report
Yes. Open the report in Sigma Studio, in the Report Parameters tab use the Generate output for no data drop-down to control report generation.
End of report message should be a configurable option in cases where data aggregation is used.
Currently the End of Report option is enabled for all. You can however modify the End of report message.
How to combine multiple reports into single file?
You can combine multiple report outputs into single file using the Group Reports feature. Refer Grouping Reports in Sigma for more information.
Can we have drop-down values or list box (multiple selection) as report parameters while generating reports in Sigma?
Can we include a report in another report?
Yes. Refer Sub-Reports for more information.