Search results for query: *

I cannot use a sql expression since I am using command prompt along with the table, this does not allow for sql expression and group by server option. So please suggest me on the query.

Hi I think my query in command prompt of Crystal reports 2008 is taking longer timer to read records: Query: Select distinct name, date from salestable where date>add_months(sysdate, -36) I tired select DISTINCT price_name, trade_date from era006_forward_prices where...

Hi Ibass, Little change in the approach, let me go over again: I have 2 parameters, name and date. Both need to be dynamic. the date parameter record is limited to past 3 year records only and depends on the name parameter. I mean: Eg: Name date abc 01/01/2009 12:00:00AM asd 01/01/2008...

Hi Ibass, I tried first with cascading parameter, because that did not help, I was wondering if there is any method where I could limit dynamically the second parameter records based on the first parameter (without using cascading parameter). Please suggest. thank you in...

Hi Ibass, How could I use an "add command" to limit my records selected in the first parameter to be passed on to the second parameter. I ahve name field (parameter1) when user selects one name (no multiselect), the second field is price_date (parameter2), which should get filtered based on the...

Hi Ibass, what do you mean by to use a command. Could you please explain me better. thanks http://www.tek-tips.com/viewthread.cfm?qid=1563656&page=1

Hi could you please suggest how to increase the rowcount in registry key in Crystal Reports 2008, so that I could populate all the values in parameter. thankshttp://www.tek-tips.com/viewthread.cfm?qid=1563656&page=1

PLEASE IGNORE THIS THREAD.... I AM NEW TO THE WORLD OF FORUM AND THREADS. KINDLY REPLY TO THE OTHER THREAD ONLY...PLEASEhttp://www.tek-tips.com/viewthread.cfm?qid=1563675&page=1

Hi Ibass, My assumption was that the first parameter (param1) limits thd records for the parameter (param2). Param1 has only 22 records (LOVs), and there is only one date associated with param2. Whereas for only one record in param1 there is over 1000 records associated in param2. So is this...

Sorry can you pls help me with my issuehttp://www.tek-tips.com/viewthread.cfm?qid=1563675&page=2

Hi, can anyone help me with cascading dynamic parameter in Crystal Reports 2008. I am using a cascading parameter (2 prompts in one parameter screen) namely; param1 (string) for "name" field and param2 (datetime) for "date" field. Both the fields, name and date are from the same table "price"...

yeah try try this parameter1=field1 or parameter2=field2. hope this works for you http://www.tek-tips.com/threadminder.cfm?pid=767&page=1

Hi, can anyone help me with cascading dynamic parameter in Crystal Reports 2008. I am using a cascading parameter (2 prompts in one parameter screen) namely; param1 (string) for "name" field and param2 (datetime) for "date" field. Both the fields, name and date are from the same table "price"...