01-31-2024 05:04 PM
This is a follow-up to my prior post about Parcel Service.
Converted my excel worksheet to CV's and imbedded them in a Book. That works great and I can pass parameters and burst without any issues. In the Admin guide under the Book section it talks about adding a Report. I added 4 Reports with Report Type = 'Dashboard Report' and 'Dashboard Chart' and selected the related Component Name. There were two - One listed as a 'Large Data Pivot Grid' and one listed as 'Spreadsheet'. When running the book, nothing gets created in the Excel workbook generated for these 4 new members.
I thought I saw somewhere that you could use a book to generate output from a Table. In the above, the spreadsheet has a 'Table View' imbedded that works fine in Excel or in the Dashboard. The Large Data Pivot Grid also works in the Dashboard.
Is my issue that it does not work with anything that is imbedded in Excel. In writing this I went back and linked the Report to my Grid View item created from a Data Adapter.
So, what am I missing? Can I include a SQL query into a table in a book? or can this just not be done.
Solved! Go to Solution.
02-01-2024 09:40 AM
In a PDF you can include basically everything; the output will be a PDF file, though.
If you really only want to dump non-cube data in Excel files, there are a few different approaches.
This is the easiest solution, from a coding perspective. There are alternatives that can generate proper Excel files instead of CSVs, but they require a bit of "dark" knowledge of DevExpress libraries that we're not at liberty to discuss.
02-01-2024 04:36 AM
From the documentation - note the grey area at the end:
02-01-2024 09:05 AM
Got it - It will not work with output being a excel doc! Will it work with output being PDF (not ideal but aleast gets the data out)? or is there a different path to get the data stored in a table distributed via Parcel service (in a book, not in a book). Just need ideas on how to get this data out to users - or is the answer that it is just 100% not possible in OS to get non-Cube data delivered via Parcel service in excel.
02-01-2024 09:40 AM
In a PDF you can include basically everything; the output will be a PDF file, though.
If you really only want to dump non-cube data in Excel files, there are a few different approaches.
This is the easiest solution, from a coding perspective. There are alternatives that can generate proper Excel files instead of CSVs, but they require a bit of "dark" knowledge of DevExpress libraries that we're not at liberty to discuss.
02-01-2024 11:03 AM
Excellent - Goal is non-licensed users so will go with the coding. Will see about putting in an enhancement request as I can see us using this feature a lot and it would be similar to be able to skip the double step. Thanks for the suggestion.
04-16-2024 05:03 PM
Still need your direction. I now have created .csv files and have them stored in the Applicaiton Database section of Documents. I can see that Parcel Service can only attach Books, so I created a book that is just a File. When opening the Book, it is blank. So my question is how do I get the csv file added to the Parcel Service Package? Do I have the csv file part of a book, if so, how does that work or can I attach it directly to the package. Your instructions sound like i should be able to just grab the .csv file and not deal with a book but the XFDoc File Path only seems to see Books.