i'm trying to edit a sql statement from an existing custom report that involves technician time charges.
the existing statement shows time charge data for "yesterday"
I can't figure how to write the statement for the last 30 days.
the existing state reads: where datediff(day...
My Vidar Truscan Select P-75 engineering scanner has not been used in a couple of years and my pc's have been replaced with new ones. I am running win XP pro sp2. The scanner was originally purchased with an adaptec 2930 scsi card. The vidar website has a software and firmware download for older...
I downloaded what I thought was the latest driver.
Can't figure out why colors on the plot are not matching what I'm seeing in the dwg on the monitor (hp 30"lcd 2560x1600 resolution)
I am using wmplayer 10 with win xp
Eventually, after watching any number of short videos, when I double click on a file nothing happens unless I reboot the pc. The number of files opened before this occures varies. Also, (this may not be related)when the screen goes into screen saver mode and I...
Using Excel 2002 sp3
I am trying to create a formula that will keep the cell with the range total, blank until a number has been input into the cell that is been summed.
This is what I have tried with no sucess.
=IFSUM(B28)=" "," ",SUM(B17:B28)
Thanks for any help.
Am using cr 8.5
Can't remember how to set the detail section background color for every other row like it appears in this forum's web page.
thanks for any help
Running exchange Server 5.5, service pack 4
We are using a module in a Maintenance Management Software package called MP2 messenger that is designed to automatically send email notifications to anyone that has been set up to submit work requests via a web page on our local network. For example...
I have a dell xps600 w/ win xp.
Just installed a cyberparallel pci card for a plotter.
I installed and updated the drivers ok and is in the device mangager under lpt3.
It will not send a test page to my plotter.
In the print que box, it shows two incidents of the print job even though I only...
i'm am trying to setup HP DesignJet 500 42+HPGL2 Card plotter in Softdesk 8 r14 with a usb connection.
Can't figure how to set the plotter through "hpconifg" within the software. I had no problem with using a parellel port but our new computer doesn't have a parellel port, just usb ports.
I am...
Running WinXP on a new Dell 8400
Using McAfee virus program and my isp is Adelpia
This just started last night after booting up the computer.
I saw somewhere that my isp could have installed this program.
Am using CR 8.5 Win 2000 and would like to give the person opening my report (using a crystal viewer)the option of viewing the report showing groups by "unit" or just a basic list of patients in alphabetical order. I created a formula called "unit" which says that if {location}in ['1','2','3']...
Using Excel 2002 on Win 2000
Can you set up your page header so it can be viewed at the top of the page no matter what row or page you are working in? I thought I was able to do this in an older version.
I don't remember the command.
Thanks
Using Win2000
When using a lazerjet5 b/w printer to print a document that spans more than one page, the printer prints all of the pages on the first page, which of course is not ledgable.
If I print a one page document or print current page and select to print multiple copies, all pages are...
Using Cr8.5 I have two subreports in the main report.
One is "labor" the second is "parts" I am trying to drill down these sections to make the report a summary of all totals. Why would hiding the section that the subreport is in change my totals ex. labor cost? In the subreport itself, I have...
I'm trying to figure a way to allow a user to enter text into a parameter prompt {?Task Discription}without having to type in * before and after the text string. I'm trying to allow any text before the user's text string and any text after the user's text string, without making the user have to...
I am trying to create a formula in a running total to select only work requests that are received Monday thru Friday only. I attempted this: {WOCRAFT.CRAFT}='ELEC' and ({WO.REQUESTDATE} in [DayOfWeek(2)to DayOfWeek (6)] Of course it doesn't work but am I on the...
Using CR 8.5 w/SQL
Is there a way to design a report that would allow somone to choose a specific value in a parameter prompt or allow Crystal select all the values in a field.
Example: If someone using a viewer wanted to see a report on all of {wo.location}s or they wanted to choose a specific...
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.