Search results for query: *

Hey, Any idea on how to hide a table if there is no data in it. Have tried using hide block and putting a condition but it doesnt work. Any help will be greatly appreciated Shehul

HEllo, I have a small problem. I have a VB macro to refresh and publish reports. VB macro has BOLOGIN and BOPASS parameters to pass login and password. But the password is encrypted so it I use the parameters the macro doesnt decrypt it and the macro doesnt publish. So, currently am hardcoding...

Hello, HAve a problem where i want to print a text field only on the last page. The text field would be present in the page footer. Any ideas on how to do it as right now it repeats on each page

Sridharan, any updates... Need the link to the article

Thanks for the reply. Sridharan, could you send me the link to the article. I couldnt find the tips & tricks section for BO.

BO gives me the option to select which year and month wise sales I want. However, I want to find MTD(Month to Date) and YTD (Year to date) sales. This means if today is the 14th of July. I want to find the current month's sales and the current year's sales, without any prompt. Also I want to set...

I have both dimensions and measures. These are the foll fields in four tables all related one to many, First Table Airline,ticket no, class, sector from, sector to Second table invoice no, invoice date, invoice amount, basic, taxes, Domestic flag Third table Credit Note no, Date, Credit note...

Simplifying the problem... I have two tables in the database with one to many relationship. I want to show all the fields of both the tables in my report such that there is no repetition of rows of the first table in the report... How do I do it....

I need to use report prompts, where the report should get all the data if I dont put any value/data in the prompt. Right now I need to put some value in the prompt text box as without that the OK button doesnt get enabled. How do I do it. Any settings in BO....

Sridharan, that doesnt work as BO puts the data in the same object, while I need two separate objects.

Thanks, did manage to get it right... the only grouse is i would need to manually change the sql whenever i need to use both the amounts together...thats almost all the reports ;-(

Oops my mistake yeah COALESCE is a counterpart of NVL... I tried manually changing the query and make an union however it gave me some error.. Is there any way I can force BO to create to separate queries for the same...

Yes I am using COALESCE (DB2 - Its similar to DCODE) I have a one to many relationship between invoice and creditnote table and due to the fan trap i have an invoice alias here's the sql generated in the report SELECT COALESCE(TTM_INVOICE.INV_INVOICE_AMT,0) -...

I have two measures.. 'Net sales monthwise' and 'net sales yearwise' mapping to the same database field For each I have added a prompt for the month name and the year respectively. Individually they work fine. However if I use both together in a report, they give the same result, which is wrong...

Thanks Guys... I think I had wrongly picked up a dimension field from the aliased table. Should have picked from the main invoice table. Maybe thats what caused the problem

Thanks, Subhashab... BO has generated split SQL for the net amount. Also, my measures are not being calculated in the same SQL. I have also made an object to calculate the net, but just as i said it gives me wierd results. Could you elaborate on the multi cube.. the sql's are syncronized.. Any...

I have an invoice and credit note table. Need to find the net amount(ie invoice amount - credit note amount. Also have a fan trap on the invoice table hence have made an alias and two contexts. One connecting invoice and credit note and other connecting invoice and invoice2. Variance doesnt...

Thanks a lot for the help. I couldnt use towords as I coulndt find any way of showing 50/100 as cents five If there is some way to do that then I would prefer using towords

I need to show a numeric amount in words on the report. How do I do it. For eg 345.5 as Three Four Five Cents Five