Search results for query: *

Your formula should being with: Whileprintingrecords; -LB

Not({co_name} in ["Co_A","Co_B"]) Or you could use: {Co_Name}<>"Co_A" and {Co_Name}<>"Co_B" -LB

If you reversed it so that the subreport items were the main report and the current main report was the subreport, you would get the desired output, I think. -LB

If this is still not working, it could also because of how you linked tables--perhaps an invoice date to some other date that is forcing the recurring group. -LB

I think you should verify that the group is still on change of month by right clicking on the group header in design mode->change group and look at the bottom of the first screen. I'm wondering whether you actually grouped by datetime on change of day in the first tab and then only changed the...

Take a look in design mode to see if you accidentally moved the group header into a detail section. If this is not the case, please show a screen shot of your report in design mode. -LB

I think you must have another higher order group that is forcing the repeats. What is your group structure? Try going into design mode and moving the month group above the other group. -Lb

You need to check for nulls or field lengths < 10, as in: If isnull(field) or Len(field)<10 then "Unexpected value" else Mid(field,4,8) -LB

It appears the problem would be resolved if you could just make the subreport disappear. You can't suppress the subreport directly or the section it is in directly, because then the shared variable won't pass, but you can do the following: Within the subreport, suppress all sections. In the...

You left out the most critical information--the content of your formulas for the good and bad minutes. Assuming these are conditional formulas, the total is available to you in each crosstab by adding a formula without the condition, and you can then calculate within a crosstab. You could easily...

If mid(field,instr(field,"-")+1)="9" then amount Insert a sum on this formula to get the summary at your desired group level. If the codes are always the same length, you could use: If mid(field,8)="9" then amount Then insert the sum on that. -LB

Remove the sum() from your formula and then insert a sum on the formula. -LB

When you set up the running total, I think you can just do a distinctcount of item number, evaluate on change of item number (no formula necessary), and place the running total only in the details_a section. If you want the count to reset within a certain group, then in the running total, add a...

What are you grouping on? Is the subreport linked to the main report on the field you are grouping for Group #1? So you want the total from group #1 to appear unchanged in each Group #2 header? -LB

You should set up Parameters {?Start Date} and {?End Date} parameters in each subreport and ditch the date range parameter. Be sure to change your selection formula within the subreports to use the start and end date parameters and remove the date range parameter BEFORE you try to do the...

I think you should check your data to make sure that the data consistently has all decimals. -LB

You can group on this formula: trim({table.invoiceno}). -LB

You could set up a parameter {?Export} with options Y or N and then conditionally suppress the group header {?Export}= "Y". -LB

It looks to me like you need to reconsider your joins for one thing, keeping these things in mind: 1) a right outer join will return matching records from each of the two tables and also records from the right-hand table with no matches in the left hand table, e.g., your link between tblaw and...

I'm wondering about your joins. Can you please copy your SQL Query into the post? Just go to Database->Show SQL Query and copy that. -LB