Recent content by thread

Hi all - I have a report that consists of a list of people in a department who have made budget requests along with the payments for those requests. It is grouped by department, person, request id. The detail area holds the payments for each request. A request can have more than one payment...

Thanks Brett - this experience is making me feel a bit stupid I admit - and I really do know how to write reports - its the little things that I get stuck on - off to write a subreport! - Gail

Thank you - it always is easier than I make it - and why isn't that in my darn book?????

Hi all - I'm new to SSRS, coming from Crystal so sorry if this is a simple question but I can't seem to find the answer. I want a group header to extend past the column that it is put into like this: Group Header that is very long Data1 Data2 Data3 Data1 Data2 Data3 Data1...

Hello - I am using Crystal 10. I have a subreport, using a crosstab that is there only to format a list horizontally rather than vertically. I have one column, no totals. I want to supress all the borders and seem to be unable to do so. I know I have done this before but maybe not with this...

in the data.

Yep - thanks Greg - I could do that. I'm being extremely obstinate here. It just seems like it should work - and I can't figure out what's happening....

I'm just using the export function in Access 2007 - export to text file and export to Excel.

I tried: Replace(Trim([ADDRESSBLOCK]),Chr(13) & Chr(10),"/n") and Replace(Replace(Trim([ADDRESSBLOCK]),Chr(13) & Chr(10),"/n"),Chr(13),"") and Replace(Replace(Trim([ADDRESSBLOCK]),Chr(13) & Chr(10),"/n"),Chr(10),"") all three give me the clean address in Access - no nasty character...

I'm not using Word - just pasting the offensive text into word because its the only place I can see what I'm dealing with. Remou - I tried your fix to no avail - here is the text from the same address: Direct from Access after the Replace: 17A, Blk C, The Crescent/n11 Ho Man Tin Hill...

I'll try it - however, I'm suspicious because of the difference in the results I get when cutting and pasting the text into Word pre and post export - they look very different. Worth a try though - I'll let you know - Thanks - Gail

Looks like this: Replace(Trim([ADDRESSBLOCK]),Chr(13) & Chr(10),"/n")

I am trying to export information from an Access query to a tab delimited text file so that I can import the info into another database. Here is the problem - I need to import multiple address lines into one field. The database accepts "/n" to determine where to split the line. So - I run my...

No - I didn't think of it - I will work on it this weekend and see how it goes - Thanks again everyone - Gail

Thanks for your help - I'll try tech support and reinstall (but its so satisfying to open that window and let fly!) - Gail