Search results for query: *

I am trying to return just the latest entry from a History Table but I need to link it to a details table so that it just selects the latest history for certain people. I have tried Select Org_Ref, max(CR_HISTORY.Client_Ref) AS "SG" From CR_HISTORY Inner Join CR_CLIENTS on...

Hi I want to select data entered in the last full month. I have set up the following as a seperate dataset select dateadd(mm,datediff(mm,0,GetDate())-1,0) [FirstDate], dateadd(dd,-1,dateadd(mm,datediff(mm,0,GetDate()),0)) [LastDate] I have then created parameters Start and...

Hi I have a report that needs to select records where one field starts with the selected parameter value(s) It works with just one value selected, using (CR_CLIENTS.Status_Ref LIKE @NEET + '%') but I can't seem to get the syntax right to allow multi values. Is there a way to do this...

Yes! [thumbsup] I used the Convert and it works great Thank you so very much Geoff, you're a star! :-)

I have report that looks for data recorded within a School Term. I have parameter StartDate and EndDate and want to specifythe exact dates for each term. So my Data Type is DateTime and I have set Non Queried Available values. e.g. For StartDate Label Value Autumn Term...

Hi Geoff, thanks for your reply. Unfortunately exporting to .csv means that the whole of one row is entered into one cell and the Users cannot sort on column. What we really need to do is export just the data and not all the report formating. Regards Annie

Is there anyway to do this as there was in Crystal, we don't have the option in the drop down menu for exporting but was wondering if there is anywhere in the report I can set this? Many Thanks Annie

Hi I have a table of data that I have set as sorted on one field/column (Name) because I want this to be the default when the report is run. I have put Interactive sorts on two other columns (Telehone & Mobile Phone) so that Users can order by those records where there are no Contact Numbers...

Thanks ever so much all of you, I have 2005 and have found it easily now thanks to your posts. Kind Regards Annie :-)

Hi Thanks for your reply, I am new to SSRS and am not sure how to do that, could I possibly trouble you for some help with instructions? Kind Regards Annie

Hi I had a report on my local drive which had uploaded in the Report Viewer. I have since mistakenly deleted the report of my local drive and want to find it on the Reports server so that I can take a copy back. I can run the report in our web application and can see it's entry in dbo.Catalog...

Hi I have a report which contains a CountDistinct and a Sum in the header both based on fields within the body. They work fine and I can see both fields with accurate results in the published report on screen. However when I print the report (using the print button) the Count shows 0 and the...

Hi That's great thank you very much. Annie :o)

Hi Is there a way to calculate the date that someone will turn 20 using their DOB? I want to do this in a view that I will then write my report on. I've tried playing around with DateDiff but cannot seem to get a working solution. Many Thanks Annie

I have a SSRS report that includes the following expression to show the amount of working days between two dates. =DateDiff ("ww", Fields!DateStart.Value, Fields!DateEntered.Value, vbMonday) + DateDiff ("ww", Fields!DateStart.Value, Fields!DateEntered.Value, vbTuesday) + DateDiff ("ww"...

I have a table which has the following info: Client_Ref ClientName with a toggle on Client_Ref which when selected shows the following: DateEntered Notes When the User drills down (or toggles) on an entry, I want the font of all the details for that one entry to change. Say Bold or Red...

Ah, won't slight problem I'm now having with this is that I cannot work out the Sum that I've now got in the header as a percentage of another amount also held in the header. So I've got my sum of those whose value in an expression textbox is True, which is the one I was having issues with...

Oh my giddy aunt we've done it!! I've done a SUM referencing the Textbox that holds the true or false expression. I've had to put it in the header (but at this point in time I figure that the layout is the least of my issues I will jig it about later!) Thanks Geoff and Bjorn. :-)

Hi Bjorn Thanks, but my issue is more that I cannot do a Sum of a Sum. I can create a SUM of the above expression (with or without decimal) fine. But I need to then add up all those for who that SUM is 1 or greater (or <>0). And it won't let me, I can do it in Crystal so surely it's not...

Is there a way of specifying the Group in the following =iif(SUM(Fields!Intervention.Value) >=1,1,0)? I was wondering if I could put this as a dataset field also