Search results for query: *

thanks kskid, that worked, thought it took me some time to figure out why you did a '+1' after month(currentdate-1). how did you come up with it. you must be a CR formula guru.. thanks again.

thanks for the response dgillz, I am looking for number of days of the month of currentdate-1. i.e. if currentdate is Sept-1st it would be number of days of aug=31. if currentdate is setp-2nd it would be number of days of sept= 30

hi friends , couldn't find the formula to find out the number of days of a particulate month. Is there a formula for this in crystal reports XI. I wanted something like nofdays(currentdate-1) Thanks for your help in advance.

Thanks Turkbear, I did try with Publishing Wizard still no luck. Now I've realized another interesting thing. It works fine for reports without Command Objects. Only the reports with command objects are asking for DB password before the Dynamic Prompt.(usnign the same LOV for both reports)

Hello Friends: We have BO XIr2 in SunOS 5.10 what what would be the best printer diver to install(the one that allows custom page size.) As always thanks for all the help

Thanks MJRBIM (MIS) after going through it, I am still not able to make the report work without entering the DB password. My BV Manager version is 11.5.3.417. Would it be possible for you to provide the step by step instruction to overcome this . ---thank you very much.

Hello friends, i was hoping someone has answer to this: When I use dynamic paramteter prompts, I get prompted to enter the DB login when viewing the reports in InfoView; but When I use the static prompts the report runs fine. How can I make the DB password prompt not to appear? I've already...

Hello Friends. When i create a new connection for creating an UNIVERSE, i get "server is responding" message when i do a test. But when i click next i get "Connection Error" Details >> ORA-01017: invalid username/password; logon denied username/password is correct. Does anyone know what's...

I am having the same issue, can anyone please help. thanks.

Hello friends, When i open two different report of different schemas, and try to refresh them, one of them (the first one i try to refresh) asks for password and refreshed fine; but the second one gives errors like "Failed to retrieve data from the database Details: ORA-00942: table or view does...

Nevermind I got it, was looking at the wrong place.. Thanks for the help.

bubu2006 Thanks for the response Do i have to assign the Default value somewhere, because that option is turned off when i went to options>reporting

Hello Friends, Could someone please tell me how I can assign 0 to a number feiled in a report when it has null value. I have something like this: Sales Return NetSales 500 100 400 300 400 500 -100 the formula i...

Hello All, I am trying to migrate some tables that are in mysql database to oracle without deleting/altering the tables in mysql. can someone please point me to the right direction to how to go about doing this. THanks in advance.

hello all, I am trying to migrate some tables along with PK,FK and indexes form one schma to another with a script. Can some please point me to some resources or help, or suggest something. Thanks for the help in advance.

Hello All, I am trying to update multiple rows in a table with the following query: update some_table set (discount_rates)= (select value from some_table_a aa, some_table bb where aa.key=bb.id); I am getting the following error. SQL Error: ORA-01427: single-row subquery returns...

Hello ALL, Disregarding the time how can i compare the date. i.e. select * from sometable where somedate = sysdate. Thanks in advance

Hello Friends, I was loading a table from a '|' seperated file. An addition of column(account_id) was requested, so i altered the table and added the column, the column got added at the end. this was in the coltrol file xxx1 NULLIF xxx1='null', account_id FILLER, xxx2 NULLIF xxx2='null', how...

yes it's in the same box, but we also have BOXI installed in a different box to cluster it, but we are current not using that and all the servers in that box are disabled.

THanks for your response Tukbear, Yes the target database is always up. The weird thing is you can view the report just fine when you view it on demand or refresh it, so i don't think there is any database connection issue. It just fails when scheduled.