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

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

    Report Layout that can hold more data elements

    I have 38 data elements to be displayed in a report. In page setup, chose " 11X17" and orientation has "Potrait" still am running out of report layout for data elements to be placed. Is there a specific layout or settings in the layout that can be done to increase the report layout. When tried...
  2. jsttuchm3

    How to handle parameter data

    My report extracted based on parameters. There are about 12 parameters. Few of the parameters will be initially set to default values in parameter section like 'ALL'. ALL - means no filter on that field, problem here is the field is null in the DB. How to handle this is Record Selection section...
  3. jsttuchm3

    Setting N/A to date fields

    I have strange problem in setting N/A to null dates in the report. When quering db it returns the data where date is null but the same when checked in formula CR XI doesn't set to N/A but displays some julian date instead of N/A. Code piece is as follows if isnull({sp.LOAD_END_DT}) then...
  4. jsttuchm3

    Display N/A for date column where the data is grouped in DB

    Hi Experts, I have a view created in DB, columns in the view are based on grouping and not individual values for columns. The problem is when there are null vlaues, want them to be replaced by "N/A" value. The data type of the column is date. Tried all validations of IsNull, DatePart, InStr...
  5. jsttuchm3

    Display date based on the parameter fields

    I have an issue in applying a condition based on the parameters provided. StartDate & EndDate are parameters where data is provided and the report is supposed to extract data where createddate from database falls with in the provided date range. code written in record selection section is a...
  6. jsttuchm3

    Display String for Number data type

    I have a report where charater data like "NULL" to be displayed for number data types. Ex: - If and ID is blank in the database then display NULL in the report. ID is of Number data type in Database. Need to display the same for Date values too. If the start and End dates are blank then display...

Part and Inventory Search

Back
Top