February 9, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Date FormatDate Format
Previous Previous
 
Next Next
New Post
 9/17/2007 10:46 PM
 
Hi Frédéric,                         
               I am having an issue with the datetime parameter function. Below is my query. I'm using SQL Business Intelligence Studio, SP 2. When I run the query it prompts me for the date parameters, but throws a sql exception after I enter them. I haven't been able to find the log files with the exception, but I suspect it's the date format, because if I remove the parameters, the query runs ok. I thought ERSDE handles the date format conversion? Do you have any ideas? Thanks.

<?xml version="1.0" encoding="utf-8" ?>
 <root>
<list title="xxx" relativeSiteUrl="/xxx" tableName="results" useDisplayName="true">
<fields> </fields>
<query>
<Where>
            <And>
               <Geq>
                    <FieldRef Name = "Start_Date" />
                    <Value Type="DateTime"> @firstDate!</Value>
              </Geq>
               <Leq>
                    <FieldRef Name = "Start_Date" />
                    <Value Type="DateTime"> @lastDate!</Value>
              </Leq>
           </And>
</Where>
</query>
</list> </root>
New Post
 9/18/2007 12:04 AM
 
Hi,
Yes ERSDE automatically handles conversion of report parameter of type datetime.
Can you confirm that both report parameters are of type "Datetime"?
If so, would it be possible to get a template of your SharePoint list so that I can make some tests?
Regards,

Frederic LATOUR
ENESYS
New Post
 9/18/2007 1:14 AM
 
Hi Frederic, 
               Forgive me, I'm new to Business Intelligence Studio, when I looked at the code, the parameters were indeed cast as a String. I am still working on making the changes, but I'm betting that's the problem. Thanks for the quick reply. Our evaluation of the trial edition of ERSDE is going quite well so far.
New Post
 9/25/2007 11:05 AM
 
Hi,
Just wanted to know if it solved the problem.
Regards,

Frederic LATOUR
ENESYS
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Date FormatDate Format

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement