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

    formatting yyyymmdd 00:00:00 parameter into mm/dd/yyyy 00:00:00 string

    I have a parameter displaying yyyymmdd 00:00:00 I need to turn into a string because it can be null and I want to substitute a message for that case. I have not had any luck with cstr, totext, tonum or any of the standard conversions. I think I remember this using left right and mid to swap...
  2. ifthenelsenull

    Have a text column in my database storing HTML but crystal won't display it

    I figured it out. It turned out that the text field in the DB became a memo field in crystal. I unfortunately had the field in the group section and that doesn't work. Once I dropped it into the details it functioned as expected. Thanks for your help.
  3. ifthenelsenull

    Have a text column in my database storing HTML but crystal won't display it

    2500 characters of data. It comes from an application.
  4. ifthenelsenull

    Have a text column in my database storing HTML but crystal won't display it

    cr XI, SQL 2008. This is a vendor database so I can't change how they store things. When I display this field in crystal it's blank. I set it to can grow and changed the paragraph text interpretation options to HTML Text. The data looks like <HTML> <HEAD> <style...
  5. ifthenelsenull

    Delimiter disappears how can I use it to parse the data.

    Well I could do that but it wouldn't solve my crystal reports issue. I need to solve the parsing in Crystal.
  6. ifthenelsenull

    Delimiter disappears how can I use it to parse the data.

    Crystal Reports 11, SQL server 2008 I have some data stored in a delimited field but when I try to display it the delimiter goes away and it all runs together. When I paste it into Notepad++ I see it as data part oneRSData part twoRSData part threeRS However when I view it as text or try...
  7. ifthenelsenull

    passing a value to a parameter in a subreport

    I solved it. It was a datatype mismatch. Once I cast the types to match it worked as expected. Thanks for your help.
  8. ifthenelsenull

    passing a value to a parameter in a subreport

    Sorry in the SP they are defined that way. In the main report it's just a field. {employee_id} in the Subreport it's a parameter {?@employee_id} I need to link [employee_id} in the main to {?@employee_id} in the sub. But when I choose {employee_ID} in the main it's not an option to choose...
  9. ifthenelsenull

    passing a value to a parameter in a subreport

    I don't have a formula do I need one? I just have the field employee.employee_id in the main report and the parameter @employee_id in the sub.
  10. ifthenelsenull

    passing a value to a parameter in a subreport

    I need to pass a value from the main report to a subreport's parameter. The main report pulls in all employees and the sub report is set up to return specific data to that employee using a parameter of their employee number. The main report field is employee_id and the subreport parameter is...
  11. ifthenelsenull

    Passing values from a field in the main report to a parameter in a sub

    In the details section but I can put it in a group header. It can go anywhere really.
  12. ifthenelsenull

    Passing values from a field in the main report to a parameter in a sub

    Thanks for the reply: The sub has a bunch of parameters that usually come from an application and is run on a case by case ad hoc basis by an end user. The original report (now sub) is only set up for a single person. I wrote a quick main report that pulls all the possible people and then put...
  13. ifthenelsenull

    Passing values from a field in the main report to a parameter in a sub

    How can I pass a value from my main report into a parameter in a sub report. The subreport is a report that I want to run for multiple instances so I created a main that pulls the instances so it can be run without the end user inputting each value.
  14. ifthenelsenull

    Having trouble concatenating date fields

    Thanks for your help. The final working solution is: IF ISNULL({Staff_V1;1.VisitEndDateTime}) or totext({Staff_V1;1.VisitEndDateTime}) ="" then (date({Staff_V1;1.VisitStartDateTime})& "/ N/A") else totext(date({Staff_V1;1.VisitStartDateTime}),"MM/dd/yyyy") &" / "&...
  15. ifthenelsenull

    Having trouble concatenating date fields

    @turkbear That explains the blanks @IanWaterman That's what I've been doing but I was wondering if there was a way to do that in a formula like: IF ISNULL({Staff_V1;1.EndDateTime}) or {Staff_V1;1.EndDateTime} ="" then "n/a" else {Staff_V1;1.EndDateTime}; date({Staff_V1;1.StartDateTime})&" /...
  16. ifthenelsenull

    Having trouble concatenating date fields

    CRYSTAL XI I want to concatenate datetime fields with a slash between them and change the field from datetime to date. I tried {Staff_V1;1.StartDateTime}&" / "&{Staff_V1;1.EndDateTime}and the formula field is blank in my query. Changing that to add totext({Staff_V1;1.StartDateTime}...
  17. ifthenelsenull

    What am I doing wrong with this pivot?

    I received an answer and basically I needed to pivot by the fields with my data not *.
  18. ifthenelsenull

    What am I doing wrong with this pivot?

    ...[ Type4 ], [ Type3 ], [ Type2 ], [ Stg1 ], [ Stg2 ], [ Stg3 ], [ Stg4 ], [ Stg5 ], [ Stg6 ], [ Stg7 ], [ Stg8 ], [Score ], [SknRisk ] FROM (SELECT * FROM #tbla0data ) AS SourceTable PIVOT ( MIN(VALUE) FOR findingabbr IN ( [wnd], [ Type1 ], [ Type8 ], [ Type7 ], [ Type6 ], [...
  19. ifthenelsenull

    Crystal Reports Database Expert only shows half the SPs

    Thanks LyleU. This probably explains why I never saw this happen before. I'm going to star this because it's likely to come up again. I appreciate the feedback.
  20. ifthenelsenull

    Crystal and XML output

    This would work. Just create text tags for the XML and drop in the fields... I gotta be honest this is the best idea I've heard. I'm gonna roll with it. Thanks for posting it.

Part and Inventory Search

Back
Top