Search results for query: *

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

How do I go about linking an excel spreadsheet information into Crystal or an Access Database. Any documentation or help on this anywhere? Thanks for your help guys..it has been very good up to now.

The problem is that I was giving a list of items to be pickup by a search criteria on a field,"ITEM_ID". They want to get a description of these items, vendor, Country..etc.. The problem is, that we have over 10,000 items in our database and they only want me to select 3000 items which were...

Thanks will check Forum 3

How do I use the criterion in your selection and can I input 3000 items in there to be compared against that one field , 'INVENTOR.ITEM_ID'? I am new using crystal. You see this task was given to me. I did not choose to do it. There must be an easier way.

Hi everyone. I am encountered with a problem when searching thru a single field and only getting results based on those values. Here is a short version of that statement being used: {INVENTOR.ITEM_ID} in ["180860","180960","180871"] Here, I only have three values but I need to search over 3000...