Hi-
Just downloaded the trial and ready to buy this module....however,...it doesn't seem to work for me. I tested my sql qry via the host/sql module and my sql works. I receive an error when I click "export to excel":
A critical error has occurred.
Incorrect syntax near the keyword 'declare'. Incorrect syntax near ')'.
here is my sql query:
declare @EventID int
select @EventID = EventID FROM companytable_Event where substring(EventName,1,3) = 'ANA' and IsCurrent = 'True'
select
ContractorName,
isnull(dbo.fn_GetProfilePropertyValue(u.UserID,'CompanyName'),'') as CompanyName,
(ISNULL(CAST(ab.BoothID1 As varchar(100)) ,'') + ISNULL(',' + CAST(ab.BoothID2 As varchar(100)),'') + ISNULL(','+ CAST(ab.BoothID3 As varchar(100)) ,'') + ISNULL(',' + CAST(ab.BoothID4 As varchar(100)) ,'')) As [Booth Numbers(s)]
from
Users u INNER JOIN companytable_IndependentContractorForm ic ON u.UserID = ic.ExhibitorID INNER JOIN companytable_EventForm ef ON ef.RecordID = ic.ContractorID AND ef.FormName = 'Independent Contractor Request Form' and ef.EventID = @EventID
LEFT JOIN (companytable_AssignBooth ab INNER JOIN companytable_EventForm ef1 ON ab.AssignID = ef1.RecordID AND ef1.FormName = 'Assign Booths' AND ef1.EventID = @EventID) ON ab.ExhibitorID = u.UserID
and u.UserID > 2
order by
CompanyName