Recent content by synapsevampire

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...