Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Report Error when dataset linked to report parameter
Migrateduser
<p>Hello,</p><p> </p><p>I have been attempting to create a new report in Birt 4.2 through an SQL database, this is the first time I have attempted to use a report parameter. My query will run fine if I do not use the parameter, however the moment I link the parameter I get an error. I want the report to prompt for a date in string format so the user can select the date they want to run the report for.</p><p> </p><p>The query is:</p><p> </p><p><strong class='bbc'>select </strong><strong class='bbc'>count</strong>(*) <strong class='bbc'>as</strong> TechService</p><p><strong class='bbc'>from</strong></p><p>TABLENAME</p><p><strong class='bbc'>Where</strong></p><p>Board_Name <strong class='bbc'>=</strong> 'Service Desk' </p><p><strong class='bbc'>AND</strong></p><p><strong class='bbc'>convert</strong>(nvarchar(50), Date_Closed,126) <strong class='bbc'>LIKE</strong> '?%'</p><p><strong class='bbc'>And</strong></p><p>closed_by <strong class='bbc'>=</strong> 'Tech Name'</p><p> </p><p>If I use '2013-10-09%' instead of the '?%' and remove the parameter then it runs fine and returns the results.</p><p> </p><p>Given the convert date field I should be able to search with a string as the parameter, however I have attempted both string and date formats which both return errors.</p><p> </p><p>Any help would be great.</p><p> </p><p>Anyone have an idea why the parameter won't work correctly?</p>
Find more posts tagged with
Comments
There are no comments yet