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!

Register Log in
  • Congratulations gkittelson 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. yenesi

    VB 6 : Crystal 6.x 'vs' Crystal 8.5 (Connecting to DB)

    Can anyone give me the 'Connection' equivalent in Crystal 8.5 for the command in Crystal 6.x that is: CrystalReport1.Connect = 'connection string' I have a report I created in Crystal Reports 8.5 and am trying to get it 'recognized' in a VB app. I keep getting the message: 'Server has not...
  2. yenesi

    Need to print 'one' line on report, from multiple records

    Ido, I must have done something wrong then, as I ended up with multiple columns..... However, I did get the results I wanted (using HTIEKF and Ken's suggestions) moving 'all' the information (group, acct, groupname, Task# (as functions)) to the Group Footer line and suppressing the Details...
  3. yenesi

    Need to print 'one' line on report, from multiple records

    Ido......way too many columns. Using either min or max, creates a column for 'every'date under each task. Each group can have different date/task.....ie; if group 123456 has a TskDt 1/1/2002 for Task44, and group 789123 has a TskDt 5/1/2002 for Task44 that creates two separate columns under...
  4. yenesi

    Need to print 'one' line on report, from multiple records

    Thanks Ido, but that didn't do the trick for me, Dang! ......I had tried crosstab once B/4 .....using 'Count' on the Group # for my summary, and that didn't do it either. Any other suggestions?? Perhaps I should take your suggestion about going crazy and actually enjoy this![upsidedown]
  5. yenesi

    Need to print 'one' line on report, from multiple records

    I am using Crystal 8.5 I have a DB2 'view' (from 3 tables) that includes the following information: Name Definition Grp :Group # ACB: Acct # ACD :Tran date GrpNme :Group Name Tsk : Task # TskDt :Task Completion Date I want to build a report like: Grp ACB ACD GrpNme Task44 Task51...
  6. yenesi

    Show SQL Query becomes 'garbled' in window

    I tried copying and pasting into the query.....same result. It's just plain weird!! I got it back to it's original code....and modified just one line.....same thing again! I am perplexed.
  7. yenesi

    Show SQL Query becomes 'garbled' in window

    I am in the process of modifying a Report written in Crystal.....I believe it was written in version 6. I have version 8.5 Pro. I made a simple change to the 'where' clause to limit the data in the report to a specific 'status' (ie; In Progress). I refresh the report and it works...
  8. yenesi

    Subreporting - empty gaps in main report

    This is my first go around with Crystal (8.5)....so bear with me.. I have created a supreport linked to my main report thru a formula field since there were no 'matching' fields to link on my tables....I have exactly the data I want to see, except that it's not quite as 'pretty' as I would like...

Part and Inventory Search

Back
Top