Database Connector Error:'DAO Error Code:0xc03

[abhishek_chaturvedi2]

hi Guys ,

I m getting an error while im adding parameter in my Crystal parameter.

The Error is-

Database Connector Error:'DAO Error Code:0xc03

Source:DAO Database

Description:Malformed GUID,in query expression

'Year=Year(#2010-04-27 11:23:15#)and Month <=Month({?End Date})'.'

I have used the following Sql Query:

SELECT Sum(Amount) AS Year_BUDGET, [Account Number]

FROM [Monthly Account Budgets]

WHERE Year = Year ({?End Date}) and Month <= Month({?End

Date})

GROUP BY [Account Number];

Plz try to give me any solution.

[Former Member · Accepted solution]

Is there really a carriage return (new line) between "{?End" and "Date}" in the Month() expression as shown above? It looks like Crystal isn't recognizing {?End Date} in that part of the formula and doing the substitution correctly.

HTH,

Carl