Search results for query: *

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

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

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

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

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

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