Search results for query: *

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

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?

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

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

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