Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AnnieRider

    Returning just the lastest entry

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

    Convert Date query

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

    Using LIKE @Parameter% with multi values

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

    Non Queried Date Parameter

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

    Non Queried Date Parameter

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

    Export to Excel Data Only

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

    Export to Excel Data Only

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

    Sorting a Table

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

    Where are reports stored on Server?

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

    Where are reports stored on Server?

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

    Where are reports stored on Server?

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

    Print Problem - fields not showing

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

    Birthday Date Calculation

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

    Birthday Date Calculation

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

    SQL Datediff Query

    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"...
  16. AnnieRider

    Change Font on Drill Down

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

    Summing a formula

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

    Summing a formula

    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. :-)
  19. AnnieRider

    Summing a formula

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

    Summing a formula

    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

Part and Inventory Search

Back
Top