Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: alembong
  • Content: Threads
  • Order by date
  1. alembong

    Grouping on Multiple Parameter or Container Report Grouping

    CR XIr2 Here's the scenario: I have a container report that is passing a parameter indicating what type of exceptions to display. The options are All, In Service, Barcode or Costs. I'd like to be able to display a different subreport for each exception type that the user chooses or all...
  2. alembong

    Change Characters in String to Value(s)

    CR XIr2 I have a string field where each character (case-sensitive) equals a type of action. I want to replace the character with the appropriate action type. I've tried the Replace function, but I'm not sure how to do multiple characters all at once. I tried nesting, but it would replace...
  3. alembong

    Group Selection Based on Detail

    CR XIr2 Oracle 9i native connection I'm trying to create an exception report based on an existing report, and I think I'm getting stuck in the existing report's logic. First off, the data is similar to this: ID ORG Role --------------------- Bob ALL BASIC Bob ALL ENTRY...
  4. alembong

    Folder Level Security

    Is there a way to allow a small group of people to see each other's instances, but not anyone else's? We have a report set up in a general folder and I was thinking of setting up a sub-folder that only this small group can access. I'd like to set up shortcuts so I don't have to keep up with...
  5. alembong

    Translate Subreport into Stored Procedure?

    We are using CR9, Oracle 9 and I have a report that has several subreports. I think because of the subrpts, the report runs super slow. So, I was thinking that I need to try to recreate the report using a stored procedure. My problem is that I've never created a subreport, but I've modified SPs...
  6. alembong

    Suppress Group Based on Running Total

    Using CR 9 direct connection to Oracle db. Is there a way to suppress a group based on the sum of 2 running totals from another group? Or can I suppress a group based on whether another group is suppressed? GF3 Payroll Code RT sum of Pay on change of field Payroll Code Reset on Group...
  7. alembong

    CASE, DECODE, If Then...

    First, I am not much of a database person. I usually just develop Crystal Reports off of databases. So, I apologize in advance if I'm not being clear. We have a huge stored procedure set up for one of our reports. There are tons of DECODE statements. There is a set of DECODE lines that are...
  8. alembong

    Select Formula Exclusions

    CR 9 Oracle DB I've got an existing selection formula that I need to add one more bit of logic to. The table has this info: Transaction Nbr BFY Document Nbr 10001 2005 AB10000 10002 2004 AB10001 10003 2004 BB11111 10004 2005...
  9. alembong

    Separate One Field to Multiple Booleans

    I have a security table in the database that gives all the Actions allowed for each Security Category. However, the values are held in one string. (yuck!) Cat Actions This is what is granted ----- ------- ----------------------- Cat 1 mPnCd amend, approve, cancel, create, delete Cat 2...

Part and Inventory Search

Back
Top