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