Search results for query: *

I'm guessing there was a space present after the last comma in the string list since subtracting one from the length of the list left the comma still present, but subtracting two removed the comma. I realize it seems odd to be displaying the string list with quotes. :-) The report itself is...

Just an FYI regarding the last two items I was trying to accomplish... To remove the comma from the end of the string, I modified the last line in the formula to display the string: left(list,len(list)-2) For the double quotes, I created a text box for the Resources column. In the text box I...

You guys are the best!!! I followed your suggestion lbass and was able to get the results I needed...yay! The final steps will be to remove the comma that appears at the end of the string list (as Ian suggested) and enclose the string list in quotes. Thank you both so much for your help!

Thank you! This sounds like what I'm looking for. :-) I have to step away from this report to complete some other assignments but will try your suggestions and let you know how it works out tomorrow. Thank you again!!

The data for each task is stored in one database table while the time card info is stored in another table. The time card table has fields which reference back to the task table. For example, based on the task number you could run a sql query and find out who did work (has time card entries)...

I need help with how to store values in an array in Crystal Reports 10. The end result I'm trying to achieve is a column on a report which contains one or more names enclosed in double quotes. Here's a sample of what I need the report to look like: ID: TASK: START: FINISH...

I think I got it! hee, hee :-) I added logic to the @DetailFormula to set a boolean variable 'suppressed' based on the value of the variable 'y'. And then in my two formulas, called @SumTime and @TotalTime, which sum up the time for the details in each group and the total time I added logic...

Sorry for the delay in responding! The formula in the Details and Group Footer section is... whileprintingrecords; numbervar x; numbervar y; if (x = 1 and {ae_i_sta_e.status_code} = "REQ MATL") then y := y + 1 else y; x := x + 1; y There are two formulas in the Group Header...

Here's a sample of the details from my report: STATUS: TRANSACTION DATE: LOGIN: ------- ----------------- ------ REQ MATL 1/11/2010 7:25:49AM JDOE BUYER 2 1/11/2010 11:27:37AM BMSITH MATLS ORDERED 1/11/2010 1:46:03PM BSMITH CLOSED/RECVD 1/15/2010...

It's actually a formula you previously helped me with. :) @DateDiff... if onfirstrecord or {ae_i_pre_e.pr_num} <> previous({ae_i_pre_e.pr_num}) then 0 else {ae_i_sta_e.status_date} - previous({ae_i_sta_e.status_date}) An additional challenge I'm running into is I'm suppressing some of the...

Help! :-) I need to determine the sum of the values from a formula field. My report has one group and in the Details section there is a column with a formula, @DateDiff, which calculates the difference in time on a DateTime field. I would like to get the value of the total time for all the...

Thank you for all your help!!!

I think I figured out how to change the logic so the correct group headers would be suppressed as well. :-) I changed the second formula from: whileprintingrecords; next({Status}); to instead be: whileprintingrecords; {Status}; and then changed the suppression logic for the header from...

Brian, thank you for your help with this! The details are now being suppressed, however, the header is still showing up on the report. I did have to change the logic for {@FirstFormula} = 1 to {@FirstFormula} = 0. With {@FirstFormula} = 1 the details I wanted to see were being suppressed...

Yes, I would ultimately like to suppress the Group header and footer as well but figured I'd start with the suppressing the Details first. I'm guessing the logic will be similar... :)

Hi! Anyone know how to suppress all the details in a group based on data in the first record of the group? Here's a sample from my report: STATUS: TRANSACTION DATE: LOGIN: ------- ----------------- ------ REQ MATL 1/11/2010 7:25:49AM JDOE BUYER 2...

Thank you both so much for your suggestions!! I used the logic provided by lbass and it worked perfectly!

Hi! I'm trying to calculate how much time has passed on a DateTime field in CR 10, but am struggling with the logic. Here's a sample from my report: STATUS: TRANSACTION DATE: LOGIN: ------- ----------------- ------ REQ MATL 1/11/2010 7:25:49AM JDOE BUYER 2...

Hi! Does anyone know if it is possible to display a chart within Crystal Reports 10 across more than one page, and if so how? I have a Gantt chart in my report. The amount of data along the vertical axis overlaps and is unreadable. I'd like to have the chart break/display across more than one...

I found the solution on this website! :-) Here's the link to the solution I found... http://www.tek-tips.com/viewthread.cfm?qid=1483052 In case the link gets stripped out I'm copying the text from the solution and pasting below. Thank you to LBass who provided the solution...