Search results for query: *

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"].

Has anyone come up with a way to hide a column in a webi (XIr2) report? I'm trying to sort on a column that I don't want shown in the report. The best I can come up with is to put the column on the right of the report and set the fonts to white and tiny. The minimum width for a column appears...

Assuming CE10 is on Windows Look in the folder below and you will be able to see the pathces applied. \Program Files\Crystal Decisions\Enterprise 10\Patches I don't know of anyway to see the information within the application. However the individual servers do have version numbers when viewed...

We have had to recover our CMS database from a previous backup. Unfortunately in the time between backups much work has been done on existing universes and webi reports, and also on additional universes and reports we have access to the universe files from the users' local copies and from the...

You can do it on XI but it involves looking at the object in the cmc where the filename is displayed. Unfortunately it will look something like this frs://Input/a_199/040/000/10439/cdzbd4468a488b55126.wid so you would have to map each file manually.

pseudo code here but i would go for something like this as a formula for price If printdate >= PRICE_EFF_DT AND printdate <= PRICE_EXP_DT) then price else 0 may not work if you don't have a valid date range for a product store combination