Recent content by kowalsky

hi all, i need some help on this problem, please. I have a pivot table in a spreadsheet; in the same spreadsheet I have some ranges with some formulae - when the selection changes in the pivot table, those numbers change. On a different spreadsheet I have some cells with numbers calculated...

Is it possible to stick an anonymous pl/sql block into some CR (v9 or vXI) gui and build a report from it? Just as you would do with a SQL statement; if I remember correctly, you could just copy a sql statement, paste it into some pane in CR and then you could build your report based on that...

hi all, is it possible to use one report as data source for another report? Crystal Reports 11, Windows XP, Oracle 8i. Thanks, kowalsky

Thanks a lot pbaldy, it worked like a charm! Can you recommend any good advanced training for Access 2000 - I will be buried in "legacy" stuff for some time and I need to brush back through these things long forgotten ... Thanks again, kowalsky

hi all, I need to replace a field in a Detail section with just a portion of it, and based on that portion I need to bring back another field from some table and either concatenate to this field or add a new one. I hope the info above is enough, the report is quite a bit more complicated than...