Search results for query: *

I just tried to keep consistent with the example. The table name is actual named something else.

Hi dhookom, I am so sorry, I should have included the error message with the post. After I have created the first query, a box prompt for me to enter the report date (enter parameter value: boboleft.ReportDate) I think maybe I have done something incorrectly..but haven't been able to figure...

Hi, I have tried the above queries but it didn't really work. I kept getting error message..not sure what I did wrong.

Hi, Are there any ways to put this in a ms macro so it will output the data to an excel file?? I have been manually copy and paste the query every week to run the query and copy and paste the data to an excle. Thanks in advance for the help. SELECT A.[Parent#]...

Hi Ties, Thanks for the response. I am a little bit confused..I need to create a calendar file in excel instead in BO desktop intelligence?? thanks

Hi Ties, Steve Thanks for the help..I am new to BO Deski. Can you provide the steps for creating the calendar file?? thanks

Does anybody have any ideas about this??

I am using Business Object desktop intelligence and trying to come up with a formula to count days in between two dates. I have two date fields say start date and end date.I need to find out the days between these two dates excluding Weekends(saturday and sunday's). Any help would be...

I am using Business Object desktop intelligence and trying to come up with a formula to count days in between two dates. I have two date fields say start date and end date.I need to find out the days between these two dates excluding Weekends(saturday and sunday's). Any help would be...

Question, I have tried to place the following query into the macro "RunSQL" so I can schedule the macro to run automatically. It appeared the query is too long, it won't even let me paste it. Are there any other ways I can use to schedule this query to run automatically?? thanks

Thanks so much with your help.

Hi LB, Yes, it worked, i have placed in the detail section and did a summary of the @mtd and placed at my group footer. Can I ask for one more help on the YTD formula?? My YTD is not captures the Year to date balance anymore, how can I change my formula to also capture year to date balance on...

Hi LB, Thanks for the formula. I have tried but it didn't quite work. Not sure if i have did it right. I have placed my @mtd formula to the group footer (acct#) when i put in my date parameter for 4/1/2010 to 4/23/2010. My @MTD only capture the last balance (4/12) instead of adding all the...

Question, I have hard coded the {daterangeparam} into the @MTD formula. How can I add the actual parameter into this formula, so i don't have to manually change the date every week?? Here is what i have set up on my report @MTD: if (post.dt) in datetime (2010,01,01,00,00,00) to...

sorry, didn't know that was in the start< program menu. thanks for the help.

thanks for everyone's help.

Thanks..where do I find windows task scheduler to open the MS db?? Can you share the steps?? Thanks again!!

I have built a MS access macro to automatically truncate table and import the data. Does anybody know how to schedule the macro to run automatically and output the file to a folder?? thanks

Thanks. I have tried to do it by building a query but it doesn't look like it work. Is there any other ways to do this??

Thanks so much. It worked perfect.