Yes............For the column headings, we use expressions based on a Language prompt. The expressions points to a list. After further research, we think it may be related to...

Thanks for your help. I will definitely look at this for my report

Thanks...........Can you point me to something that shows how to use the lookup function? I ended up with a large nested IIF statement to resolve my question. Thanks......

Thank you for your reply. I ended up using INTERVAL to resolve this issue. Thanks again

Jeff..............Thanks for the help. No problem on the delay. I'm really new to writing sql and use these forums to help solve the things I'm trying to do....

The sql is below. The field is "note_txt" and the table name is "notes". I've replace the IN with a parameter and have also created 2 parameters for...

Thanks for the suggestion. I ended up changing the sql to only pull in the branches I'm using for the main dataset and didn't use the filter. I'm...