Search results for query: *

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.

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

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.

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...

Hello Friends Any suggestion about the following error: Failed to open the connection. /usr/local/BusinessObjects/bobje/data/procSched/xxx.reportjobserver/~tmpxxxxxxxx.rpt Details: [Database Vendor Code: 12154 ] the same report works fine sometimes and other times i get this error. When i...

Hello Friends I am getting the folllwoing error while trying to connect to a database "Failed to open the connection. Details: ORA-12541: TNS:no listener [Database Vendor Code: 12541]" I believe my TNSname.ora is fine and i don't have listener.ora I can connect to the DB fine with sql...

Hello friends, When i run a query with this condition in sql developer i get results where to_date(run_date) = to_date(sysdate-3) but when i copy and paste the same query in CR add command i don't get any results, doesn't show any errors either. can anyone please tell me why this might be...

I don't know if it is data type error. Here is the situation: -the rows load fine if a particular field in the row is 0.0 -but since it's not always 0.0, whenever it's not the row does not get loaded. I get the follwoing message in log file Rejected - Error on table T_XXXX, column SOME_DATE...

Hello Friends, Can someone please help me with the function of replacing a string in control file of sql*loader. example: if the string in the .txt file is "null" i want to replace that in the table with value (null) Thanks in advance.

Hello Friends, When i do a export into data only xls format, this option is not working: "column width based on objects in the page header." or even if i try to give a fixed column length that's not reflected in the exported xls spreadsheet. does anyone have any idea why this might be. Thanks.

I can't seem to find how to increas the size of the legend in my chart. Anyone has done that? THanks

Crystal Report Writers, BOE/CRS Admins... MD area. Hello Friends, Anyone interested in getting together for a weekend evening fun: game of poker, music, socializing, knowing other crystal lOvErS or HaTeRs.

Hello Friends, i've 14 different reports to be run with around 400 different parameter. i.e. 14*400 = 5600 reports these are to be scheduled to a specific disk location. --- what would be the best way to do this. -- any way to do it without having to buy any 3rd party tool. --- has...