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...
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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.