Search results for query: *

I am trying to create a SQL Expression in Crystal to sum by part number all forecast in current month. See data below: Part Number Qty Date P4276 100 01/01/2012 P4276 200 02/02/2012 P4276 150 06/13/2012 P4276 200 06/15/2012 P4276 50...

Is there such a thing as a viewer for Crystal? I have a slew of users that need to refresh reports for viewing, but never actually create reports.

I have a Crystal Report that uses a subreport, but when I export it to Excel it always places the subreport data below the Main report data in the Excel spreadsheet. Is there any way to have the subreport display next to the main report data in Excel?

I'm seeing the zero on the GF1b. ...please don't give up on me!

I am attempting to suppress GF1b via the section expert. My thought is that I can place the shared variable on GF1b and then compare the shared variable with the Qty on Hand field. If shared variable is > Qty on Hand then suppress the entire GF1b line.

GF1b

Actually, I just need the shared variable present so I can suppress if the shared variable is less than quantity on hand.

I have followed previous posts regarding this topic, but I can't seem to get the formula to work. I have a subreport w/ this formula: WhilePrintingRecords; Shared NumberVar Ord:= sum({OEPODTL.ODIQTY}) I have added the above subreport to the main report in GF1a. I then created this formula and...

I am trying to link a subreport to my main report via two subreport links: part number and date range. It works fine with the part number, but when I link the date it either returns the current month or all months, yet the date range on the main report is between 01-01-2011 to 02-28-2011. The...

I prefer sql statements. My issue with sql statements is upon creating them they run, but often times take too long or end up crashing Crystal. Any advice for fine-tuning my sql statements (e.g. Crystal sql for dummies)? Thanks, KK

Here's the formula: if {@Open SO Qty Minus Null Values} > {FKITMSTR.IMQTOH} then -1000000 else if {@Open SO Qty Minus Null Values} > {@Fcst + Dep} then ({FKITMSTR.IMQTOD} + {FKITMSTR.IMQTOH}) - {@Open SO Qty Minus Null Values} else ({FKITMSTR.IMQTOD} + {FKITMSTR.IMQTOH}) - {@Fcst +...

I have a formula field in my main report that includes a sql statement, summary and 2 number fields (%sql + {sum of dpqty} - (OHQTY + ODQTY)). This field is in my header. I would like to sort on this field, but it does not give me this option...even when trying to perform a group sort. Any...

Works Great...Thanks!!

I have a report that pulls in a number value from a subreport. Is it possible to use the subreport value in my main report?

I have a running total that shows the 1st result as blank (null). Shouldn't it calculate the first total? number = 8,000 Running Total = blank number = 4,000 Running Total = 4,000 number = 5,000 Running Total = 9,000

It doesn't give me the "Summary" option when I perform these steps. I moved to details, right clicked, clicked on Insert and all it gives me is "Field Heading". Could it have something to do with using a Sum in the formula?

I am trying to sort a group based on a formula... (if isnull({@QOH}) then 0 else {@QOH}) - ((if isnull(Sum ({@Dep. Reqmnt}, {FKITMSTR.IMPN})) then 0 else Sum ({@Dep. Reqmnt}, {FKITMSTR.IMPN})) + (if isnull({%3 Mo. Fcst.}) then 0 else {%3 Mo. Fcst.})) ...the formula does not show...

Thanks! Worked perfectly!!

I need to capture the quantity field of all dates in this month and all dates out 90 days. The problem is, I can't figure out how to grab the quantity field of the dates already passed in the current month.