Search results for query: *

You'll need to do that through the settings when printing I believe.

I did this migration over a year ago...more like 200 reports... Be prepared to let go of the nice formatting and the drilling through of a report. In my case, we made some improvements to the way we provided reporting and the end users accepted the changes very well. Good luck! And start with...

Ours are setup w/0 a Provider String... Provider: SQL Native Client Product Name: SQLNCLI Data Source: [2000 SQL Server Name] Catalog: [2000 SQL Server Database Name]

In order for SQL2000 to reference an instance of SQL2008 it is necessary for certain files and drivers to be updated. This might be an issue if you have legacy applications on the SQL2000 server, but if you wish to try this you will need to download and install the following items: Microsoft...

I'm saying you should create a variable...click on your dataset and choose Add to create a variable.

I would create a variable to hold this...then simply add it to any group level that you want to see a sum. =SUM(Fields!rptGrossMargin.Value)

In 2005, the code dot intellisense doesn't work. Here's how I've formatted my custom code. Function GetFontStyleIfMonth(FieldText As String) As If FieldText.ToLower.Contains("january") Or FieldText.ToUpper.Contains("february") Then GetFontStyleIfMonth = "Bold" Else...

You'll have to do dynamic sql or utilize a function that will send back a table...this isn't supported.

CREATE FUNCTION [dbo].[udf_StripHTML] (@HTMLText VARCHAR(8000)) RETURNS VARCHAR(8000) AS BEGIN DECLARE @Start INT DECLARE @End INT DECLARE @Length INT SET @Start = CHARINDEX('<',@HTMLText) SET @End =...

I have heard of ASP.Net calls that will do this. I could bet that is your issue if utilizing it via web page. Count up the post backs! :)

You need a table alias when using the UNION ALL

Yes. If I select R, so the top group is showing, it works...if I select B, it displays a blank line that cannot be clicked to get to the second group.

http://www.sqlservercentral.com/scripts/T-SQL+Aids/31116/

What I have done for this is setup a dummy group that doesn't display above the group you want page breaks. Below, you'd want a page break for each Group 2. 1. Group 1 2. Dummy Group 3. Group 2 The dummy group would group by a variable. =IIF(Parameters!Break.value =...

Dave's follow up should work. Format = #,###.00###

Couldn't you just set the format value to #,###.#####

And if you need nested... select case when ProjTypeName = 'Packaging' then 'Some New Type' else case when ProjTypeName = 'Labeling' then ProjTypeName + ' ' LaLaField else ProjTypeName end end as NewProjectType

I am converting from 2005 to 2008 and have a report that does the following and is not working: 1. User selects a parameter denoting how they'd like to view the report (B or R values). 2. If "B" then hide the top group and show the second group and allow expanding into groups 3,4 3. If "R" show...

I would just like to export them to a network location because we're going to be shutting down the server for good, but want backups in case.

Is there a way to export all .rpt objects from Business Objects Enterprise?