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!

Register Log in
  • Congratulations TouchToneTommy 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: *

  • Users: jcglenn
  • Content: Threads
  • Order by date
  1. jcglenn

    Report Returns expresion instead of data

    I am using this expression iif(Sum(Fields!Net_Sales.value) = 0, 0, sum(Fields!Aquisition_Cost.value)/sum(Fields!Net_Sales.value)) It returns the expression instead of the data. What am I doing wrong? Thanks, Craig
  2. jcglenn

    conditional formatting Font in textbox

    I have a report that sorts sales figure summarys by date and I would like to change colors for Sat and Sun. I tried using a iif statement in the font properties for the textbox. I receive an error box stating my expression is not a valid color. iif(datepart(dw,fields!reportdate.value) > 5...
  3. jcglenn

    Group by 24 hr time period other than 00:00:00

    I would like to group my sales qry by a 24 hr time period other than the standard group by day. Our sales periods go from 7:30pm to 7:30pm. I have searched several datetime grouping post but can't find exactly what I am looking for. TIA for your help. QRY so far... DECLARE @SDate as...
  4. jcglenn

    Record Count in report

    I just want a record count in the header/footer/anywhere in my report. Should be really simple, but I can't figure it out. TIA Craig
  5. jcglenn

    DTS package runs, job fails

    I have a DTS Package that runs on a schedule. The package seems to run and my export files are created. However the job reports failure everyday. Here is the error log. TIA Craig... Executed as user: GTIDOMAIN\MSSQLUser. ...t: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress...

Part and Inventory Search

Back
Top