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
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...
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 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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.