Recent content by crystal2770

OH, thanks.. Ill give it a try

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)+'...

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

Thanks, this works

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

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

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

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

Thanks, That was so easy, I fee foolish!

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

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

Thank you, that worked nicely

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