I need to create a fairly simple report that exports into excel. It is meeting information and its venues. These venues sometimes can be in 1 "zone" or upto 20 "zones". Zones are internal ways that we identify them. Each "zone will need to be exported into its own sheet in a workbook. So for example, a meeting might have 5 zones. When I export the excel file, you will see 5 tabs at the bottom of the worksheet that says Zone 1, Zone 2, Zone 3, etc
The information in the worksheet would be items like, venue name, venue location, venue date, venue attendees, venue provider, all the stuff that is in the database.
Here is an example of a query with that information.
<cfquery name="x" datasource="#request.data_source#" username="#request.db_un#" password="#request.db_pw#">
SELECT *, meeting_venue_status.venue_status_name, meeting_venue_status.venue_status_color
FROM meeting_venues INNER JOIN
meeting_venue_status ON meeting_venues.venue_status = meeting_venue_status.venue_status_id
WHERE (venue_active = 1) AND (venue_meeting_id = #Val(attributes.meeting_id)#)
Order By venue_zone asc, venue_meeting_date ASC
In case anyone is familiar with the CFX tag.. I do own a license to this if it makes it easier....
[url removed, login to view];ProductID=cfx_excel
I am willing to pay up to $40 for help on this and need it within 1-2 days
3 freelancers are bidding on average $38 for this job
I can provide the solution you need. If you can provide me with the specifics on how you want your data queried for each excel sheet, and the names of the sheets you will require.