Search results for query: *

Hey guys, I have never done a cascading prompt before - can someone run me through how to do one. It is using BO 6.5, but is then being accessed via WebI. Cheers, Stuart

Hey guys, I have a report which our user would like to view for the following periods; 'Today', 'This Week', 'This Month' & 'Custom Period' This report is going to end up being accessed via WEBI. Can anyone give me any ideas? Cheers, Stuart

Hey guys, I'm back doing BO after 3 years and have forgotten just about everything. I'm trying to create a drill down report based on the following; 1.Number of calls closed by department 2.Number of calls closed by employee 3.Priority of calls closed. 1 being the highest level and 3 being...

Hey guys, I am back doing BO after a good 4 years and have forgotten alot!! We have a SQL SERVER 2005 DB. I would like a number of objects in my universe along the lines of; Todays Date (Date) Todays Date (Date & Time) I have tried using Now() but for some reason this doesn't parse. Can...

Hi folks, I've been asked to created a new chart which is split between having a few stacked areas and 1 line. So far I have managed to get the line to appear but unfortunately it has the boxes on every data point. How do I get rid of these?? Cheers, Stuart p.s. All I have done is created...

Hey folks, I have a major issue at the moment. I am geting sent a csv file to import using a dts package. It comes in a standard format, but.... One field keeps having a double quote every so often. Does anyone have any code that will allow me to convert this to 2 single quotes or 2 double...

Hi folks, I'm using CR_XI. I have a crosstab which displays the hours worked by resources over a year. So it kinda looks like a timesheet. The crosstab is in columns by date and rows by resource. Is it possible to have a title above the column of resources? And what if I add more data...

Hi folks, has anyone else found deleting or editing chart titles a bit buggy? I try and delete the text, and it just doesn't bother. Sometimes, if I change the text to a single space, then delete the text, it works? Stu

Hi folks, I have a DTS job which imports a csv file overnight on a daily basis. Unfortunately, one of the columns has started to have double quotes entered into it, this causes the datapump to fail. Does anyone know if it is possible to programatically run through the file adding a second...

Hey Guys, I have 2 tables which I want to group on Date and ResourceDisciplineID. I have gotten this far but get stuck adding the 2nd join? Anyone able to help? select TFU.*, SI.* from #TimeFrameUnion TFU LEFT JOIN #ScheduledInfo SI on TFU.resourcedisciplineid = SI.resourcedisciplineid

Hey folks, I have regular imports of csv files running overnight. Anyway my main problem is that, if there is a corrupt row, ie a record with a double quote in it. The import just doesn't work! My delimiter is a double quote. Is there a way to trap this error, and run some other code...

Hi Folks, I have a report which sums hours over set periods; weeks then months then quarters and then years. Obviously the figures in these columns increases the further right you go, ie years. Is it possible to change the width of a specified column within a crosstab? I would like the group...

Hi folks, I have a report based on a stored proc which takes parameters. Is it possible to have multiple instances of this stored proc within a report which have different parameter values? And further to this, is it possible to have different sp's within the same report. I always come...

Hey guys, So when I have a report based on a stored proc and another table, whenever I try and display data from both tables I get the following errors in this order. "Failed to retrieve data from he database." "Unknown Database Connection Error" Can anyone shed any light on this situation?

Hey guys, So, I'm completely stuck!! I require my report to be based on a stored proc, this is so it can create a temporary table which the report will in effect be based on. This table will contain the time frame for the report. However, I require to report on multiple datasets ie project...

Hey folks, Does anyone know if it is possible to allow the report user to select or deselect the columns they wish to view on the report at refresh time? Stuart

Hey Guys, So I have a report based on a stored proc with 3 parameters, this is all working quite well. However, I have one report which the user would like to see the effect of 'removing' some data from the report, ie removing a project, the hours should go down. Is it possible to have the...

Hey guys, anyone know if you can have a formula like this; [Page N Of M] + " - " + [Horizontal Page Number] I would like it to appear at the bottom left of every page.

Hey guys, Right so a cross tab object can not go into the detail section for obvious reasons, it has to go into the report header, so how on earth do I get Page Numbers to come up correctly. I tried mucking about with the grouping expert to see if I could do anything with that but with no...

Hi Folks, My report has a few parameters, so when I refresh it, I keep getting asked whether I wish to use the current parameters or choose other ones. Is it possible to force the user to always enter new values? Thanks, Stuart