Hoping someone out there has encountered this before. I am writing report using a command. The issues is that I want it to run off a different database depending on a parameter. This command works fine in SQL Query but am getting column name errors in Crystal.
Any ideas please?
Query is as follows:
declare @dbname nvarchar(255);
set @dbname = {?CONAME};
if @dbname = 'ZZZZ Training ???? ZZZZZZ ' use TRNDAT;
else if @dbname = ???' use ZWMDAT;
/*DROP TABLE #GSR_GL */
declare @YEAR CHAR(4)
declare @PERIOD CHAR(2)
set @year = '2012'
set @period = '10'
CREATE TABLE #GSR_GL
(ACCTID CHAR(15),
FYEAR CHAR(4),
PERIOD CHAR(2),
SRCECURN CHAR(3),
SRCELEDGER CHAR(2),
SRCETYPE CHAR(2),
JRNLDATE CHAR(8),
JRNLDTLDESC CHAR(100),
JRNLDTLREF CHAR(50),
TRANSAMT DECIMAL(19,3)
)
INSERT INTO #GSR_GL
select LEFT(ACCTID,6)+'-'+RIGHT(LEFT(ACCTID,9),3)+'-'+RIGHT(LEFT(ACCTID,12),3) AS ACCTID, FISCALYR, FISCALPERD, SRCECURN,
SRCELEDGER, SRCETYPE, JRNLDATE, JNLDTLDESC, JNLDTLREF, TRANSAMT from GLPOST
where left(ACCTID,3) = '080'
AND FISCALYR = @YEAR AND FISCALPERD = @PERIOD
select * from #GSR_GL
IP Logged
