Forums (Obsolete)

Member

philip-mosquitodigital.co - 6/6/2011 6:53:52 AM

CMS Reports

Hi There,

Is there a way to save down reports to a spreadsheet or csv instead of having to copy and paste the report from the browser to a spreadsheet? some of my reports have 14,000 rows which i then want to get into a spreadsheet. it becomes a bit of a pain in saving to the clipboard first. is there isnt is there a way to modify the cms to implement a custom control to download the report im viewing?

Thanks for any help in adavnce


Kentico Consulting	kentico_borisp - 6/6/2011 7:54:49 AM RE:CMS Reports Hello, Regrettably, currently you would need to write a custom function to export it. However, in the next version there will be an export functionality available on every table in the cms which is generated with the UniGrid. You can check out the new features here and here is a screenshot of the mentioned one. Best regards, Boris Pocatko

Member

philip-mosquitodigital.co - 6/6/2011 11:13:05 AM

RE:CMS Reports

:-( darn. never mind. is there a way to using the reportinfo class to get the rows from a report or the sql query from a saved report? just trying to think of the easiest way to build a custom control for my client. can i modify the template used in the cms that shows the report? Im thinking of adding my custom control to it so that its all easy for my client to get the csv forthe report they want.

Kentico Consulting

kentico_borisp - 6/7/2011 11:00:09 AM

RE:CMS Reports

Hello,

You can find out which SQL queries are executed if you enable SQL debugging on your site. That way you can catch every request and use it later in your custom control.

If you want to edit the CMS Desk/CMS Site manager, you can find out what files are displaying the given content with the Firefox browser. "Right click on the given frame -> This Frame -> View frame info" - there is the path of the file, which contains the displayed page.

However, I would still recommend you to wait for the new version, since if you change the UI it might be overwritten with the next upgrade.

Best regards,
Boris Pocatko


Member	brent.pauley@terradon.com - 4/25/2012 9:31:08 AM RE:CMS Reports Boris: Do you know if anyone ever created a custom piece that we could contact? This would save us some development time. Thanks Brent


Kentico Consulting	kentico_borisp - 4/29/2012 4:30:46 AM RE:CMS Reports Hello, I am not aware of anyone. I am not sure which version you are using, however, this functionality is already available in 6.0. Best regards, Boris Pocatko