Search results for query: *

I have a report in Crystal 10 connecting to two databases on an SQL server. It uses two tables from one db and an sql command on the other database. Running SQL Profiler, it shows that the command is being executed 6 times. First it does the command and the query for those two tables, then as...

I have a report I'm working on that gets data from 3 sources. First is a database that has two tables I'm interested in, Regions and Stores (where each store is in some region). Then in another database there is an SQL command that does some joins and returns some totals for a given day (the...

I'm having trouble passing a parameter through my VB6 application. The current code I inherited does this: For Each p in Report.ParameterFields If p.Name = "{?a}" then p.AddCurrentValue CDate(Format$dteDate.Value, "MM/DD/YYYY") End if 'repeated for many others Next I added a new...

We have some applications that currently use Crystal 8 reports/.dlls, including crpe32.dll located in system32. We want to update one of the applications to use Crystal 10 reports and the like (viewing and printing). What kinds of conflicts could there be, and how can we get around those...

Ok, I think I have it working now. The query setup was fine, and you helped with putting the parameter into the command. In the end, it was just Crystal Reports doing something weird with parameters and changing things. I started over again working on it and it appears to be doing what it is...

The view gets the data mostly from a table of activity, where a row is added whenever a username on a drawer does something. The problem is that the drawers are inactive on a day-to-day basis, and the only way to tell that the drawer is inactive for a day is to see that there is no activity for...

It works if I use, for example, "V.Date>={ts '2007-10-11 00:00:00'} AND V.Date<{ts '2007-10-12 00:00:00'}". That part of the query is copied from an older version of the report (done in a different way) where Crystal Reports generated the whole SQL query itself. In case it helps, here's what I...

Oh sorry I forgot to mention the version. This report is in Crystal 10. I have tried using the date parameter, and while I get no error messages, I don't get the expected results back. Or rather, I get no results. Also, when you use a parameter in an SQL command, is there a way to see the...

I want to pass a Date (or DateTime, whichever will work) parameter to an SQL command. The Database has a datetime field and I want to compare the value in that field to the parameter. All of the datetimes in the Database should be at 00:00:00 for that day. Previously, I used V.Date>={ts...