Search results for query: *

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.

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

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

no, the date is in the format 2007-10 for october etc..

Thanks for the reply. The date is in numeic format. And I should use only one field that has month and date. I cannot use the month only field or year only field. How can I do that? Thanks again.

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

works great!!! thanks so much.

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.