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 ended up just not breaking up the groups between VAS and normal. I just listed another column to show the VAS orders vs the normal orders. Sorry for putting this out there. Thanks, Ryan

I'm grouping on the field that is using a formula to indicate if a bill to has a VAS. So for instance, if someone orders online(we will say is bill to "A") and does not get a VAS then the SLA is one day and I want to be able to measure against that. If someone orders online (still bill to...

Any thoughts on this?

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

Pete, Appreciate the support. I had already tried this and it did not work. An e-mail has been sent! Thank you again for your help. Ryan

Ok, I now know why that it's causing the number of some to inflate by one and not others. If the last row of data for the formula above is true and it adds one, it will also add one in the group footer because it tries to evaluate the formula again. The good news is I know why it's happening...

I need to bring this back as I am now back temporarily on this account and this was not resolved while I was out. The formula that is in my group footer is as follows: whileprintingrecords; booleanvar x; shared numbervar y; if Sum ({THAUDT00.THEXQT}, {THAUDT00.THPLN}) = Sum...

Pete, Appreciate the help! Unfortunately, I tried the new formulas and it still doesn't seem to be working properly. Here are my formulas: whileprintingrecords; booleanvar x; shared numbervar y; if Sum ({THAUDT00.THEXQT}, {THAUDT00.THPLN}) = Sum ({THAUDT00.THACQT}, {THAUDT00.THPLN})...

Ok, so what I thought worked, only seemed to work about 80% of the time. I'm still using the formula above only I made my y variable a shared variable and set a reset for it in group header 1. My y variable seems to work all the way through until my group footer 2. And again, it only works...

Nevermind...I made it a shared variable Y and then just made a reset formula. Just had to take a step back... Sorry.

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

Nicely done. Thank you for your help.

And since reading your comment, I realized you're going to try and suppress the group footer fields, so I'm now at the point where I'm only showing routes that have more than the goal. So I'm half way to the formula you were going to write. Now my problem is, how to suppress all the routes that...

Yes, in order to get the running total to work properly, I had to place all the data in the group footers and all other sections are suppressed.

Sorry, your data is hard to read, but would creating a cross tab help? You could have your store as your column fields along with all of your budget information. You may need to create a formula for the rows, because based on the above, you want to total each week and month. That's going to...

Ok, so I've uploaded a file below. To explain what each column is: Column A : Route # from the data source (warehouse management system) Column B: Formula taking Total Units by Route and subtracting them by shipped units by route to get remaining units by route Column C: Taking the running...

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

Any ideas?