Search results for query: *

Ok, so I'll first admit that I'm not a great SQL writer. I can get by with the basics and am learning more every day. I haven't had to do this in while. Here's my current code: SELECT CHCASN Carton_#, max(CEDIVT) Divert_Location, max(CECRTS) , max(CDTBPU) Units, CDSTYL||CDSSFX||CDCOLR SKU...

First time posting over in the Office thread. I'm a Crystal guy through and through, but the company is moving directions with reporting and dragging me with them! I've written a SQL refreshable query in a tab called "Data Pull". Within this tab, there are multiple reports be refreshed. I...

I seem to be drawing a blank on this problem, even though in my head it seems easy. Could be the cold I'm battling... So I have two tables that I'm pulling data from: orders ord_list "orders" is a header file that lists all the header data. "ord_list" is a details file and lists all details...

I have two groups in this report. I'm trying to find the number of errors made by a user. My first group is the user, my second is the task. The task could have multiple detail lines so I've written the below formula: whileprintingrecords; booleanvar x; numbervar y; if Sum...

I'm trying to create a report to show what route we need to hit in order to hit goal. In my report, I've pulled in the route #, total units remaining to ship and cumulative total of units remaining to ship my route. I've also added a cumulative total to see after each route, how many units will...

This is not a big question, but I like for my reports to look nice and would like to know how to use this option if available. I have a crosstab with two summarized fields. Is there a way to have a line drawn between the two? I've currently formatted as best I can to have a line drawn...

I'm working with a report that is first grouped by item number and then grouped by locations. It's possible to have more than one location per item number. In my details section, I have a list of sales by order number. The order numbers show up as many times as there are locations and that's...

I have a report that is grouped first on an item number and then grouped on location(s). In many instances, I have two locations for one item. However, I want to bring some of this data into the GH1 section. For the locations we may have a permanent(P) location or a temporary(T) location. Or...

Alright...so I am constantly running or looking for a set amount of data in Crystal reports. Before now, I've just been running the report each time or creating multiple formulas for each list. For example...I have 20,000 SKNs that I want looked up from a list of 50,000. I cannot input all...

Alright, so I've gone through the majority of the threads and I think I'm almost there. I'm trying to determine the amount of time it takes from when a task is created to when it is completed. I have two datetime formulas. One for start and one for end. I'm all the way to trying to get an...

I'm trying to link an access database to table in a Warehouse Management system. The customer provides projected sales in an Excel spreadsheet and I imported into an access database. Before hand, I created fields that could be linked to my WM databases. I have five fields that need to be...

This is probably the simplest of problems...however, I'm trying to show data from each "detail" of a group. For example I'm grouping by @location: So my return will be Location Qty Expd Qty Count Date Counted Time Counted Qty Expd Qty Count Date Counted Time Counted...

I know currently we are only able to include 1000 records to search. Is it possible to expand this number? I have searchedw the forums and haven't hit on any keywords. Your help is appreciated. Thanks, Ryan

I'm having a problem with a shared variable that returns the same data in the main report. I have it sorted and linked by a SKU, but some data does not exist in the sub report that's in the main report. If the SKU does not exist in both reports, it will return the data from the last SKU that is...

I'm trying assign empty locations in a random order to a list of SKUs. I know how to eliminate locations that aren't empty and put it sequentially, but that would fill up one part too quick. Is there a random generator? If you need more information, please let me know. Thanks!

I'm running a report trying to pull in data for sales. In a subreport that is above the main report, I'm trying to share the sales. However, on the main report, it keeps returning the last piece of data it looked at. In my sub report, my formula is: whileprintingrecords; shared numbervar x...