I tried it and got strange results if I put anything at all in that third parameter. Every row gave the same weird number. Is that what you got? Don't know what you can do about it. Are you trying to just print one department? If so, you can select an account segment value at print time. If you are trying to print side-by-side departments, you could use FRS. It actually comes with a sample side-by-side department Income Statement which you can just modify to use your own department / segment codes. FRS is like a cross between FR and FRx. It's developed entirely in the SDK (web screens coming soon) and doesn't require Excel. It uses the same functions (FRAMT/FRAMTA etc) as FR and has all the same fields (BALP/NETYTD etc) but is much easier to use and has loads of advanced features like being able to print multiple reports at once. It's also very reasonably priced. Not much different to buying an EFT module or something. Not like a BI product which can add up to tens of thousands once you add all the bits and user licences etc. More info here: http://www.dingosoft.co/frs.html

I did get the same number in every row when using the third parameter inline. When using the third parameter in the default line, I would get nothing. This occurs only when there is some criteria in column B. If I leave column B blank, everything works as expected.

The user is actually trying to print many departments side by side (over 20).

I looked at FRS but not sure how it will handle that many departments as it does not output to Excel. The output is over a hundred columns in the current report that the user is producing.

99 is the limit as that's the limit of the Sage 300 grid. (Actually the limit is 100 but we use one of the grid columns for a description). Also, the Crystal report currently only goes up to 26 columns, but it can be increased. It just slows it down if you have more columns. Also, you aren't limited to the paper size of your printer. If you are printing to PDF, you can use any paper size. If you can get the report down to less than 99 columns, I can create the crystal report for you. It's something I need to do anyway. If there are around 20 departments, but over 100 columns, can the columns be split over two reports? You could then include the two reports in a report group and print them together into a single PDF file.

The current report is going over 120 columns already. I think I might have to settle for FR and specify the accounts in detail in a way that I will not need to use column B for specifying criteria. Or, develop a tool to generate an Excel file with the required data. That could actually be a much faster solution.