I have a table calles basictext

Create table basictext
  (serialnum int not null, basictextid int not null, basictext varchar(255)
not null)

data examples:
Serialnum          Basictextid  Basictext
1               1100000024      This is a test , This is a test
2               1100000024      This is a test, This is test 2
1               1100000025      This is the second test
2               1100000025      This is the second test
3               1100000025      This is the second test

For example
I need to bring back all of the Basictext for Basictextid 1100000024 into
one field for Crystal reports.

I've tried inserting all off the rows for a certain basictextid into a text
field in a text temporary table

Any ideas would be appreciated?

You could use a stored procedure that would return a resultset with a record
for each DISTINCT BasicTextID which concatenates the BasicText fields
together, and then connect your crystal report to that SP.