Search options (Page 7 of 7)

Thanks for sharing these methods folks- they are very clever alternatives.

Hi Derek,

Okay, that works.
Yea, I suppose printing is uncommon these days, so FastReport probably isn't used as much.
Thanks again for all the input.

Derek,

You are correct. That was an added (edited visual) to show more than 1 or 2 at a single store. Sorry about that confusion.

Thanks for the help on the group definitions. I wasn't able to stumble upon that combination, but that's what I was looking for.

After adding more data and spacing detail, I also had to check the "Reprint On New Page" GroupHeader option for the first two groups. Just in case anyone else needs a similar result.

I noticed that you switched the drawn line that stretched across the page to using underlined text. But there was also the shaded gray rectangle background for the stores. I was hoping to use those as alternating bands whenever there were a lot of stores listed below a business for visual cues.

Could you or maybe anyone else demonstrate conditional drawn objects using expressions or code? I have seen a similar technique done with TableGrids. Is that possible with reports?

You answered my main question. These are mostly visual formatting questions, and so I'm just exploring the possibilities. Using MVD, I'm attempting to recreate a report that resembles one that was generated in the past using another similar database solution. So, again I appreciate the reply.

So, I noticed when viewing the data from SQLite Studio, that calculation field `cfphone` was missing. This was causing the error for a custom SQL query. After searching, this seems to be a limitation with SQLite.

This may be obvious to some, but I wanted to share this observation for those less skilled with both MVD or SQLite.

derek's solution still works, but it must be applied in a different place when a custom query is necessary.

SELECT
    test.name,
    '(' || substr("phone", 0, 4) || ')' || ' ' ||
        substr("phone", 4, 3) || '-' || substr("phone", 7, 5) AS phone
FROM
    test