terencef
Posts: 7
|
| Posted: 08/29/2007, 11:38 AM |
|
Hi; I'm creating a report with a datetime range. I added the 2 params s_Datetime & e_datetime to the where clause. On complettion of the builder, the search form only has ONE search box not TWO as would be expected.
What am I doing wrong?
Some other observations:
1) in the query builder, I have aliased 3 column names that are needed, but they do not show - instead ALL the fields show up from the joined tables.
2) I need to include a SUM(col) in the select statement - I tried it and again it did not show in the fields list to pick after creating an alias for the expression.
Would appreciate some insights
Thanks
|
 |
 |
mamboBROWN
Posts: 1713
|
| Posted: 08/29/2007, 6:33 PM |
|
terencef
A little more information please.....What version of CCS?? What does your test environment consist of (PHP or .NET or JAVA or MySQL or MSSQL...)? When you say one search box not two are you refering to the search fields or the actual search grid (which contains the fields)??
|
|
|
|
|
