Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. synapsevampire

    3 databases, 3 reports, 1 .rpt file?

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

    Crystal XI vs. What?

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

    3 databases, 3 reports, 1 .rpt file?

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

    Retrieve character positons from string

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

    User Selected Date Grouping

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

    Maintaining a Frequently Changing Record Select Expert

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

    New parameters not showing in report

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

    SAP to Acquire Business Objects in Friendly Takeover

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

    Array Size

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

    Error: missing DLL DLGOBJS.DLL

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

    Error while executing report in a client

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

    Comparing values on the main report to those on the subreport

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

    Comparison, Fomula to use for

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

    Formula to count number of items in a group individually

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

    question about set location

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

    MS Access - Can't see queries with subqueries or custom functions

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

    Too much data showing -- join issue or related problem

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

    Query using the command window

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

    Date Ranges

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

    Using NOT in String data type

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

Part and Inventory Search

Back
Top