Recent content by shehul

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