Search results for query: *

Thanks OTTO/mrdenny. I will do the way been suggested. Regards Jay

Hi There, Our SQL server is set to UK which leads to start the week on Sunday. How can we cange the database setting to Monday as the first day of the week. If we change this in Query Analyzer using SET DATEFIRST, this works only for the session. Any help regarding this will be highly appreciate

Thanks Joey and Jurgen. I will try to find some software. I will let you know with the outcome. Regards Jay

Hi there, I am running XP. I have a big disk. I want to create a partition. Diskpart can't create it. Some how it showing 0 free space. Can someone help me please.

Hi Steve, I need to give the report a different name. Don't want to keep as instance within the same report. Our InfoView user wants them separately. Please advise, if there is a way. Regards Jay

Hi There, I have a VB module in XI which is used with scheduler. I want to save the report in a different name everytime after execution. This was working fine with my BO6.5. I was adding the date of execution at the end of the actual report name. IE. My original report name is test. I was...

Hi, You can try one simple way if that helps. Create a simple report with the variable you need. click on the report, right mouse click, format table, go to pivot. put your city,state under column, hobby under row and order under body. Let me know whether that meets your requiement.

Hi Steve, Thanks for the reply. The webi server refreshing was the issue. Thanks for the help.

This is verson 6.1. Probelm comes to login into info view.

Hi, I have created two new user. When trying to login with one of them in Infoview, it giving me the error mentioned above. There other userid is working fine. In idea will be highly appreciate. Regd Jay

This looks the new field added to the report is coming from a new table with a one-to-one join. Check this and if required change the join to out-join if that is your requirement.

Hi there Would you be able to include an example.

Dear All, When I am executing a process from a macro using step In (F8) it's doing exactly what I want. Refreshing the report, creating a copy in my c:\shareDrive and sending an email to the user. But when I am submitting this into the schedular, its generating number of email of the same thing...

Hi Steve, Thank you very much. I think this will work. I was wondering how this will work when the time is 1.59032. If I deduct .005 it will be 1.58532 which will round up to 1.59. I missed the round up in the first place. Thanks for the big help. Regards Jay

Hi Steve, Thanks for the quick reply. Now, taking .5 seconds deduction may not work properly. Two example of calculated time could be 01.59532(mm.ss) , 01.50532(mm.ss). If I deduct unconditional .5 would give me incorrect result. I need to deduct only when mm.ss is 01.595 or above. Any...

Hi There, I have calculated second from two datetime value. I need to present the average time by minutes and time format. I used following statement to transfer the value into time and minutes. =Floor((<Activation Time - TimeInSec(Act-Day)>/<Activation - Cases(Act-Day)>)/60)+...

Hi Steve/Geoff, It's all working fine now. Thanks a lot for your help. Regards Jay

Hi, Thanks guys for your help. It's working. Saving the files and picking active and inactive(created in a separate run) files in email attachment. I am having a bit of problem when adding multiple attachment. It's send more that one email. My code is like as belows Msg.AddAttachment...

Hi Steve/Ties, Thank you very much for your attention and advise in this issue. I tried with the first option, having two separate universe which links to different server and database. I had two dataprovider with a common linked field. Which is working fine. Best Regards Jay

Hi Geoff, Your advise is highly appreciated. I have got my machine address ready now and I wish this is going to work. Thanks. Jay