Search results for query: *

Hello, I am writing a query and part of my select state is this: SUM (A.INVOICE_AMOUNT) - B.INVOICE_AMOUNT) as MINE now this works well but returns all values and I am only after values greater than 0. i am familiar with MSSQL but very rusty with oracle syntax. I tried using a case statement...

CR2008 / Oracle view it's me again with that time sheet report. I have everything running accurately but I am hoping to increase performance. i have a main form and 7 subreports. these reports are placed in a group footer. each subreport represents a day of the week. Our workweek starts on...

{thedatetimefield} in dateserial(year(currentdate),month(currentdate), day(currentdate)-dayofweek(currentdate,crSaturday)+1)-8 to dateserial(year(currentdate),month(currentdate), day(currentdate)-dayofweek(currentdate,crSaturday)+1)-1 this is my formula. lbass wrote it on someone else's post...

I am still working on that time sheet report. I have resolved my first issue and am using subreports. my current problem is that I have 4 formulas in my details section for each given day to display the following: start time end time meal start meal end formulas look like this: if...

CR2008 / Oracle 11g view. I have beent asked with writing a timesheet report. I need this report to pull data from a view. the problem that I am having is getting the report to display just a single day. So if i am running the report on thursday may 17th - the data displayed is from 5/11 to...

SQL 2008 R2 / GoldMine Premium 9 i posted this question in the crystal reports forum as well - If this can be done in SQL - wahoo for me and I will gladly take it. but to do html interpretation of the email, I am running the SQL query thru crystal and formatting it as i goes. with that...

SQL 2008 R2 / GoldMine Premium i am currently tasked with exporting email correspndence from GoldMine. Goldmine does this wacky thing and stores email as an image that SQL sees as binary. so I have a SQL view that I am attaching my report to that casts the email into varchar(max). in crystal...

SQL 2008 R2 / GoldMine Premium 9 hello, I need to write a query on GoldMine's mailbox table to sift out the marketing emails. Naturally there is nothing that gets flagged in a row that says hey its a marketing email so I need to find another route. a suggestion made by someone was to do a...

SQL 2008 R2 / Goldmine Premium 9 I have a text field that contains a file path c:\docs\mydoc.doc I need to write a query that drops off both ends so all you get is: \docs the length of these paths vary quite a bit. substring(replace(cast(linkeddoc as varchar(max))...

Hello I have crystal 2008 visual advantage and I am currently writing a report for a group that they want to see how many phones their telemarketer is making per territory per week. I have that in a cross tab - works great. I need to now get this onto a map to show where these calls are...

sorry - didnt know how else to name this topic. environment: SQL2008 standard SP1 / Goldmine Premium 9 / Crystal Advantage My current task is to get reporting and dashboards going for forecasted sales. GoldMine has put their notes into an XML format. We are trying to use a sales forecasting...

Environment: SQL2000 SP4, Goldmine 6.7, Crystal Visual Advantage 2008 So I am writing this report that looks at my SQL tables and returns a red "x" if data is totally missing and a green check if data is present. I am using the graphics themselves and putting in the format / suppress area to...

Hello, I have SQL2000 sp4 on my win 2003 server. I have a lotus nsf file that I have installed the odbc connoector for and successfully created a system dsn. I then used that to create my linked server. I can see the list of tables and a matching list of views. So I thought o' happy day. I open...

CR2008 Visual Advantage, SQL 2000 SP4 Hello, I am writing a report that is using graphics to flag records that are missing information like phone number. I am using a formula in supression to get the graphic to change based on what i am looking for. To find totally missing data it is working...

hello, Crystal 2008 Visual Advantage, GoldMine 6.7, SQL 2000 sp4 I am writing a report that the record selection is this: {PAST90.userid} = {?Region - PERSON} and {PAST90.Ondate} in currentdate -90 to currentdate which is basically go back 90 days from now and find out what the user selected...

GoldMine 6.7 SQL 2000 sp4 Crystal 2008 Visual Advantage Hello, I am currently upgrading our reports from CR8.5 developer to CR2008 and a formula that has worked for years in cr 8.5 doesnt appear to be doing well in the new version of crystal and I am not sure as to why. the field is called...

CR8.5 developer SQL2000 SP4 I am writing a login report and the information of login date and time is contained in 1 field called login and it is 14 character varchar. the raw data looks like this: 20050123 07:32 - for login of 1/23/2005 at 7:32 a.m. What I am hoping to do is grab the first...

i couldnt think of a better description for the title - sorry about that. I have CR8.5 developer and SQL 2000 SP4. I have a SQL table that contains USERID and GROUP as columns - I made them both varchar / 10 characters. I would like to insert 2 parameters into my report based on this table...

hello, we are running the most current version of legato and on our old version, Legato networker skipped backing up SQL db thru enterprise manager. Since we upgraded I am seeing in the enterprise manager the databases being frozen and thawed and the event viewer is showing legato backing up...

I am running into this in both CR8.5 developer and CR XI pro. Both are using GoldMine as a backend. CR8.5 dev is using GoldMine CE 6.7 with SQL 2000 SP4 and the CR XI is using GoldMine Premium (version 8) and SQL 2005. I am inserting notes into my reports and GoldMine uses IE for html notes. I...