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

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

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

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

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

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