Search results for query: *

Hi Folks I'm using CS 8.0. See this image here: Image of a fork You'll notice that the fork has a nice shadow. My problem is that I want to place the fork on a green background but still retain the shadow. What is the best way for me to do this? Should I remove the current shadow and create...

Hi Folks This is something I've puzzled over for a while and, although I'm sure it's possible, I've got no idea how to do it ... I've got a small button graphic for use on my website. The button is red but is shaded so that it looks 3D. I'd like to somehow change this red button to be green...

All I wanted was this: SELECT * FROM MyTable WHERE [Date] BETWEEN dateadd(m, -12, getdate()) AND getdate() Finally figured it out myself. Pretty simple now I look at it!

Thanks for being so patient synapsevampire. I'd already checked that option (Database > SQL Query) and it shows me the hard-coded SQL query i.e. SELECT "MyTable"."Name", "MyTable"."Date" FROM "MyDB"."dbo"."MyTable" "MyTable" WHERE ("MyTable"."Date">={ts '2004-05-01 00:00:00'} AND...

Sorry, what? All I'm asking for is some help with designing a SQL query with the resulting record set only including data from the last 12 months. I previously used the formula I wrote above, in 'Crystal', but I'm trying to replicate this functionality in a program called iReport and wondered...

Thanks guys. Yep, it's a SQL command I'm after. I want to limit the data coming into the report so that it is only the last 12 months I'm looking at.

Thanks Peter and sorry for the lack of clarity. Yes, after doing some more reading I can see that SQL varies quite a lot for different DBs. Anyway, I'm using SQL Server 2000 (SP3). The thing is I'm not sure what the difference between a SQL Expression and a SQL Command is! Care to inform me...

Hi Folks I managed to find a nice formula for 'Crystal' that selected data from my DB that had a date within the last 12 months. I put this in the 'Select Expert' for the 'Date' field: {MyTable.Date} in dateserial(year(currentdate - day(currentdate))...

Bummer ... just found conditional formatting for the chart but it only allows you to set a fixed number to test against, not a number from the result of a formula.

Hi there. I want to show the average of ALL values on the chart. Therefore I'd like either a dummy data point in the graph with a name like 'Average' OR a line running the width of the chart. Possible? I've looked at trend lines but they don't seem to do what I want. There is no option to...

Hi Folks ** Sorry but I posted this in the Crystal Reports 1 Formulas Forum yesterday but think this is a better forum for it. ** Here's an excerpt of the data I'm using in my chart: Place Value Site1 10 Site2 15 Site3 16 ... .. Each 'Value' is a formula field and is simply a total of...

Sorry folks, the graph SHOULD have looked more like this!!! 20| | ** 15| ** ** | ** ** 10| ** ** ** ** | ** ** ** ** ** 5 | ** ** **...

Hi Folks I have a chart showing a range of data: Place(x) Value (y) Site1 10 Site2 15 Site3 16 Site4 8 Site5 5 Site6 10 Site7 5 ... .. I'd like to be able to show all 'Place' values on the chart but 'hide' the names of the values. See the following...

Hi Folks I'm using the following data in my chart: Place Value Site1 10 Site2 15 Site3 16 ... .. Each 'Value' is a formula field and is simply a total of all values for that 'Place' e.g. for Site1 there are 3 values - 4 + 5 + 1 = 10. The chart shows a 'Value' for each change of...

The sheet will query the SQL Server DB every month for updated data (I'm going to create a macro to do this so the user simply clicks a button). In month 1 the data could be this: Location Quantity Site 001 12 Site 001 21 Site 002 12 Site 003 23 Site 003 24 In month 2...

... and the reason for some of my confusion is that if I use MATCH to find the first occurrence of a Location and then use COUNTIF to count the number of rows for that Location ... how do I continute for the next Location and so on?

Phew! Thanks for the hard work Skip! Very impressive but any help with putting it all together?! I've read up on what each of the OFFSET, MATCH, and COUNTIF functions do but can't see how I would stick them all together. Sorry, I'm new to Excel so apologies for sounding thick!

I have the following data values in two columns in my Excel spreadsheet: Location Quantity Site 001 12 Site 001 21 Site 001 34 Site 002 12 Site 002 11 Site 003 23 Site 003 24 Site 003 43 Site 003 12 These come from a SQL database and are constantly changing. I'd like to create a...

Thanks vongrunt. I came up with the following query that also seems to work. What additional benefits do your queries offer over mine? I'm not trying to say "my one is better" or anything! I'm just interested to know as I'm very new to SQL and need to keep increasing my knowledge! SELECT *...

Hi Folks Just starting out in the world of SQL and am having a problem with dates. I have the following in a table called tblData: Date,Data 01/01/2004,123123123 01/02/2004,123123123 01/03/2004,123123123 01/04/2004,123123123 01/05/2004,123123123 01/06/2004,123123123 01/07/2004,123123123...