Recent content by SonOfZeus

I'm trying to build a report that has something similar to this Depart Category Staff Age Years Hidden(Yrs/Age*) 12 Baby Boom 12 20 1 240 12 12 Seniors 6 40 3 120 18 18 27.5 1.66 33...

The problem was in moving from Crystal 8.5. to 10 the shared values of subreports aren't allowed in calculations. It's been determined that for the one report they will leave it at this time. I hate losing functionality when upgrading, I thought Access/.NET were the main culprits. Thanks for...

My apologies, it is the @F_FromLocation formula that was blowing things up, didn't have it in my second report. Is where I actually have to look.

I didn't copy the report, was trying to add the field for the transactional value for Inventory Transaction History report. I did one using the same tables in 8.5, and using a summary command worked fine. as for "AND {@F_FromLocation} = {@F_ToLocation}", I simply removed them from the test so...

I likely did copy wrong, but bracket is there. This formula is stored in a newbalance field that is then used as a factor in multiplying times the rate change. So I've got a TransactionValue = FormulaResult<- field multiplied by current-old rate for the item. It works fine in 8.5, that's the...

I have a calculated field, with a formula inside it that runs fine and can be summarized in Crystal 8.5 When I try the exact same values and formula in Crystal 10.0 it says the "Field cannot be summarized". When I comment out one of the fields (it's fomula below), all works fine. Why would...

I'm trying to create a view that will be used with Crystal Reports, in conjunction with other tables. The table the view is based on is the HR table, with user name and location. If I create the view: select user_name, loc where SYSTEM_USER = user_name This returns the correct result for the...

I'm trying to create a report with tables, not a stored procedure attached to the report. The problem is, I can't find a way to get the users' NT account (Crystal 8.5) into a formula to compare with the HR table in the filter for the division of the individual. I can create a view that uses...

I've found the solution to the problem. I was trying to use database -> location and it didn't let me control the schema. What I found is on the Field Explorer, you can click on the Table/Stored Procedure and it allows you to remap to the correct location (new Schema) I've done this for the...

I've had the DBA and can see the procedure in both Schemas. Unfortunately the Oracle Account isn't defaulted to a Schema and thus needs Crystal to specify which one to use. Right now it will be StoredProc one and if the name exists in both Schemas it doesn't run. How do I change the source to...

This doesn't work as the service is the same for both Schemas. Thus it can't find Schema1.Proc for the datasource, and wants to remove the source and it's fields. I'll look into the connectivity supplies by Crystal, I didn't look for a driver that isn't installed with the software.

I'm using Crystal 10 and the reports are independent of an application, thus I'm able to test and manipulate the report directly. I'm using the Microsoft ODBC for oracle driver to make the connection. The report sits on a RAS server, the problem is I have to change the recordsource from...

As the company has adapted to changes for SOX and creation of new applications for other divisions, we've encountered an issue. In seperating data, we've taken an application from Schema1 and moved it to Schema2. The problem I have now, is how do I change the Crystal Reports to reflect this.

If calling the report out of .NET, perhaps the CrystalReportViewer defaults to a new setting with the RAS. Have you you coded to override the 4 margins on the report?

When security the front end database for my access application, I would like to be able to ensure users are able to read/write/delete to attached tables, but not be able to go to the Database Window and run queries/edit tables directly. It's been a while since I worked with security, could...