Recent content by JanS

Hi All, I would appreciate advise if it is possible to display the windows username of the person who runs a report. Not the username to execute/run the report and return data but the name of the user logged into windows. Ive search for a function that would do this but cant find one. Im...

I had tried this, file size still above 10GB. Its a mystery whats using all the space. One Id like to solve as the size of backup files is becoming unmanageable. Cheers Jan

Hi, My apologies if a similar question has been dealt with in the past, the search engine of this website is down for maintenance. I am wondering if someone can help me determine how all the seemingly unused space can be freed from a 10GB SQL 2000 SP4 DB. Current results of sp_spaceused are...

NOt to worry - Ive worked it out by creating the sendmailtasks at runtime. Thanks Jan

Hi, I am trying to write a DTS package to loop through a rowset of email addresses (created by a Execute SQL Task) and send an email to each address in the rowset. This is to notify a number of people of certain data status. I can successfully loop through the rowset via an activex task and...

Hi Denny, Thanks for your response. I've got this working. Was able to create a batch file and a dts job with an execute process task so that this can be run on a scheduled basis. Thanks for your help. Jan

Hi, I have a requirement to create a DTS job that will execute a number of create view sql stmts from a file. The sql stmt might change frequently so we want to maintain it here not edit the DTS job everytime. An "Execute SQL Tasks" allows me to browse to the file but then imports the sql so...

All resolved with http://support.businessobjects.com/library/kbase/articles/c2016679.asp

Hi, Im configuring CE 10 and hoping to be able to use User Folders/Favourites and add objects that only those users can access. Problem is, I add an object to the user folder but when that user logs into ePortfolio, no objects can be seen. The user has Full Control of their folder. I can get...

Its okay - Ive recreated the report. All sems fine now. Ive no idea what happened as nothing in the original report had changed for 12 months. Thanks for the help.

No, theres more than one group in the report but only one is causing a problem - no need to mention those. Im not concerned about the order in which the values are returned, Im concerned that they are being repeated when my understanding of the benefits of using groups was to "group" like...

Hi, Im experiencing a problem with a report. One of the groups in the report is not displaying/grouping values correctly. For example, instead of seeing the following values for each group: 00 01 02 etc I see 00 01 02 00 01 02 etc The group values are not reported once but many time...

Thank you so much for all your help. Your last message showed me where I was going wrong - simple formatting error :/( silly me!

Thanks for your response. Where should the IF stmt be added? If I open the Select Expert and expand to get to the "Record Selection Formula Editor" it wont accept an IF stmt being added to the existing stmt (there are other parameters and selection criteria). Am I looking in the...

Hi, I have a requirement to change an existing report to use a parameter in the following way: Add two default values to a parameter - * (for all records) or "Head Offices Only" for a predefined set of records By selecting * the report should return details for all offices or for...