Recent content by sammybee77

Hi All, I need a formula that will be datefield = thismonth so that when the report is run it only finds dates that are in this month and this year. Any ideas? Many thanks Sam

Hi all, I'm trying to do a basic select where date1 = sysdate(dd-mon-yy)! Please can you tell me how this should be phrased? Many thanks Sam

Hi All, i'm trying to run a crystal report through a vb program. Every time a run the report I get the above error, I've not seen this error before has anyone got any ideas?

Hi All, I'm sure this is possible but can't remember how. My formula reads if isnull (field1) then 'STOP' else field1 I want the 'STOP' to appear in Red I though I could do this stating crred but I don't know where this goes. Please help. Many thanks Sam

Hi, I've created a report which contains 15 Subreports, I want to know if it is possible for the results of these subreports to be dragged into the main report in the form of ratio's and sorted by the ratio's? Is this possible? Many thanks Sam

Hi guys, my plsql is awful! I tried the above and got an error on the when clause (expecting a declare or if loop) also on the secound part shouldn't the (as select) be values? Tab1field1 also contains multiple rows if there are rows with different id's already there I don't want them...

Hi Naith, Thats the kind of thing! Cheers Only problem is there is no table1.name, I amended the query like this UPDATE table1 SET table1.id = (select table2.id from table2), table1.field1 = 8888, table1.field3 = 0 WHERE --table1.id IN (SELECT table2.id FROM...

Hi All, Attached is the query I'm trying to do, obviously it doesn't work as I'm trying to set the value of one table whilst referencing another. Any ideas of the best way to do this? update table1, table2 set tab1id = tab2id, tab1field1 = 8888, tab1field3 = 0 where tab2name like 'TEST%'...

Hi Ken, I don't want to sum the information but display the country names, also, the user picks the country they want to display and by doing so they want to be able to see what other countries are held against the record. Any ideas? Many thanks Sam

Thank you for your help. My view is created but unfortunatley it is not selecting what I expected. I was hoping that I would get the maxid per field1, when I select all from my view I still get multiple rows per field1. ANy ideas? Many thanks Sam

Hi All, I'm trying to create the following view:- create view blahblah select max (id), field1, field2, field3 from table1 group by field1, field2, field3 When I try I get the following error:- Error at line2 Ora-00998: must name this expression with a column alias Where should I put my...

I want to show all the results if one row = England

Hi All, I'm having a few problems I have a report that is outer joined, I want to do a select on the table which is outer joined but still display all the matches. E.g. Table1 has an id that = 12. Table2 has several rows that have a link on the id 12 and the results show a list of countries...

Hi Jim, Thank you - that's fantastic. Is there anyway I can amend the calculation formula so it still displays months but only for this year? Many thanks Sam

Hi Guys, Unfortunately that doesn't work as the ID's for e.g. UK Total in Group 1 are already specified in Total Contract and Total Perm. Also would a crosstab report work if there is more than one grouping? Many thanks Sam