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
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,
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.