Search results for query: *

Try the command Object if they're on the same server. -k

The closest might be SQL Server Reporting Services. Crystal is #1 for a reason, and you might find that problem resolution is your concern, not the product. It's usually the result of people designing reports that have very little database and Crystal knowledge. Try posting what the problems...

Try posting the type of database... You might use a Command Object (listed as Add Command under any SQL database type), and replace the database name with a parameter. Or you might use a Stored Procedure and pass the database, or perhaps even a View might be used. -k

Try posting what the formula used by "to later be used in another formula" is. -k

Ooops, was simple until semi-monthly, but it's all doable. So a record selection might look like: if {?MyDatePromptParamter} = "Weekly" then {table.date} in lastfullweek else if {?MyDatePromptParamter} = "Bi-Weekly" then {table.date} in minimum(lastfullweek)-7 to maximum(lastfullweek) else if...

If you always want different divisions, then you might use a paramter to prompt for the division. I'd see to it that your dba is relocated to a division outside the company, that's just a silly, yet too common, poor relational design. Now some solutions might include a large UNION ALL as in...

Added 2 new parameters to the Stored Procedures? If the parms are being used by SPs. then that is where you need to add them, then issue a Database->Verify Database -k

Hmmm, guess we're SAP consultants??? http://blogs.zdnet.com/BTL/?p=6530&tag=nl.e539 -k

Not that I'm aware of. However you might switch to a secondary array once you hit 1000 by testing for ubound(yourarray), which is the size of the array. I suspect you should post technicqal information and requirements, perhaps there's a better means than using arrays, they can skewer...

An MS Access app was generated using Windows XP Home and Access 2003. When trying to run it on any other system we get a dialog which states: On Vista and Access 2007: Can't Find Project or Library On XP Pro and Access 2003: Broken reference to file DLGOBJS.DLL When I tried to use...

In one client" is too vague. A Crystal Report cannot run without Crystal installed, or some sort of viewer, so the short answer is that it won't work. Were you to post technical information I suppose we'd learn that you have some softwaere which allows them to run. This shouldn't be assumed...

You're probably better served to post: Crystal version Database used Example data Expected output Then request assistance with the requirements, rather than stating how we must do it, such as using a subreport. Anyway, you can use shared variables in the details section of each report to pass...

Please give some indication as to what the output should be... -k

Select reset for each month field. This assumes that you are grouped by the date/month. -k

Recreating the CR query means what in technical terms? You use a Command Object or the table directly? If you use a Command Object, add in a parameter and insert it wherever the table name is used witin the query. Now it will ask you for the table name each time you run it. If you intend to...

Try File->Options->Dtaabase and turn on Stored Procedures. Should show some of them anyway. The natue of real SQL and queries is not the same as Access, hence your difficulty. -k

Please include your software version with any post about any product. It has little to do with "tightening" your query, it's that you are using the joined tables fields for the first time, so it honors the join. Try no record selection (please don't make up technical terms/phrases such as...

It works that way because you designed it that way. Create the parameters within the Command Object window and apply them there, as well as any other criteria. -k

As dgillz points out, there's no reason for a range if you're not entering the second date. So for the second date use a formula based on the parameter: if month({?MyDateParm}) > 6 then cdate(year({?MyDateParm})+1,6,30) else cdate(year({?MyDateParm}),6,30) I believe that's what you're after...

Like and <> are the same in terms of searching foir the same spelling, how they differ is that you must use LIKE to use the wildcard. If you want to check for speeling erros, you'll need to provide a mask for each: ( not({HISTORY.DESCRIPTION} like "Left Voice*") ) and (...