Search results

  1. I

    Group by date

    I got help and it's working now. Thank you for your help.
  2. I

    Group by date

    sorry about that. Yes it's 2 tables. caseintraop.pat_or_in_datetime, caseintraop.pat_or_out_datetime are used to calculate the total minute the patient was in OR (Operating Room)
  3. I

    Group by date

    Hi, I am close to making this work:confused: I have this table attending_res_name actcase_start_datetime minutes S_X 7/1/2017 8 S_X 7/1/2017 7...
  4. I

    SSRS date

    Issue resolved. I was missing one change in the query and now it's working. I put the following: startdate: =DateAdd(DateInterval.Second, +1, DateAdd(DateInterval.Day, 0, Today())) Result: 8/12/2016 12:00:01 AM Enddate: =cdate(format(now, "MMM dd, yyyy HH:mm:ss"))...
  5. I

    SSRS date

    thank you for your help anyway.
  6. I

    SSRS date

    this is in ssrs and yes now() gives today' date and current time. I put in startdate: =DateAdd(DateInterval.Second, +1, DateAdd(DateInterval.Day, 0, Today())) and I get 8/11/2016 12:00:01 AM under enddate: now() and I get : 8/11/2016 1:09:52 PM which is exactly what I want. but I am...
  7. I

    SSRS date

    this is what I did: under startdate exp I put: =DATEADD(day, 0, DATEDIFF(day, 0, GetDate())) under enddate exp I put: =now() dataset criteria: WHERE (b.hospital_name_location LIKE 'lh') AND (a.triage_arrival_time LIKE ?) AND (a.triage_arrival_time LIKE ?) i am still getting an error
  8. I

    SSRS date

    I tried it and I am getting this error: .....dd is not declared thank you.
  9. I

    SSRS date

    Hi, I created a report in ssrs with 2 parameters. Startdate and Enddate I want to default startdate to show today' date starting at Midnight and enddate to default to now. I am able to get Enddate to work but not Startdate thanks in advance.
  10. I

    ssrs date question

    CJ, yours worked also. I did not apply it to both parameters. thank you.
  11. I

    ssrs date question

    Problem solved. I used the following in the query where clause: (DATEDIFF(d, @startdate, a.delivery_datetime) >= 0) AND (DATEDIFF(d, @enddate, a.delivery_datetime) <= 0)
  12. I

    ssrs date question

    Thanks for your quick reply. I tried it and got no data returned
  13. I

    ssrs date question

    Hi, I have an ssrs report with 2 parameters. start date with expression: =DateAdd("d",-1,Today()) and end date with expression: = today() it works but query return date after midnight. I want End date to return yesterday's date up to 11:59PM only Thank you.
  14. I

    Mid question in SSRS

    Thank you.
  15. I

    Mid question in SSRS

    thank you for your quick response. I tried but did not work. I am new in ssrs.
  16. I

    Mid question in SSRS

    Hi, I am trying to retrieve a number from a field where it's between = and = I have tried mid =mid(Fields!PRE_LAB_VAL.Value,4,4) but not working PRE_LAB_VAL --------------------------Result PT=45.7=02/07/2002-----------------45.7 RTS=51=02/07/2002------------------51...
  17. I

    if statement in ssrs Report

    instead of if statement. I created another drop down box but did not work until I modified with the following. my where statement in the dataset query was missing IN operator WHERE (TST_PRFM_DTTM BETWEEN @StartDate AND @EndDate) AND (CUST_PROD_GRP = @CustGroup) AND (TST_CD @TestCode) Now...
  18. I

    if statement in ssrs Report

    Hi all, I am new in ssrs report. I created a report with a drop down and so far that worked. I want to put a code that say something like this, if drop down is equal to FFS I want another column to equal only certain data (for example ddM, ssq) I am also not sure where the...
  19. I

    Autonumber

    Sorry I missed to mention that this is done in Crystal Reports and Mom and baby's data are in the same table. thank you
  20. I

    Autonumber

    Hi, I am stuck on the following and I need help. I added an autonumber for each record and it worked doing this under formula fields: WhilePrintingRecords; Global NumberVar x; x:=x+1; x what's not working is when I have 2 similar records I want to show each with unique number. for...
Top Bottom