Recent content by ginaburg

That worked great. Thanks for all of your help.

After putting in a grouping for approver, both of your suggestions worked. Thank you. Here is what I have for the date difference between approvers if {APUI.APRef} = previous({APUI.APRef}) then totext(datediff("d",previous({APUR.DateApproved}),{APUR.DateApproved}),"#",0) + " days" else "" Now...

The records are sorted by invoice number but where does the approver come into the formula. I need to see that Group 1 - Invoice 123 approver 1 approved on 12/3/14 approver 2 approved on 12/6/14 approver 3 approved on 12/15/14 with the number of days between each one.

I am using Crystal 11 I am trying to get the difference between dates based on the approver of an invoice. Approver 1 approves invoice on 12/3/14 Approver 2 approves invoice on 12/6/14 Approver 3 approves invoice on 12/15/14 I need to get the number of days between approvals. My fields are...

Im using SSIS 2012. This is the expression that I have on my field. The paymethod field is char field of length 1 I am trying to say if it = C then put "CHK else "EFT. How can I write this expression when I want the output to be 3 char. The following give me an error [Flat File Destination [35]]...

I was wondering if someone can help me with some of the flow for this project. I am farily new to SSIS and seems like there are several way to accomplish what I want to do. Just trying to get some input before I go in the wrong direction. Here is what I need to accomplish. We need a fixed length...

I ended up doing 3 cross tabs. The original one, one with just Minority and one with male/female. The problem I had from there was to supress the columns that I didn't want. I went into the group and selected specified order, listed the ones that I wanted to set it to delete all othere. It...

It's a SQL database but it is written off of a stored procdure.

The cross tab works great and it also taught me a little more about cross tabs. If I could bother you with one more question. For the race formula, I have select {brptPRWklyCompliance;1.Race} CASE 'I': 'Amer Indian' CASE 'A': 'Asian' CASE 'B': 'Black' CASE 'H': 'Hispanic' CASE 'W': 'White'...

I was thinking along the same lines with a cross tab but since I haven't worked with then that much and wasnt sure how to group the formulas, I didn't go that route. thanks for the information. I will give that a try.

I would still need each class. It would look something like this (partial list) Total Total Minority Hispanic Black Asian Male Female Male Female Male Female Male Female Male Female Apprentice 5 2 2 1...

Thanks for the input. So you don't think there would be any way to combine the formula? I'm still going to have about 50 formulas.

I need some help on how to consolidate my formulas. I was thinking I could use CASE but not sure how to put it together. I'm using Crystal 11.5 Here is an example of two of my formulas. I am then using Print to put them on the report. Everything is working but I have 7 different classes. Then I...

When I do that, I only get January 2014 data. So I tried something and put both years in one grouping like this. if {PRJC.PREndDate} in cdate(2013,01,05) to cdate(2013,01,26) then 'January' else if {PRJC.PREndDate} in cdate(2013,02,02) to cdate(2013,02,23) then 'February' else if...

I changed my grouping to have the year group first but it still does not work. For the year group, it's giving me January 2014 data and the month group is giving me January 2014 data. I'm not getting any data for 2013.