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!

  • Congratulations Mike Lewis 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: LW00
  • Order by date
  1. LW00

    Null Integer XSD

    I am looking for a way to have XSD where the value is an integer with range [minInclusive, maxInclusive] values but also allow for the integer to be null. ie. <value></value>. So far I have been able to get an integer element that is allowed to be a null by having it unioned with a string...
  2. LW00

    Failed to retrieve data from the database

    I fixed the grouping problem from yesterday and now when I tried to print my report I got an error 'Failed to retrieve data from the database. Details: 42501: ERROR: permission denied for schema DatabaseX; Error while executing query [Database Vendor Code: 7]'. The database I am using needs a...
  3. LW00

    Error with grouping

    lol. Yeah that was just a typo. I actually go the problem resolved. I neglected to include a 3rd parameter in my code which said 'by seconds'. So to fix the problem I needed to right click on the htddatetime group and select 'change group'. Then at the bottom of the dialog box where it says...
  4. LW00

    Error with grouping

    Hi, I was having a problem with the sum formula in my report. There are two groups in my report, h.locationname and h.hdateTime. My formula has an if statement with the condition like so: if Sum ({@OCount}, {h.htddatetime}) <> 0 then When I try to save the formula CR 12 gives me an error...

Part and Inventory Search

Back
Top