Search:

right(replicatestring("0", 10) & totext({table.field}, 0, ""), 10)

Look at the help on the DateDiff function, specifically the last example.

If you're not expecting the duplicates then maybe your linking is wrong.
You could also try ticking the Select Distinct Records option in the database menu.

Maybe the OR should be an AND

Create a boolean parameter, e.g. called Show.
In the section expert for the detail section, enter a condition in the Suppress formula (click the 'x-2' button alongside the Suppress option). Enter a...

Or just choose the group's options (group expert, highlight the shipdate group, press the Options button) and change the 'This section will be printed:' to 'for each month'

Group by event. Record selection by date > currentdate.

Option 1)
Sort by date ascending. Print in the group header.

Option 2)
Use the group selection formula to get the minimum date per...

Have you used the parameters in the record selection formula? e.g.
{table.date} in (?BeginDate) to (?EndDate)

Look in the help at DateSerial.
DateSerial(Year(d), Month(d) + 1, 1)

Look at the help on DateAdd and DateSerial.

How are you getting the 'partial total'?
Are you using a formula, e.g. in the details, to increment the partial total, and another to display the partial total in the page footer? If so, create...

Use the 'Reset Page Number After' box in the section expert, e.g. in the client group footer.

It looks like Crystal Fire and I have understood your question differently.
Do you have a field which contains the string "(jan,mar,jan,feb,aug,sep,jan)" and you want to know how many times Jan...

When you wrote "I do use groups already" I kind of assumed that you were grouping on the ClientID as that is what we were discussing...
What groups do you have? You can add groups without affecting...

Use this in the details formula then
if {table.tran_id} = maximum({table.tran_id}, {table.client_id}) then
...
else
...

What section is the subreport in? How did you do the linking?

Or use the group expert. Group by client, group selection formula is then
{table.tran_id} = maximum({table.tran_id}, {table.client_id})

You may just need WhilePrintingRecords in the formula.

I guess you should check the type, options etc. of the parameter as I do this in CR XI without problems.

You could use Split to get each element into an array and then loop through them.

I think you'll need wildcard characters too for Like, i.e.
"*cement*" etc.

or look at the InStr() function

Have you looked in the help at Hierarchical reports?

What's the maximum quantity?
If you can create a table in the database then create one with one numeric column and 'n' rows where each row has a quantity number in it. e.g.
create table...

I'm guessing the obvious question is why do you need so many? 90 subreports per detail record - that's a lot of processing! Wht are you doing?!

See the help on the Sum() function. Put something like the following into the group header formula to set the category column:
local numbervar po_total := Sum({table.invoice_amount},...