Search results for query: *

Many thanks jymm. Haven't had a chance to try this yet but it looks like a promising approach. I hadn't thought of modifying the SQL source.

I have a report where I have a group which has a sum of a sum in the group header (group 1). I now want to add a second group (group2)and display a further sum in the footer of group2. I'm struggling a little to explain this but the following is what I do in Crystal 9. Can someone explain how to...

Many thanks RiverGuy. I realise it was probably a fairly basic question but you have saved me a great deal of time. Thanks again

I am trying to rewrite some Crystal 9.0 reports in SSRS 2005 My Select query is as follows: SELECT Table1.Client_Ref, Table2.DateStart, FROM Table1 LEFT OUTER JOIN Table2 ON Table1.Client_Ref = Table2.Client_Ref WHERE (TABLE2.DateStart <= '2008-11-30') I then want to group by Client_Ref and...

Many thanks xlbo.I know it must have seemed like a silly question but you have saved me a lot of time I would have spent trying to use SQL syntax in RS! Cheers

We are moving our reporting to SQL server 2005 Reporting Services and need an expression for current age in reports. Previously using SQL Server 2000 I had a stored procedure which calculated age as: (DateDiff(day,DOB, GETDATE()) -0.5)/365.25) However when I tried this as an expression in...

Just in case anyone else comes across this - have solved the problem! Reporting Services is included in the SQL Server Express Toolkit which has to be downloaded separately. I feel a bit stupid but now have Business Intelligence Projects as a project type and am ready to go.

Thanks mstrmage1768 The Visual Studio 2005 set up includes an install of SQL Server Express which should include SSRS. I would have expected to see some options for this on the install but there were none. I therefore suspect something is preventing the install of reporting services. If no one...

I'm completely new to SQL Server Reporting Services but want to set up a test environment to try it out. I have installed Visual Studio 2005 professional on a workstation running XP Professional SP2. I thought that SSRS 2005 was now included (rather than being an add in) but there is no...

Wonderful! Exactly what I want. Many thanks for your patience M8KWR. Never realised it would be that simple.

Thanks M8KWR I want to run an update query on a table to remove spaces from the postcode field (so that I can match it with some 'unspaced' postcodes from another source)

Thanks M8KWR Although I can sort of see what the code does I am out of my depth in implementing it. Does AlphaNum stand for the field name? Also how is the table specified in the function? I saved your code as a Function with the field name in place of AlphaNum and called it using a macro...

I am trying to remove spaces from a postcode field. After searching the various threads I have come across the problem associated with using REPLACE directly in Access so I followed the suggestion of declaring a public function in VB. However there is a compile error (expected identifier) in the...

The running totals were created using the Create Running Total Field dialog box. They are evaluated using a formula e.g. {@Activity}= &quot;N&quot; And {CR_CLIENTS.Date}<(CurrentDate-90) and the reset option is set to 'never'. The report has no groups and the Running Totals perform a count on a...

Thanks for this. There is only one formula which uses #RTotalX which is (#RTotalX + #RTotalY)and I have already applied the check for null or zero to this. This formula is never used as a denominator and so maybe the fact that #RTotalX is zero in the case where the report fails is pure...

I wonder if anyone has come across this? I have a simple report in Crystal 8.5 which uses running totals and then uses these in a formula. The report counts clients in different categories at each office, the office being selected by means of a parameter. The report runs fine in Crystal 8.5 on...