Recent content by huggyd

As far as I know you cannot "parameterise" select statements in this way. The options I tend to use in this scenario are Either use 10 IF statements to return the correct column eg. IF @SelectDate = 'DataTime1' SELECT DataTime1, FieldA, FieldB, FieldC FROM dbo.Table ORDER BY DataTime1 Desc...

I have been asked to produce SSRS2008 reports from SharePoint 2007 lists. I have found plenty of examples for how to use getlistitems method from the Sharepoint web services within an XML data set. However every example seems to stop short of explaining how to get to the contents of the folders...

Adding a parameter to control the initial state is the best I can come up with so far.

I have a detailed recordset of helpdesk calls for a report that summarises into differing views by category, status etc. One of the demands on the report is to show top 5 applications by total calls logged over 5 weeks. The tablix has week number as the columns, applications as the rows and...

Is it possible to show any of the details of the datasource on the report itself at runtime? We have separate shared datasources set up for our development and live environments and would like to display the datasource in the footer of the reports. In the code view of the report I can see the...

You cannot save a report CR11 to CE10 as you will get the following error Access denied. You cannot log on to an older version of the CMS

I have a brand new installation of BOXI Enterprise R2 with AD authentication enabled and users imported. Reports have been imported from other BOXI instance. I have Infoview set up to use AD authentication successfully. I have also set up the Boxi Sharepoint integration kit. When i try using...

BOXi R2 SQL Server 2005 I have a derived table in my universe design that is a select from a SQL Server function. I am trying to set up a prompt that will allow me to pass multiple values the function's parameter such as a list of sites. The prompt is set to the following: @Prompt('Select...

When I said which application I was after which app within business objects and whcih version. For your nulls look at the ISNULL() function. For blanks try <Activity Volunteer Last/Org Name> = "".

What application are you writing this code in?

The easiest way is probably to post the entire variable ...

I have a report with breaks in it. Some of the breaks have only a few rows, some have more rows than fit a page. I want to have the header row show at the start of each group and at the top of the page. A simple request I thought. If I use section headers I can have one at the start of each...

Are you actually seeing Closed items in your Cancelled items? An if statement returns on the first condition that it meets so it won't include those that qualify as "closed" in those that are cancelled. Therefore you should not have to exclude the closed in the cancelled. If you do need to...

The column is only being used for sorting. It contains a sequence of numbers to sort by If i remove it from the report I cannot use it to sort anymore.

I'm not sure you are using the correct operator. Like is for pattern matching eg {customer.LAST NAME} like "*s?n*". I think you should be using the IN array eg {file.COLOR} in ["Red", "White", "Blue"].