can you set spending report to show zero categories

VGORnovice

I want to reformat my spending report so that there is a line between each 1st level category groupings and that each 1st level category is bolded.

Can you tell the report to do reformat that way?

If not, can you force the report to list $0.00 categories? IF so, I can use Excel to reformat a standard spending template from the.

If not, I suppose I could have an if (search, "each category and subcategory) in the reformatted template to pick up the non-zero categories, but maintain the entire category list in the template.

For those Excel experts, what would the if statement be to add to identify the row from the category in the entire category list that is in the report list?

If (search function below, +b6, " ")

i.e., search entire category list for "Groceries", if found, identify the row (i.e., 6),

[Edited - Readability, Moved to correct section]

NotACPA

For starters, you've posted in an inappropriate forum. This one is about the webpages/community itself, NOT about Q issues.

2nd, since you haven't told us which Q product you're running, or the OS or the Release of that product it's just about impossible to answer your questions.

Lastly, almost all (if not all) Q reports can be "printed" to a CSV file and exported into Excel. Have you looked into that?