Recent content by mathew001

hneal98, I know how to create parameters. But in this case, are we giving the options 1 - 12 for the users ??? dgillz, we do not need Crystal to prompt for a start date and select previous 12 months. It should be month driven - The parametrs should ne like Dec 03,Jan 04, Feb 04 etc and the...

I need to create parameters in a report in such a way it is a month range... The user select month values from say JAN 2004 to June 2004. The maximum range of months that can be selected is 12 months. How can this be acheived ? I do not have a 'month' field in the database, but I have a date...

Thanks synapsevampire, That is what I wanted. Today is the last day of my work and my brain has stopped working ! Thanks a lot !

How will I suppress a field if the first character starts with an alphabet ???

Thank You Brian

What is a good tool to document the reports ?

I shall try. This table is very big > 2 million rows ! Thanks Ken and synapsevampire !

Thanks !

OK. I was wondering if there would be any perfomance difference sql query over directly reading from table.

Hi Ken - How are you ! Should I use a query or read directly from table ?

If I have a table with 2 million rows and I just need values from 2 of columns, (of course based on some criteria) is there advantage of using a SQL query instead of Visual Linking Expert ?

Is it possible to connect to DB2 in Mainframe environment from Crystal ? Do I use ODBC for that !!!

Thanks ! Is there any documents where I can find more about it ?

When you create the parameter you have to select the option 'DateTime' for 'Value Type'. It should work for you. Now when you pass the parameter you may aslo try this DateTime (YYYY, MM, DD, HH, MM, SS) as parameter.

Try this ( I am not sure though) table_name."field_name" = {ts '1997-05-15 00:00:01.00'}