SQL 2 Excel Sample Reports - Installation Instruction

You can find sample reports for SQL 2 Excel in the downloads section of Joomla-R-Us.com. Follow the instructions below to install these sample reports.

The imported Workbook(s) will be set to unpublished. You can download and test them in the back-end before you decide to publish them for the users.

Note! You are free to modify these reports to your liking. There are just examples on reporting that can be done with SQL 2 Excel.

hmmm said:

	... getting a 500 error on import - any suggestions?
	report abuse vote down vote up

November 17, 2009
Votes: -1

hmmm said:

	... ok, figured it out - you apparently cannot import CB sample right after adding sample data
	report abuse vote down vote up

November 17, 2009
Votes: +1

htown said:

	... How do I just get it to import the fields I want, instead of all the fields? i tried modifying the xml but I kept getting errors when i tried to open the excel file. "Data may be lost" and it was . I replaced the query with this
	report abuse vote down vote up

June 15, 2010
Votes: +0

Mats @ Joomla-R-Us said:

...
Import the original XML file => creates a Workbook in SQL 2 Excel.

Locate the Worksheet you wish you modify and edit the SQL query inside SQL 2 Excel.

For example, if a query selects all fields from a table:

SELECT a.*
FROM mytable a

and you only want two columns...just change the query to:

SELECT a.colA, a.colB
FROM mytable a

(change column and table names to match what you want/need)

-Mats

June 15, 2010
Votes: +0