Search results for query: *

I got an error message" failed to open a rowset: details: 42S22:[oracle][odbc]"datediff": invalid identifier" I want to add to the command section of the database expert as a select statement. Can somebody please help? select DateDiff("d","dbo.trans"."trans_date",CurrentDate) as Aged...

I have created the sql statement under the command section of the database expert. I want to added a calculated filed to calculate # of aged days and make that as a table field. How would I do this?? I have tried by adding "today()-dbo.trans.trans_date as aged" but I don't think it is...

i tried to create another running total and leaving the reset as "never" and evaluate as "on change of group (2nd aging group) but it didn't work. do you know where i did wrong or can you please help me with creating the formula for summing up the two total from two groups. thanks a lot.

thanks, it worked. but how can I get the grand total to appear on my footer page. ex. group #1 running total is 150 and group #2 running total is 100. I need the grand total of 250 to show on my report footer. thanks a lot

Thanks for the help. I am pretty new to crystal. Can you please tell me how to create rnning total and reset the running total on chnage of group trans# and group aging bucket?? thanks a lot

I have a report desiged as following and having trouble getting the total. The report is group by aging bucket. Can somebody please help? Aging <30 days (group header1) Tras# Dollar amt userid a234 50 aaa444 a234 50 cxd565 5678 100 ddh588...

I have got this error message: Query Engine Error: 'If tables are already linked then the join type cannot change.' Failed to open a rowset. I am using crystal v.10 and i am trying to link 3 different tables to Table A ( my primary table) and when i changed one of the link to left outer join...

Thanks for the quick response. I need to do inner join with Table 1 and Table2 but also want to do left join table3 to table 2. Can you please advice me how should I do it and where do I do the join using crystal reporting tool. thanks

I am a new user to Crystal report version 10.Does anybody know if Crystal report writing tool allow users to do left join or right join with multiple tables? thanks

Thanks for the detailed infor. I have tried getting differnet people to provide me more infor, my client doesn't like to give me too much infor. All I know, when i log on to the web site, I can click on crystal report icon and look like to me it was a module and open up the crystal report...

sorry, here is what is in the record selection effective_Test.Branch ='022' and {effective_Test.Effective_date} > (CurrentDate -360) here is what is in the sql query ( date was missing) SELECT effective_Test.Trans, effective_Test.Effective_date, effective_Test.Branch FROM...

OK, The following query was working when i tried to create reports on my local machine (v7.0). but when I tried to do it via the web site (crystal report is residing on a customer's web site v.10). {effective_Test.Effective_date} > (CurrentDate -360) is missing from the where statement. When...

I think I got it to work. thanks so much for helping getting this to work. Really appreciated your help. Thank you

Yes, i did create the formula through report > selection formula> record area. I am using v.7. Here is the query I have put under "Show sql query section. It is giving me error message "error detected by database DLL". I really don't know what to do. Please help.. SELECT...

I created the formula and when I went to the database > show sql query, it didn't include the formula I have created. I tried to add to the where statement, and it still does work. Please help. thanks

How do I pass the formula to sql statement?

Thanks a lot,I will try today. Do I not need to do any conversion since the data type is different?

I am trying to create a report that will return # of records which meet the following criteria. need to pull records that exceeds 360 days for post date and status ="active" and records exceeds 30 days for receive date. The post date has data type of "Date" and receive date has data type of...