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

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

    data format not possible

    Hi All, I am trying to change the format of a particular field. It contains numbers and I believe the format is varchar. When I try to include a thousands separator or decimal values, the changes do not reflect when the report is run. Can anyone help me with this? Thank you.
  2. rajmns

    using different fields for prompts and filter report

    Hi All, I have a field Model_Date in the format Mar 1, 2007 12:00:00 AM etc. I have another field Calendar_month in the format YYYY-MM. I have to use Calendar_month field in a date prompt(value prompt) and when the users select a value like 2008-01, the report should be filtered such that the...
  3. rajmns

    error when creating report based on SQL

    Hi All, I am using a SQL code to build a report. When validating the report, it errors out and gives the following message: RSV-SRV-0040 : An application error has occurred. Please contact your Administrator. CCLAssertError:0:Fatal: CCL_ASSERT_NAMED(rResultSetName == rsCurrentResultSetName...
  4. rajmns

    YTD in list report

    Hi All, I am trying to build a YTD list report. The users will be prompted for a date which is in YYYY-MM format. If they select say, 2007-09, the report should contain data from 2007-01 to 2007-09. If they select 2006-07, the report should have values from 2006-01 to 2006-07. Can anyone...
  5. rajmns

    date conversion

    I have a date column in numeric format. Oct 2007 for eg., is stored as 2007-10. A prompt is based on the column. The value selected in the prompt selected should be displayed on report list header as October 31 2007. Any inputs as to how to do that? Thanks in advance.

Part and Inventory Search

Back
Top