Search results for query: *

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'}

How to connect to DB2 Batabase in Mainframe Environment and generate Reports using Crystal ?

Hi dgillz, That will sort within a group only ! Baxxen Corps will come before Baxxen Field. But I also want Anexample1 Anexample2 to be displayed before Baxxen Corps Baxxon Field Thanks!

I am creating a report which is grouped by a field called say, Affiliation ID. An affiliation has more than one customer associated with it. The report I created is grouped by affiliation id and displaying the customers associated with it( I am supressing the group name field). The customers...

I want to create gantt chart in Crystal report 8 showing activities against the date. The activity dates ranges from few days to more than year. Does anyone created gantt chart like this.? -- Mathew

I am using several tables. It works fine. The problem is when I add another table to find out user information. To do this I am linking to a log table. WHen I link a field from the existing tables to corresponding table in the log table, it fails