Search results for query: *

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

Thanks for your help! Do you know of any way that I could group with total rows? e.g combinations of the first four lines to get Totals? Many thanks Sam

Superb - Cheers!!

Hi Both, The parameter that was apearing was not set to allow multiple values and the one I wanted to appear was. If I change it so it doesn't allow multiple values it does appear, but does not allow me to enter more than one value. I cannot force the values I want to appear as they need to...

HI, I'm trying to create a crosstab report where the columns at the top are months and the rows are my formula. So the first four rows of the formula are fine. The other rows are combinations to maket totals per month. Any ideas? Many thanks Sam

HI All, If tableA = TableB (+) (TableB has multiple rows) I want to find all records in A where TableB.Field1 = 12 but <> 15. The problem is that for every ID of 12 there should be another ID of 15 I want to find those that don't have a match. E.g. For the row in Table A , Table B may...