I have to use a SQL command in order to write a crystal report and join 2 tables. The reason for this is that I need to link 2 fields but remove a few letters at the beginning or one to get them to link
FROM "mdb_rpt"."dbo"."gci_requests" "gci_requests"
LEFT OUTER JOIN...
Hi All - So I am having a problem with a report I am trying to create in crystal XI
I have 2 fields - Reported by and Assigned To
I want to total the Incident numbers with a distinct count for the Analyst that would either be Reported By or Assigned To
I also want a distinct Count of the number...
I have a field that is being pulled that I want to summerize. For example I have one field that pulls a drill down of categories ex)
Server.NetApp Filer
Telecommunications.Account Management
I want to write a formula to stop the text at the second period and group totals by that
Is there a...
Hi All - I have an inno setup .exe that I am running silently by /silent - in the install I am getting an install of a toolbar. Is there a command to either record my install or put a command in to do not install the toolbar?
thanks
Hi - I have a field that is unix time (View_Request.open.date). The field is a number and I have converted to a date/time by the formula
dateadd("s",{View_Request.open_date}-14400,#01/01/1970#)
what I need to do is run a report by time range, for example all Incidents opened between 5pm and 7am...
Hi All - not sure if this is the right forum but I am looking to find out if there is a limit of how many favorites can be stored on IE6 or IE7 - if any
I am thinking there might be but at such a high number it is unreachable
Thoughts?
Thanks
lorri
Hi All - Looking to see if anyone has ever encountered the TouchPad option missing from the BIOS. The trackpoint is listed but the touchpad option below it is gone. The BIOS was updated with the 3/30/06 version on the Lenovo site. I updated another Z60T with that BIOS and the touchpad option is...
Is there a wat to set up an ODBC setting for a connection through ole db (ado)? I can set this up to run a query in Crystal Reports XI but not anywhere else. I am running Windows XP with Office 2003 and am trying to use MSQuery to view records on our server for Active Directory but an unable to...
Since the search function is not available I am unable to find anything so I apologize if this is a repeat post. But what I am looking for is how the Treo 750 can be used and synch'd with ACT?
thanks for any informaiton
I have a user that has right clicked on a folder and selected sharing and added another user as a reviewer of this folder. The user that was given access to the folder has added this profile to their inbox to view the folder but when we click on the folder it reports that it is unable to open...
I have a user that uses word editor in Outlook 2003 - when they send messages to people the receiver gets prompted to download Japanese when they open the e-mail. I believe that something is set up with in word causing this but I am unable to find what. I am unable to view the language tools due...
Somehow the options for the shell menu (I think I am calling this correct - the menu you get when you right click) has gotten out of order. The open with command is listed first - thus the action for when you double click on an item. I need to restore the default setting for this. Is there...
I apologize if this is the wrong forum but
Every drive that is clicked on opens the command prompt rather than just opening the drive. I am ok when I explore it but just double clicking brings up the command prompt
Thoughts???
I have a hard drive hooked up to another machine to recover the data. What I want to do is get the ODBC settings from the reg file to export out so that I can import it into the new hard drive for use over Crystal reports.
I apologize if I am posting this in the wrong forum - but any...
I have a user that is getting the error
the messaging interface has returned an unknown error - if the problem persist please restart outlook
She gets this error when trying to open the address book
She also has no options when she right clicks on a message in the inbox
I have done a repair...
Hi - Not sure if this is the right place to post this but I am looking to find out how you can save a users configurations, ODBC set ups, etc when you set them up on a new configured machine for them?
I have a user that when they run any access dtabases the currency field shows up with a Z in front of the $ sign.
Any thoughts on why this is? I believe that it is just on his machine and a formatting issues. That field is set to currency.
Thanks for any help
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.