Search results for query: *

Thanks a lot... and doh, why didn't I think about that? Cheers Seb

Hi, I have a request that displays result from different tables. Basically it goes like this SELECT view.code, NVL(a.sum_a,0), NVL(b.sum_b,0), NVL(c.sum_c,0) FROM view, a, b, c WHERE view.code=a.code(+) AND view.code=b.code(+) AND view.code=c.code(+) ... this request is off course just a...

Thanx DR and sleip, Sleip, indeed OUR DATABASE is for security reason ;-) DR, I didn't build the code and I would have had 2 users as you mentionned. For the logs, unfortunately, I'm trying to troubleshoot from the distance and I can't have access to them and it will be hard to get them but...

Hello all, I have a weird problem on a PHP site. This site has a administration part. The admin accesses the MS SQL 7.0 with the same string than the site, the same file. The site is working fine but I get this on the admin: Warning: MS SQL: Unable to connect to server: OUR DATABASE in...

Thanks IdoMillet. Indeed, I've been looking into Crosstabs at the moment, but I can't figure out how to make the columns Paid, Budget... And I need a different drill down for each column, but the same drill down for the whole column (no drill down on the totals though) I'm gonna look into...

Hello, I've been playing with CR 9, I've done some nice things but I realize that I don't know how to create the report that I need. Watch out, I think I'm asking a lot ;-) Here's an example of the kind of report I want to create: Rows of Account Number grouped by Group name (both fields come...

Thanks lbass. It's very efficient, and I think I will use this thing a lot.

Hello, I've been playing with Crystal for a week. I haven't been able to find the answer to my question: I am using CR 9. I have a report with a few groups and I would like one of the groups to be hidden and when I drill down, instead of going into the item I'm drilling down on, I want all the...