Search results for query: *

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...

I think I may have figured it out by using the InStr function which is by default case sensitive. local stringvar stroutput := ""; local Numbervar strLen := Length({table.action}); local numbervar i; For i := 1 to strLen Do ( Local NumberVar charpos := i; if...

I think I may need to re-visit this code because I think that it is not taking into account the character case. Is there a way that I can change it so that it is case-sensitive when it goes through the if statements?

Thanks! This does exactly what I was wanting it to do. Doesn't really matter if people think it's weird as long as it works! :o)

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...

Thank you both. So far it looks like LB's suppression is going to work out, but I have a whole bunch more conditions to include so we'll see how that goes. If not, I think Ian's solution will work and I think it might work out better in the end because I have some header information that I...

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...

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...

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...

The report is based off of 2 tables: Payroll left outer joined to GL table. When I added the GL table, the Payroll amount sum duplicated for every transaction so I had to use a RT. For the GLAmt, I couldn't do a record selection from fields in the GL table so I used a RT based on a formula that...

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...

Oh, I totally agree that maintaining these queries are a nightmare!! But understanding them enough to change them to something else completely is out of my expertise. I did end up with something that works out using SIGN in my first DECODE: DECODE(SIGN(TO_NUMBER(VG.BUDGET_FISCAL_YEAR) -...

Unfortunately, it is within a SELECT statement. Can I use the DECODE to include Year > '2005'? None of the DECODEs that I've seen address > or < values, so I wasn't sure I could use it and/or how to use it.

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...

Thanks for the direction :-) I'm running a few tests of the report before and after my change and it looks like it just really does take forever for the parameters that I'm using. I was using the user's parameters. I tried a different set of parameters and it just a few seconds. This user's...

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...

Thanks! that'll work for me!

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...