Search results for query: *

Hi, I have a numeric parameter which basically stands for "Number of months". Now i want Crystal to select records(based on date filed in table) which has values within last x months. That is if user enters '6' as parameter i want it to bring back records in last 6 months...

Hi, When i try to verify database for my in crystal designer i get the message "Communication Link Failure". Can anyone help me understand what it means? I am using Crystal 7.0. Thanks.

Hi All, I have a report which takes a date range as parameter. I have a date field say enteredtimestamp in my database table. Now if say for example the user enters a start date as 04/18/2002 and end date as 05/20/2002, than i need to get all records for which enteredtimestamp is within this...

Thanks for the reply...I know that i have to verify databse only if the report uses the changed tables....we had a change in table which is used in almost every report...that is my problem...hence i wanted to know whether there are any tools which might help me speed up the process....

Hi, I am using Crystal Designer 7.0....The database is SQL Server 7.0....Now there are certain changes in design of tables in my database....I have a large number of reports...Is there any way that i can verify the databse in these reports as a group instead of opening each report and...

Hi, I am having a weird problem...If i write some conditions in Selection Formula my report dose not bring back data...However if i edit Where clause of my report's SQL statement the report works...Does anyone have idea why that happens.... Thanks

Hi, I have to report from a stored procedure... the basic stored procedure is The DB is SQL SERVER Open a cursor Step through the Cursor put the values selected into a variable and for some condition calculate another variable (Set @AmountPayable = @AmountPayable + @AmountDue) and finally...

is there a limitation on the maximum no of formula fields that can be inserted in crystal reports 7. thanx

thanks a lot steve.......it works..... priti

Hi there.. I want to find no of business days given two dates....is there a way to do this using Crystal Reports 7.0 thanx in advance priti

hi steve, thanx again for the help..... my emailid is pritiw@yahoo.com thanx again.... priti

hi steve.... its SQL Server(7.0) database.... i am comfortable with c,c++ and VB..... and yes we are indeed talking about views.... thanx a lot for u'r help.... Priti

hi steven, thanks a lot for the tip. could u please give the sample code to do it. thanks again

Can someone help me with a requirement that i have. we have a lot of reports accessing a database which has a lot of views, and we r not sure which views r being accessed by these reports. we know its possible to get the list of views accessed by one particular report. but we need list of all...