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...
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...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.