Search results for query: *

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...

Thanks so much to both of you for your speedy replies. Here's the rub -- the owner says that this solution is unacceptable because they have to log into the local machine. I need an answer that will allow them to acquire the permission to load software from the server when they log in on the...

I am setting up a domain network in an office of approximately 10 users. I don't want to leave all the office workers on domain admin priviledge but the owner wants them to be able to install software on their particular machines. What is the best way to allow them to be able to install...

I have a monthly report I created for someone in out CADD department that i designed to be printed and emailed (snapshot) as if it's on 8.5x11 paper. Now my 'customer' wants to print on 17x22 for a display outside his office. Do I have to design another report with that page setup in mind or...

I have a network that has both wired and wireless machines, w2k pro on them. They all behave fine on the network. They can see the internet, see each other, can exchange files. There is one laptop with XP Pro. It can see the network, can ping server successfully. When you double click...

change it to... Action: SetValue Item: [DATE_APPROVED] Expression: Now() take out the equals sign...