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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by crystal2770

  1. crystal2770

    Save results positional

    OH, thanks.. Ill give it a try
  2. crystal2770

    Save results positional

    Im setting the positions in my selection.. But its the exporting that Im having trouble with.. Sorry if this looks 'sloppy', im not professional sql SELECT substring('DEM3',1,4) as '1', substring('006',1,3) as '2', ' ' as '3', substring(rtrim(b.lst_nm)+'...
  3. crystal2770

    Save results positional

    Hi, How can I export my query results so that if field one is 5 char and field 2 is 5 chars, they maintain their positions.. meaning. 1111122222 Currently when I export Im getting a space or comma between 11111 22222 so the system that needs to import the file can not do so without manual...
  4. crystal2770

    concatenate name

    Thanks, this works
  5. crystal2770

    concatenate name

    Im sure its easy but I cant find the way to do this.. I am trying to concatenate the name in my select statement.. b.lst_nm+', '+b.fst_nm HOWEVEr all this gives me is.. NAME ,FIRST NAMELLL ,FIRSTTTT I need the following at...
  6. crystal2770

    File export

    Can Crystal Reports (8.5) create a positional file type export?
  7. crystal2770

    Selection

    No, Im sorry, what I mean is that when it retreives the records, that if the group has 5 records one must have one of the 9 series codes from my selection.. What I need.. Group1 Name Code $ 00001 Test 91000 10.00 00001 Test 00002 10.00 00001 Test 00309 11.00...
  8. crystal2770

    Selection

    I need to select specific data records from the database but cant seem to figure out the formula... My current selection looks like this.. {TPB110_PMT_ADJ_DETAIL.pmt_pst_ts} in DateTime (2007, 01, 01, 00, 01, 00) to DateTime (2007, 12, 31, 23, 59, 00) and {TPM311_VISIT_PAYOR.pyr_seq_no} =...
  9. crystal2770

    Compare dates with time stamp

    Thanks, That was so easy, I fee foolish!
  10. crystal2770

    Compare dates with time stamp

    How do I compare two dates and ignore the timestamp? Thanks
  11. crystal2770

    Export Crosstab problems

    I have designed a crosstab report that has four row headers and multiple colum headersthat gives me the report that I need HOWEVER I cant get the data out of Crystal. When I try to export it as .cvs, .txt, .xls, .ttx.. anything, it just hangs and hangs.. I have shortened my date criteria to one...
  12. crystal2770

    How to read NEXT

    Thank you, that worked nicely
  13. crystal2770

    How to read NEXT

    How do I Produce the following.. Ive been trying for a while and cant figure this out.. this is what is in my report detail Client # Name Ins Type Ins 123 Ann Primay A 123 Ann Secondary B 123 Ann Tertiary C I need...
See more

Part and Inventory Search

Back
Top