Search results for query: *

I have installed SQLServer 2005 Express with Adv services sp1 onto a windows 2003 platform. I have published some existing reports and when trying to run these from the Report Manager on the actual server, I get the following error: An error has occurred during report processing. Cannot create a...

I did think of that, but couldn't find a condition which gave me the required results

I have an Excel spreadsheet, which is generating invoices. It has three columns, Qty, Rate and Total. Total is Qty * Rate, and the Total column has the following formatting: "_(* #,##0.00_);_(* (#,##0.00);_(* ""??_);_(@_)" which means I do not get a number on blank lines. However, and here's my...

Hi Barbara Many thanks - perfect!! I'm quite new to this, it was a great help.

Can anyone give me some advise. I have the following data in a table: Location-code, call-number, type-of-call: LOC1 0000001 START LOC1 0000001 END LOC1 0000002 START LOC1 0000002 END LOC2 0000003 START LOC2...

This is probably quite simple, but I think I've been looking at it too long! I need to calculate the elapsed time between two date/times. I have used DateDiff("s", start, end) to get the number of seconds between the dates, but can't seem to be able to find a function to convert the resulant...

The chart was in the report header. I've moved it to the report footer and no change. Can't understand what's wrong. I've displayed the values of the two functions on the report and for last year get 1's and o's for lastyear, thisyear and for this year I get 0's and 1's. ??

On change of @month -S show value(s) Sum of @lastyear Sum of @thisyear where @month = monthname(month({request.created_dt})) @lastyear = if year({request.created_dt})=year(currentdate)-1 then 1 @thisyear = if year({request.created_dt})=year(currentdate) then 1

Thanks - this make much more sense. I have tried this now and it's getting better. The graph for 2005 is now correctly plotting 1,2,9,3,5 but the graph for 2006 is still showing the total of 2005 + 2006 i.e 4,7,26,3 and 5. So nearly there but not quite.

Many thanks for the suggestion. It is nearly what I am looking for, but I still have a few problems. First I don't want the sum of sales just the number, so I changed the function to be a count rather than a sum. The plotted values are not showing correct though. My data (simplified) is as...

I am fairly new to Crystal and have so far only created very simple reports. I now need to produce a reasonably simple chart, but can't seem to get my head round how to start let alone do it. Any help would be appreciated. My table consists of sales records. One record per sale. Each record...