Search results for query: *

Sorry again... the PROPER declaration is.... DECLARE @CustomerItems TABLE (Customer_ID VARCHAR(50), Item_in_cart VARCHAR(50), ItemRank INT) man.. it's been a long day...

Oh.. and don't forget to declare the @CustomerItems table.... DECLARE @CustomerItems TABLE (Customer_ID VARCHAR(50), Item_in_cart VARCHAR(50))

If you are using SQL Server 2005, you can use Common Table Expressions to solve this problem. Try something like this... INSERT INTO @CustomerItems SELECT Customer_ID ,Item_in_cart ,ROW_NUMBER() OVER(PARTITION BY Customer_ID ORDER BY Item_in_cart) AS ItemRank FROM Customer_cart; WITH...

Right click on the actual line on the chart and go to Series Options. Verify that the Line Style is "Lines Only".

In your case, select number_ID from the linked fields list, and make sure that the dropdown below "Select data in subreport based on field" is set to TABLE_NAME.number_ID.

You are prompted for the parameters because Crystal was not supplied a value. Right click the subreport and choose "Change Subreport Links...". Then make sure the proper fields from the available fields list are added to the fields to link to list. In order to stop the report from prompting...

Sorry, lbass is correct. My formula is actually backwards.

Right click the Comment field and go to "Format Text...". Click the suppression formula button to open the formula workshop. The following formula will suppress the comments if the order is not overdue: {@Due_Date} < CurrentDate

When you run the report in Crystal, do you get prompted for JobID? Also, I noticed that @JobID and @ReportUserGUID are different data types. This probably isn't your issue, but it would probably be best to make them the same data type.

Create the following formulas to return the units for each billing category: {@3rd_Party_Units}: IF {Billing} = "3rd Party" THEN {Units} ELSE 0 {@Medicaid_Units}: IF {Billing} = "Medicaid" OR {Billing} = "" THEN {Units} ELSE 0 {@Client_Units}: IF {Billing} = "" THEN {Units} ELSE 0 Place this...

Maybe you could try converting the field to a datetime in Crystal, and leave the field as its original data type in the view.

If you want to check to see if the parameter is NULL instead of "ALL".... (ISNULL({?pTheTitleAlpha}) OR {vTitleAndSection.Title_Alpha} = {?pTheTitleAlpha}) AND {vTitleAndSection.Title} = {?pTheTitle}

Try this: ({?pTheTitleAlpha} = "ALL" OR {vTitleAndSection.Title_Alpha} = {?pTheTitleAlpha}) AND {vTitleAndSection.Title} = {?pTheTitle} If {?pTheTitleAlpha} is "ALL", return TRUE and go onto the next comparison. Otherwise, compare {vTitleAndSection.Title_Alpha} to {?pTheTitleAlpha} before...

In your record selection formula you could have: {Date_Field} >= ParamDate AND {Date_Field} <= DateAdd("m", 12, @ParamDate) Then group by {Date_Field} for each month. You could then do a crosstab or a chart displaying your amounts on the change of {Date_Field}.

What are the columns of the Service and Billing tables?