Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pace
Constraint Violating Yak Guru
264 Posts |
 Posted - 2008-01-24 : 06:47:16
|
Hi,I have a report. Now this report is used for quoting. I have written a new fancy text generation tool which is required by my company.Now my reports products, dont always have a generated description available. When this is the case there is a routine which obtains a different description.As I cant change a bound text box at runtime, I have an unbound box, over the generated text box which is not visible by default.When running through the format for each product, if the generated desc is not available, my unbound box gets its data and is then set to visible.The problem I have is that I only want to show this non generated desciption for the product that it cant find one for. Whats happening is when the unbound bx gets set to visible, its visible over all the products. I just wanted to show it for the product it was detailing for.I hope this breakdown is understandable.ProdA - GeneratedProdB - GeneratedProdC - NonGeneratedSo I only want to show my unbound box for C... whats happening is its showing the text it obtained for C over A, B and C as well as the generated for A & B ... I would like A + B to be as they were generated, and only show the non generated on C.The code is fine as it all works, its just this detail formatting issue I am having. Here is a picture which might help clear things up. As you can see, C is appearing many times, I only want it to appear at the bottom. There is a hide duplicates option, however it puts C over A then.Here was me thinking that the detail format just ran down the list, that would be too logical no Anyway any help on this would be immensely appreciated. "Impossible is Nothing"  |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2008-01-24 : 06:48:53
|
| oh I forgot, Access XP"Impossible is Nothing" |
 |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2008-01-24 : 08:56:39
|
| ok I have the answer, its strange... My code; IF CantGenerate = True DO ThisEND IFdiddnt work (correctly as I expected)however IF CantGenerate = True DO ThisELSE DontEND IF Works. Now I would have thought that the first IF handled everything, I wouldnt have thought I had to tell it to not do something, as it would only start to do something if the first if statement was satisfied. Obviously I was wrong. Is this just something with Access reports or should I be adopting this technique elsewhere? Thanks for reading."Impossible is Nothing" |
|
|
|
|
|
|
|
|
access report formatting (inc Screen) RESOLVED