Recent content by cvasquez

Hi everyone! Currently I have a report using Crystal Reports V10 that was customized to be used as label template. Now, my company would like to have this template converted into a tabular or Column format. One way is to recreate the report but is there an easy way in Crystal v10 to do this? If...

Awzome. Thanks.

Easier said than done. I am new to Crystal 10. How do I set up the running totals? I believe I have to set up a counting field to keep adding the totals field, {SYSCUST.YTD_PURCH}.

Hello everyone. I have created a report that breaks currently on state field,{SYSCUST.STATE} by having a group header. Now I am being asked to have a running total to also break on state field. The running totals field data information is coming from {SYSCUST.YTD_PURCH}. Please help thanks.

Great. I did. It works. AWZOME. Thank you everyone!

Awzome. Ecellent. Thank you.

1. How do I break a next page based on State change, {SYSCUST.STATE}. 2. I would like to add the state field ontop as a header document but to print only when there is a change of state. Please help.

Will re-estate what I had said before because it is very important. Line above says: "Before I was doing: {SYSOENT.ORDER_DATE} = MINIMUM({SYSOENT.ORDER_DATE}) And by doing this, I was missing hundreds of records." This command actually grabs the first minimum date NOT and I repeat NOT found...

I am stuck in this area. Any help?

Okay great. There is a good start. Before I was doing: {SYSOENT.ORDER_DATE} = MINIMUM({SYSOENT.ORDER_DATE}) And by doing this, I was missing hundreds of records. Now that I implemented what you had told me. {SYSOENT.ORDER_DATE} = MINIMUM({SYSOENT.ORDER_DATE},{SYSCUST.CUSTOMER_ID}) I get an...

Hello everyone. These are the fields that I am using on the report. CustomerID, Company Name, Order Date, YTD Purchase I am getting multiple occurances on CustomerID because I am using a date Range using Order Date field. The data is not duplicated in reality because within that Date Range...

From a report that I created, there are two group headers item number and totals. I want to now create a summarization at the end of the report with the totals from group header. How do I do that?

Thanks. It kinda help. I found a way to create it using the wizard.

SQL enterprise statement is as follows. UPDATE TABLEA SET TABLEA.description = TABLEB.description WHERE TABLEA.style# = TABLEB.item But I can not bring these Access tables to SQL enterprise due to security issues. Thanks and hope to hear from someone soon.

Hi everyone. Currently I have the following scenario using Microsoft Access 2003. TABLE A style# description vendor country TABLE B Item description vendor country I would like to combine both tables by using the TABLEA.style# and TABLEB.item into TABLE A, since table A has additional...