Recent content by smitty691

Hi all... I have a list of names... Brian P. Bennett Mario Puzo Hugh E. Hefner Lucy Arnez I have used the following code to concatenate them... WhilePrintingRecords; Shared StringVar ConCat; If ConCat = "" then ConCat := {table.field} else if not({table.field} in ConCat) then ConCat :=...

Wow pmax9999, it looks like that is going to work. Thanks! Now I have to figure out what you did so I can help myself next time. [pc2]

Thanks for your input. What you said about the 3-step breakdown is helpful.

Hi My data table has a field for names of honorees. In the data source table the names in that field are ... Smith, John; Smith, Jane; Roberts, Sam; Roberts, Karen What function do I use so that CR XI will display on my report... John Smith, Jane Smith, Sam Roberts, Karen Roberts I'm...

I have Outlook 07 on a Vista OS Dell desktop. When Outlook send/receives the folders pane on the left will show new unread messages (the blue number beside 'Inbox') but they don't show up in the Inbox until I click another folder and then come back to the Inbox. Any ideas?

I have a simple report that uses a table to display the data. I have the page size and interactive size set to 11x8.5 so that the report will print in landscape orientation. When I deploy from BIDS to the Reporting Services portal, everything works fine. We have a main folder that we store...

I have a matrix report that has columns that, for now, have no data, but i need them to appear when the report is ran. Is there any way to force this? I saw a thread (thread1462-1411556) where someone was asking the exact question but I'm unaware as to whether or not he found a solution...

adding this to the query did it: TO_CHAR(database.sales_date, 'Q') AS QDATE and then grouped columns on QDATE Thanks so much for all your help!

xlbo: how do i do that in a sql select statement?

How do I group the column headings on a matrix sales report to use quarters (like Jan thru March) instead of month name or month number?

Thanks so much to both of you for responding. I ended up using genomon's code but that whole 'hasdata' concept is going to be very useful in the future.

I hope that Subject Line was accurate. Here is what I'm working on: I have a report that will show Donors, the last contact, and the next planned contact. All this info comes from seperate tables. A Donor Bio table, a contact table, a planned move table. I have queries set for the contact...

Thank to you both! Works like a charm!

Thanks so much for the input. Question: When I go to that security viewer for my computer here, it's blank. What have I done wrong?

I have a medical office that is running a small peer to peer type network. Some of the configurations are being changed and no one seems to know who was where when. How can I get the computer to log (or keep track of) who is logging onto the machine when? Is there some way to have the machine...