Creating reports and dashboards | Stimulsoft community forum

hi,
I tried to use the following query while designing a report.
SELECT pfregister.* FROM pfregister where company_code = @company_code and isnull(totaltotalpfa,0) > 0 ORDER BY CONVERT(int, pf_no).
This query runs perfectly in sql server 2005 express as well as in crystal report but fails in stimulsoft. Any help ?
Thanks in advance !

i was just wondering, almost 4 days and no reply.
Is my query so absurd ?

Hello,

Sorry for the delay with response. All our efforts were thrown on release v2010.1.
Can you, please provide sample project with data for this issue because it is not 100% understandable by one string of query which conditions does this string contains?

Thank you.