Re: SQL 2005 Reporting Services querying an Oracle DB

From: <djclothier_at_gmail.com>
Date: 6 Jun 2006 03:25:51 -0700
Message-ID: <1149589551.142567.170190@h76g2000cwa.googlegroups.com>

Update to the Query:

• "SELECT id1.log_date id1.channel id1.operator id1.cellectivity_affiliate_id id1.vendor_name id1.application id1.sub_type id1.transaction_type id1.total id1.count FROM incelligence.log_transaction_daily_view log_transaction_daily_view id1 WHERE to_date(Parameters.startDate) JOIN to_date (Parameters.endDate) ON Value ORDER BY LOG_TRANSACTION_DAILY_VIEW.LOG_DATE DESC;"

djclothier_at_gmail.com wrote:
> Hi J.
> Gave that a try and got te same results too.. I'm not sure if I should
> be looking at the parameters here, or part of the SELECT statement...
> I'm used to managing DBA's, not acting like one unfortunately, so my
> knowledge here is thin on the ground, I admit!
>
> Does anyone know if Oracle has a similar type 'report builder'? I
> thought i could possible build the report in that and see what the
> differences are, - maybe it'll lead me somewhere?
>
> /DC
>
>
>
>
> Jining Han wrote:
> > What about replacing the double quotes with single quotes in
> > expressions like to_date('" & Parameters!startDate.Value & "'....)
> >
> > JH
Received on Tue Jun 06 2006 - 05:25:51 CDT