query fails in stimulsoft reports.net

Naveen Aggarwal · Post by **Naveen Aggarwal** » Wed Mar 24, 2010 11:13 am

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 !

Naveen Aggarwal · Post by **Naveen Aggarwal** » Sat Mar 27, 2010 10:45 am

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

Post by **Andrew** » Mon Mar 29, 2010 8:22 am

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.