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: *

  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

    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...
  3. 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...
  4. 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...
  5. 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.
  6. 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}...
  7. ifthenelsenull

    What am I doing wrong with this pivot?

    I am pivoting a temp table and the table is fine with no nulls or additional values but when I pivot the data gets split in half and I end up with nulls where there should be values. Instead of 1 row with 20 columns I get two rows with 20 columns with half the values in the top row and half in...
  8. ifthenelsenull

    Crystal Reports Database Expert only shows half the SPs

    Crystal XI When I connect to the server it is only displaying about half of the stored procedures in the dropdown. I've waited to see if it was going to eventually load, googled it and looked for options. I've never seen this though. Any ideas?
  9. ifthenelsenull

    Crystal and XML output

    Crystal XI Is it possible to use Crystal to display XML data? I want to use FOR XML in a query and have it output to the report or I would prefer to get the output in a fashion where end users can cut/paste or export) into excel XML. This is in an environment that doesn't have access to SSMS...
  10. ifthenelsenull

    Can I use FOR XML with crystal reports

    Crystal XI Can I use FOR XML in my queries and get something I can use in crystal. When I tried it crystal called the field a "blob field" and the type was a picture. It pulls the right number of entries but is blank. Any help you can provide would be great.
  11. ifthenelsenull

    need help with breaking data into multiple columns from a single colum

    SQL server 2008 I have two tables that contain three columns that I need. The first table is the form on which data is entered into a UI and gives me the formname, entereddate and lastchangedtime. This table contains thousands of abbreviations of which I only need 'form1'. This table links...

Part and Inventory Search

Back
Top