EZWriter reporting is conformed by three main parts:
- Data Source
- Data Format
- Client artifact (iEBMS page, Word Document or Dashboard)
A Data Format is a HTML representation of the data made available from an EZWriter Data Source previously created. While a Data Source makes some database fields available on the system, the Data Format is in charge of formatting the data to match the wanted result. This means that every Data Format needs to be linked to a Data Source in order for the report to work.
There are three different sections that constitute a Data Format (Header, Detail and Summary). A Header is primarily made for data that will show up only once on the report and will be places at the beginning. The Detail section holds the information that will normally be placed on a table, listing all the elements or rows made available from the Data Source. The Summary section will display only one record and will be placed at the end of the report.
Each one of these sections will list all the fields made available from the Data Source on each one of the three corresponding section, this is, if we create a SQL statement on the "Header" section of the Data Source, the fields will only be available on the "Header" section of the Data Format that makes reference to the Data Source.
Comments
7 comments
I'm running into an issue where my detail section is being skipped altogether. The Header and Summary appear just fine, and the SQL in the data source is OK in the detail section. I'm using a table, and there is some text too, and none of it appears. Can anyone help?
0 upvotes
Can you have an ez writer for excel
0 upvotes
Hello Kris, thanks for submitting your question.
The EZ-Writer Data Format returns an HTML document that can be inserted in a Webpage as well as a Word document due to it's ability to interpret HTML. Microsoft Excel works a bit differently and does not interpret HTML the way you would need to in order to display data from your EZ-Writer Data Format directly to your Excel document. The short answer would be no, it is not supported.
If you would like to extract only data with no specific format, you could get cleaver and create a EZ-Writer Data Format and use it on a WRI page that returns an HTML table with your headers and rows. Then, in Excel, you can go to the <Data> tab and select the option "From Web" located at the "Get External Data" group and provide the URL of your WRI page. Excel will extract the data and recognize that is in a tabular format and respect the columns and rows. Take under consideration that the values are not strongly typed, this means that everything will be considered as text. You can configure each column on your Excel document to set the data type accordingly.
I hope this information helps.
0 upvotes
Hi Ricardo
Thanks for your reply.
I am trying to pull basic info in to excel, ‘Event ID’, ‘Event Name’ etc can this be done via the wildcards similar to word.
Thanks
0 upvotes
No problem Kris,
At this moment, wildcards are not available in Excel, nevertheless, there are other options to pull data from Ungerboeck to Excel. I would encourage you to contact your Ungerboeck Technical Services department and they will be able to offer a few options.
0 upvotes
If I was wanting to list the booked spaces and the rates that go with that space in a word template document. Is that where I would use EZWriter Data Formats along with the wildcards needed. I have never used EZWriter Data Formats before. Seeking some guidance. thank you!
0 upvotes
Hi Megan,
It certainly is! Any time you need repeating data (eg a grid of something - bookings, orders, etc) you need to use EZWriter.
0 upvotes
Please sign in to leave a comment.