Search results for query: *

when i inserted SUM (A.INVOICE_AMOUNT) - B.INVOICE_AMOUNT) > '0' in the WHERE statement I got error -cannot perform GROUP. so I tried to do case when SUM (A.INVOICE_AMOUNT) - B.INVOICE_AMOUNT)> '0' then SUM (A.INVOICE_AMOUNT) - B.INVOICE_AMOUNT) as MINE else null in the select statement I got...

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

nevermind me - omg! the problem was that today is friday. the report thinks first day of work week is friday and only runs for the current work week. the dev database i am working from has nothing entered for today so yup, it did as told, returned no data. sub reports when run individually ask...

you need to first get the report to count these results then use the summary function. so you could make a formula that says if b/mfield is < 17 then "less than 17" else if b/,field is >75 then "75+" -you get the idea. from that you can build your group. in that group you can create a formula...

this worked wonderfully in the subreports but now my main form isnt displaying the subreports :( I have no clue what is off. what I did is go to the subreport and copy my SQL query, then added a command, pasted the query in and added at the end: TO_DATE("mytable"."datefield", 'MM/DD/YYYY') >=...

you can use page footer instead of report footer. are you trying to print a label or some formula/summary?

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 asked and got giggled at. what i ended up doing is taking the contents of all 4 formulas and putting them into 1 formula and then making a group off of that and choosing specified order. i suppressed the group header and left the details section active. i coulda picked the group header and...

i ended up having another column added to the view for just date. it comes out as a varchar but i can use cdate on it then I made subreports sorting on specific dayofweek. seems fairly solid but I was hoping to use the sql expression.

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

maybe i should clrify a bit better. on my report i have 2 groups - one for the company name then the next is for the employee assigned. since my week is friday to thursday i havent added in a group for date what i need to do is add into my group a little formula/subreport/ whatever for each...

thanks for the response - totext I have tried but since the dates are on 1 form side by side I do not know how to take my datetime field then say for dayofweek = 6 please print the date in this label. I cannot group by week - that would be great but again datetime field and my week runs friday...

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

crystal is not enjoying ubound(x); it says a string is needed in its place. I am completely unfamiliar with ubound so I dont know what to give it instead.

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

thanks for this - it got me pointing in the right direction. the spaces turned out to be tab (char(9))

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

no clue about the why's but i recently had to do a query where the datetime had to be returned in a very particular format. I came across this url: http://linesofcode.net/snippets/45 it shows all the different examples of datetime display and the magic number that you put in so yours may be...

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