Search results for query: *

I have a similiar situation here where we need to run many reports with yesterdays date using the Crystal Enterprise scheduler. However, the end user will also be able to run reports on demand, so I don't wish to confuse them by hard coding {?startdate} - 1, then having them remember to enter...

I have created a view which consists of 4 tables with a 'where clause' and an 'order by' statement. If I then call this view and add an additional restriction -- such as 'where {datefield} = today', will the database generate the full record set with all possible dates before saying - hey I...

I am trying to query a linked SQL table date field with criteria as ' datefield <= #6/12/2001#. I am running this query on a win 2000 workstation. When run against the linked tablem, it produces no action from Access. Running the same query on an Access table works just fine. thanks in advance.

I checked the execution plans and the only difference is the row count returned. The nodes in the plan all match up exactly. Regarding the OJ, it works fine for all my other reports, however, when I paste it into SQL Analyser I have to remove it along with the curly braces and double quotation...

Yes, I did try in SQL Analyser with the 2 ips and the timings were 20 secs for each query. The 'execution plan' were also basically both the same. Thanks....

Ken; Here is the sql being generated: SELECT Stats_Site.&quot;SiteName&quot;, StatsSS.&quot;sDate&quot;, StatsSS.&quot;ClientIP&quot;, StatsSS.&quot;ServerIP&quot;, StatsSS.&quot;extension&quot; FROM { oj &quot;Hit&quot;.&quot;dbo&quot;.&quot;Stats_Site&quot; Stats_Site INNER JOIN...

While using CR8, on NT 4.0 sp6 and SQL Server 7.0, my report accesses the database in a timely fashion. ( i know this because i turned on 'count number of records first' option ). However, it then reads approx 2000 records before delaying for about 4 minites before completing the request (...

CM; What and where are you executing to open your reports? Are you in a browser window and what is the query string? Or are you double-clicking on the .rpt file. Kaiso

Thanks Ido, Your comments are truly appreciated. K

Hi all; Is there a way to dynamically change the group otion for 'The section will be printed:' dropdown list based on values prompted for. e.g if the user selects 'monthly' for the reporting period, can I change 'The section will be printed:' to 'for each month'. thanks kaiso.....

Thanks for the help Ken. I will try using sql expressions ??to avoid the conflict.

Hi all; I am using CR8 with SQL7. My report is linked to 1 table in the database. I am creating a date range variable in my formula as such: BeforeReadingRecords datevar d ; datevar range dr ; d := cdate( DateAdd (&quot;d&quot;, -45 , CurrentDate) ); dr:= DateSerial (Year(d), Month(d) ...