Search results for query: *

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

Yep - checked visioneer - this is my last stop before I throw the thing out the window - I got what I think is the latest driver and I am pretty sure that no service packs have been applied though not completely sure (It's a home machine - not mine) Thanks - Gail

It uses a USB port - I actually changed the port yesterday because the scanner wasn't connecting at all and that did not solve the problem. I have checked the software for all the color settings and all seems well there. (thanks for the reminder - Occam's Razor!) - Gail

Hi all - I have a Visioneer 8100 one touch on a windows 2000 machine - It has been working for years :>) until recently. When I scan, I get an image with no color - its not exactly black and white - but colors are definately not showing - I have the latest driver update that I could find but...

You understand perfectly and that works - Thank you so much!

I am writing a report that looks like this: GH 1a - Student ID GH 1b - SubReport (Student's Grade Report) GH 2 - Faculty ID GH 3a - Faculty and Term Info GH 3b - Faculty Comments Details - suppressed GF 3 (New Page After) GF 2 - suppressed GF 1 - (New Page After) GH 1...