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

    Webi question – formula needed for exception handling

    Great - thanks!
  2. shannonlp

    Webi question – formula needed for exception handling

    Hi, I created a variable where the formula is =Sum(MonthsBetween(Min([Timesheet Start Date]);Max([Timesheet End Date]))) This works as expected but there are instances where it returns 0. If it returns 0 I need 1 displayed. I’m not sure how to add this syntax in my variable (if 0, then 1)...
  3. shannonlp

    Crystal Reports not accepting parameter value when using a stored procedure

    I’m attempting to use a Sybase stored procedure in my Crystal Report. In my stored procedure I have parameter that I’ve defined as a date. However, Crystal Reports is recognizing it as a string. When I refresh the report and uncheck ‘Set to Null’ and enter a date I get the following error...
  4. shannonlp

    Where clause needs to equal a value that is in a table that is not in the report

    Adding this table without any joins give me the following error when refreshing the report: ‘Failed to retrieve data from the database. Details: Only one command can execute at a time.’ It’s generating two sql statements which Crystal Reports cannot handle. My next step is going to attempt...
  5. shannonlp

    Where clause needs to equal a value that is in a table that is not in the report

    Hi, I have a report where I need the eff_date to = a value in a table that is not able to be joined to the tables currently being used in my report. There is a calendar table within our DBMS that has 4 columns (date_id, prev_bus_date, curr_bus_date, and next_bus_date). It always has only one...
  6. shannonlp

    DateAdd function

    Hi, Please disregard my earlier post. This got me what I needed. DateAdd ("s",{metric_hist.numeric_qty},{metric_hist.datetime_dttm} )
  7. shannonlp

    DateAdd function

    ...WhilePrintingRecords; Local NumberVar x := {metric_hist.datetime_dttm}; Local NumberVar H := Int(x/60/60); Local NumberVar M := Int(x/60) - (H*60); Local NumberVar S := x - (M*60) - (H*60*60); DateAdd('s', S, DateAdd('n', M,DateAdd('h', H, {metric_hist.datetime_dttm}))) I'm getting the...
  8. shannonlp

    DateAdd function

    I need to create a formula field that adds time in both hours and minutes to an existing database field. I have a start date/time and need to add the duration to create an end date/time. My start date field is metric_hist.datetime_dttm. I have a @Duration field...
  9. shannonlp

    Need to add time to get new date

    Sorry for the late response - that worked. Thanks!
  10. shannonlp

    Need to add time to get new date

    I have a report where I have a DateTime field and I need to add time to it to create another field. Field 1 is Start Date Time. Field 2 is a formula field where I converted seconds to hours. ({metric_hist.numeric_qty}/60)/60 Field 3 needs to be End Date Time. I need to add Field 1 and Field 2...
  11. shannonlp

    Hi, I am having a problem displa

    Hi - Thanks for your response. It turned out that I needed to do a right outer join but its still the same idea. The only thing I'm still unclear on is if it should be Not Enforced, Enforced From, Enforced To, or Enforced Both. I've currently got it set to Enforced Both which seems to be...
  12. shannonlp

    Hi, I am having a problem displa

    Forgot to include subject - sorry. This is regarding linking tables.
  13. shannonlp

    Hi, I am having a problem displa

    Hi, I am having a problem displaying data and I believe it is related to the way my links are set up. I have 3 tables: Nps_initv_proj Nps_cap_initv_outlay Nps_exp_initv_outlay Initv_proj_no is what I am joining on amongst the three tables. Here is my problem: I have an example of where my...
  14. shannonlp

    Highlighting Expert

    Thanks LB - I've got everything working now.
  15. shannonlp

    Highlighting Expert

    After looking at this further it looks like there are spaces, not null values in this particular field which is likely why I'm having an issue with this. No need to respond. Thanks again.
  16. shannonlp

    Highlighting Expert

    Thank you for your responses. They were very helpful. One last question - I also have some text fields which are appearing in Crystal Reports as memo fields. There are null values in the database and I’d like to highlight those with a color. I created a formula field: if...
  17. shannonlp

    Highlighting Expert

    I'm running in to a problem when trying to do this for a number field. Here is an example of what I've done for the string fields: Created a formula field if isnull({nps_initv_proj.proj_process_code}) then " " else {nps_initv_proj.proj_process_code} Placed that formula field in the details...
  18. shannonlp

    Highlighting Expert

    Thanks LB - this works for what I need. Unfortunately I need to create a lot of formula fields.
  19. shannonlp

    Highlighting Expert

    Hi, I am trying to highlight the null values of a field in my report. Is it possible to use the highlighting expert to do this? I set the value of my field to " " but it didn't highlight the null values. I'm using CR 2008 ver 12.3. Any help would greatly appreciated.
  20. shannonlp

    Parameter question

    Also, I’m using a dynamic prompt because the account IDs change occasionally. I’m not sure if that matters but my earlier post about clicking ‘Append all database values’ doesn’t apply when using dynamic prompts. It still doesn’t bring in all values though.

Part and Inventory Search

Back
Top