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

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

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

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

Hi My report details multiple histories for individual clients. I have to pick out certain histories so each history has the following formula: =IIf(Fields!DateStart.Value< #7/1/2008# And (Fields!HistoryType_Ref.Value = "G" or Fields!HistoryType_Ref.Value = "R"), 1,0) The histories are...

Is there a way to set a specific order like you can in Crystal? I have 4 groups, 1, 2, 3 and NULL and I want them ordered as such. Setting the sort to Ascending puts the NULL first. I gather that if this is possible at all then it's probably an expression but I can't find any info on how to do...

I have a report that is grouped on Client, then in the details for each client there are various numbers of History records. In the history records I have the following formula: If {CR_HISTORY.HistoryType_Ref} = 'G' and {CR_HISTORY.DateStart} < {BDPTransitionReviews.DateStart} then 1 else 0...

I have a report that shows data in a table. Outside of the table but still in the report body I have a textbox that I want to show a count in. The expression is =Count(Fields!Client_Ref.Value, "InsightLiveData") but when I run this I get the error The value expression for the textbox has a...

..even though in the report properties I have ticked Print on first page and unticked Print on last page. Is there something else I need to set that I am obviously missing? I only want the header to show on Page 1. Thanks Annie

I have a report that has two parameters, one to select the client record (a Non Query with null default) into which Users will type the Client_Ref. The other selects required history types the User wants to view for that Client, I have set this to MultiValue with no default. My SQL query is...

Just a quick ? Is there any way to prevent having to re run a report that has parameters everytime I make slight changes. I'm only making small cosmetic alterations now and it's frustrating having to keep entering selection criteria. Also I thought that when I first installed Visual Studio, I...

I'm trying to convert a Crystal formula into SSRS and so far have got the following: =IIf((Fields!DateStart.Value>= Today - 21) And (Fields!HistoryType_Ref.Value = "G" or "K")), 1, 0 but it's mostly underlined in red and showing 'wrong number of arguments' what I'm trying to say is that if...

Is this possible? I have field in a table that shows Age (as calculated from DOB). I want to sort the table by Age ascending but am told I cannot sort on a Report Item. Thanks Annie