How to upgrade a ReportServer db from 2000 to 2005?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Reporting Svcs
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Reporting Services Quirks? Hi, I'm a bit of a newbies to BIDS and SQL Server 2005 and I've noticed a couple on things about Reporting Services. - Has anyone noticed that it's almost impossible to get the background and font settings to work in the Reporting Services Query Analyzer? -When I execute any query with a "where" clause, the Query Analyzer returns the column headings but no returned data is visible. However, it seems to be getting the results back, because my reports run with the results set. Also, the SQl analyzer runs it without a hitch....weird. - Does Reporting Services ever just stop and hang for you? I usually have to reboot several times a day. Even though this is the only thing running on my machine except SQL Query Anayzer. I have only a half gig of RAM, but I have very little running on the desktop. So far I have patched, and service packed both SQL and Visual Studio 2005, but still have weird behavior with the tool. Anyway, as misery loves company, please respond with your stories and any fixes you have found. Best, Scott Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71518
  - 2
    - Syntax for Nested Properties? Suppose I have an object model in which an Order has a related Customer who has a related address. In a report of displaying Orders, how can I show, for each Order, the Customer.CompanyName Customer.Address.City Customer.CompanyName is nested to a single level; Customer.Address.City is nested to two levels. I remember that there is a special syntax to use when referencing nested properties in an .RDL, but I can find any trace of it in my own files or through Google. Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71515
  - 3
    - Exclude Crystal Reports from Help searches Is there any way to keep the Help file information associated with Crystal Reports from displaying when I search? I don't have this product and it just gets in the way when looking for answers. TIA dean Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71512
  - 4
    - Adding data from Subreport with data from Main Report How can I create an expression that Adds values from a main report to values from a subreport? TIA Dean Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71511
  - 5
    - reference material This is more of a general question to those of you in the group. I am looking for a good reference book regarding SQL Server 2005 Reporting Services and I'm wondering what book some of you would recommend. Thanks in advance for the info. ... John Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71509
  - 6
    - 5 digit zipcode I am trying to display just the first 5 digits of the zip code. How can I do this? Thanks Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71502
  - 7
    - Forms authentication ticket timeout How do we change the authentication from timeout to a larger number in report server with forms authentication? thanks! Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71496
  - 8
    - RSClientPrint deployment question. I have read the thread 'print active x question' posted more than a year ago and would like to follow up... We have an application using a webbrowser control to access reporting services and have run into the issue of needing RSClientPrint installed during our setup because security policies/settings may prevent the user from installing the activex at runtime. Has MS provided an .msi or merge module, etc. to deploy this yet? If not, is there a definitive answer to which folder we should put the files?...is it possible/safe to put them in Downloaded Program Files? Thanks! Kevin Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71495
  - 9
    - Unable to design local report - Add new data source disabled We recently converted a web application from VS 2003 to VS 2005 SP1. As we desired, it was converted to the "Web application project" format rather than the "Web Site Project" format. The application has been functioning OK since the conversion. By the way, I did a full install of VS 2005, except I did not elect to install SQL Server 2005 Express Edition. Our web application uses SQL Server 2000 as the database. For the first time recently I attempted to design a reporting services report in "local mode". I opened the report designer and it appeared fully functional, except that in the "Website Data Sources" window the "Add New Data Source", "Edit Data Source with Designer" and "Configure Data Source with Wizard" buttons were all disabled. The only enabled button was "Refresh". No data sources were listed in the window. I created a new strongly typed dataset/table adapter, and clicked "Refresh" and still nothing was listed in the window. Then after some reading, I thought maybe the designer was designed with "Web site" projects in mind and expected to find data sources in the "App_code" directory. Of course, a "web application" project does not need an "app_code" directory, but I created one for this purpose and created a strongly typed dataset/table adapter in that directory. I hit refresh in the designer, and still no data sources were listed in the "Website Data Sources" window. And the designer requires a data source for designing a report. I cannot proceed until I create a data source. Has anyone else encountered this problem? Is it related to "web application" projects? I particularly don't understand why the "Add new data source" button is disabled. Would appreciate any help. Regards, Robert Reader Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71494
  - 10
    - Unable to specify NONE for default value of report parameter I have a report with a single parameter that allows nulls. If I preview the report in VS2005, the report launches immediately instead of prompting for values for the parameters which I would expect to happen whenever all of the parameters have default values. However, I cannot specify "NONE" as the default value. The only options for Default Values on the Report Parameters screen are "Non-queried", "From query", and "Null". How do I specify tha the parameter does not have a default value? Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71492
  - 11
    - Check Boxes Typically we use the wingdings font to render check boxes. Not everyone has wingdings installed so sometimes it fails. We have also used images. Got any other slick ways to do this? Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71490
  - 12
    - calculation with dates challenge I have a start and end datetime field and a field with the lunchbreak in minutes. Now I need to find out the number of hours and minutes (HH:mm) this person has worked. endtime - starttime - lunchbreak and formatted in HH:mm. Suggestions on how to go about this in Reporting services ? Peter Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71488
  - 13
    - Specify number of copies to print There has to be a way to do this! Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71484
  - 14
    - Date Parameter I am trying to create a parameter for time period ending dates for a report involving the number of hours employees have worked in each time period. There are two issues that I am running into: (1) When I do the "preview" of the report, the parameter brings back a time period ending date for each employee. For example, there are over 100 entries for the ending date 8/6/2006, one for each employee. How can I change it so that it only brings back one entry for 8/6/2006? (2) Again, in the report "preview," when I select one of the dates above, it brings back the information for all employees for all time periods, not just the information for employees for a specific time frame. My end goal would be to have the report set up so that there is only one entry in the parameter drop-down list for each time period, and when one such entry is selected, that the information for all employees for that dates are returned on the report. Any insight would be appreciated! Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71481
  - 15
    - Running CRM Reports via Report Manager How can I run reports designed for CRM to run in our Report Manager environment with proper security rights? Thank you. Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71480
  - 16
    - Report problem with parameter controlled visibility I have this short report: <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <DataSources> <DataSource Name="W_I_S__HOLDING_GMBH__CO__KG_MSCRM"> <DataSourceReference>W_I_S__HOLDING_GMBH__CO__KG_MSCRM</DataSourceReference> <rd:DataSourceID>cb79d461-d5f9-4c9a-8b82-3afa39f9c7f5</rd:DataSourceID> </DataSource> </DataSources> <BottomMargin>2.5cm</BottomMargin> <RightMargin>2.5cm</RightMargin> <PageWidth>21cm</PageWidth> <ReportParameters> <ReportParameter Name="Details"> <DataType>Boolean</DataType> <AllowBlank>true</AllowBlank> <Prompt>Report_Parameter_0</Prompt> <ValidValues> <ParameterValues> <ParameterValue> <Value>True</Value> <Label>Ja</Label> </ParameterValue> <ParameterValue> <Value>False</Value> <Label>Nein</Label> </ParameterValue> </ParameterValues> </ValidValues> </ReportParameter> </ReportParameters> <rd:DrawGrid>true</rd:DrawGrid> <InteractiveWidth>21cm</InteractiveWidth> <rd:GridSpacing>0.25cm</rd:GridSpacing> <rd:SnapToGrid>true</rd:SnapToGrid> <Body> <ColumnSpacing>1cm</ColumnSpacing> <ReportItems> <Table Name="table1"> <DataSetName>DataSet1</DataSetName> <Top>1.75cm</Top> <TableGroups> <TableGroup> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="Description"> <rd:DefaultName>Description</rd:DefaultName> <ZIndex>5</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <BackgroundColor>DarkGray</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>=Fields!Name.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox11"> <rd:DefaultName>textbox11</rd:DefaultName> <ZIndex>4</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <BackgroundColor>DarkGray</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox12"> <rd:DefaultName>textbox12</rd:DefaultName> <ZIndex>3</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <BackgroundColor>DarkGray</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.63492cm</Height> </TableRow> </TableRows> </Header> <Grouping Name="table1_Group1"> <GroupExpressions> <GroupExpression>=Fields!Name.Value</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> <TableGroup> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="OwnerIdName"> <rd:DefaultName>OwnerIdName</rd:DefaultName> <ZIndex>2</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <BackgroundColor>LightGrey</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>=Fields!OwnerIdName.Value</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox10"> <rd:DefaultName>textbox10</rd:DefaultName> <ZIndex>1</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <BackgroundColor>LightGrey</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox16"> <rd:DefaultName>textbox16</rd:DefaultName> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <BackgroundColor>LightGrey</BackgroundColor> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.63492cm</Height> <Visibility> <ToggleItem>Description</ToggleItem> <Hidden>= NOt Parameters!Details.Value</Hidden> </Visibility> </TableRow> </TableRows> </Header> <Grouping Name="table1_Group2"> <Filters> <Filter> <Operator>NotEqual</Operator> <FilterValues> <FilterValue>Spickermann, Wolfgang</FilterValue> </FilterValues> <FilterExpression>=Fields!OwnerIdName.Value</FilterExpression> </Filter> </Filters> <GroupExpressions> <GroupExpression>=Fields!OwnerIdName.Value</GroupExpression> </GroupExpressions> </Grouping> </TableGroup> </TableGroups> <Header> <TableRows> <TableRow> <TableCells> <TableCell> <ReportItems> <Textbox Name="textbox4"> <rd:DefaultName>textbox4</rd:DefaultName> <ZIndex>8</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value>Description</Value> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox2"> <rd:DefaultName>textbox2</rd:DefaultName> <ZIndex>7</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> <TableCell> <ReportItems> <Textbox Name="textbox3"> <rd:DefaultName>textbox3</rd:DefaultName> <ZIndex>6</ZIndex> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </TableCell> </TableCells> <Height>0.63492cm</Height> </TableRow> </TableRows> </Header> <TableColumns> <TableColumn> <Width>5.33333cm</Width> </TableColumn> <TableColumn> <Width>5.33333cm</Width> </TableColumn> <TableColumn> <Width>5.33333cm</Width> </TableColumn> </TableColumns> <Height>1.90476cm</Height> </Table> </ReportItems> <Height>6.19444cm</Height> </Body> <rd:ReportID>df4cb76b-482a-4cc2-a2de-445ed4cc2a05</rd:ReportID> <LeftMargin>2.5cm</LeftMargin> <DataSets> <DataSet Name="DataSet1"> <Query> <rd:UseGenericDesigner>true</rd:UseGenericDesigner> <CommandText>SELECT TOP 100 * FROM Opportunity</CommandText> <DataSourceName>W_I_S__HOLDING_GMBH__CO__KG_MSCRM</DataSourceName> </Query> <Fields> <Field Name="AccountIdDsc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>AccountIdDsc</DataField> </Field> <Field Name="AccountIdName"> <rd:TypeName>System.String</rd:TypeName> <DataField>AccountIdName</DataField> </Field> <Field Name="CampaignIdDsc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CampaignIdDsc</DataField> </Field> <Field Name="CampaignIdName"> <rd:TypeName>System.String</rd:TypeName> <DataField>CampaignIdName</DataField> </Field> <Field Name="ContactIdDsc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>ContactIdDsc</DataField> </Field> <Field Name="ContactIdName"> <rd:TypeName>System.String</rd:TypeName> <DataField>ContactIdName</DataField> </Field> <Field Name="CreatedByDsc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CreatedByDsc</DataField> </Field> <Field Name="CreatedByName"> <rd:TypeName>System.String</rd:TypeName> <DataField>CreatedByName</DataField> </Field> <Field Name="ModifiedByDsc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>ModifiedByDsc</DataField> </Field> <Field Name="ModifiedByName"> <rd:TypeName>System.String</rd:TypeName> <DataField>ModifiedByName</DataField> </Field> <Field Name="OriginatingLeadIdDsc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>OriginatingLeadIdDsc</DataField> </Field> <Field Name="OriginatingLeadIdName"> <rd:TypeName>System.String</rd:TypeName> <DataField>OriginatingLeadIdName</DataField> </Field> <Field Name="PriceLevelIdDsc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>PriceLevelIdDsc</DataField> </Field> <Field Name="PriceLevelIdName"> <rd:TypeName>System.String</rd:TypeName> <DataField>PriceLevelIdName</DataField> </Field> <Field Name="OwnerId"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>OwnerId</DataField> </Field> <Field Name="OwnerIdName"> <rd:TypeName>System.String</rd:TypeName> <DataField>OwnerIdName</DataField> </Field> <Field Name="OwnerIdDsc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>OwnerIdDsc</DataField> </Field> <Field Name="OwnerIdType"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>OwnerIdType</DataField> </Field> <Field Name="CustomerId"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>CustomerId</DataField> </Field> <Field Name="CustomerIdName"> <rd:TypeName>System.String</rd:TypeName> <DataField>CustomerIdName</DataField> </Field> <Field Name="CustomerIdDsc"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CustomerIdDsc</DataField> </Field> <Field Name="CustomerIdType"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CustomerIdType</DataField> </Field> <Field Name="OpportunityId"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>OpportunityId</DataField> </Field> <Field Name="DeletionStateCode"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>DeletionStateCode</DataField> </Field> <Field Name="PriceLevelId"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>PriceLevelId</DataField> </Field> <Field Name="OpportunityRatingCode"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>OpportunityRatingCode</DataField> </Field> <Field Name="PriorityCode"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>PriorityCode</DataField> </Field> <Field Name="ContactId"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>ContactId</DataField> </Field> <Field Name="AccountId"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>AccountId</DataField> </Field> <Field Name="Name"> <rd:TypeName>System.String</rd:TypeName> <DataField>Name</DataField> </Field> <Field Name="StepId"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>StepId</DataField> </Field> <Field Name="Description"> <rd:TypeName>System.String</rd:TypeName> <DataField>Description</DataField> </Field> <Field Name="EstimatedValue"> <rd:TypeName>System.Decimal</rd:TypeName> <DataField>EstimatedValue</DataField> </Field> <Field Name="StepName"> <rd:TypeName>System.String</rd:TypeName> <DataField>StepName</DataField> </Field> <Field Name="SalesStageCode"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>SalesStageCode</DataField> </Field> <Field Name="ParticipatesInWorkflow"> <rd:TypeName>System.Boolean</rd:TypeName> <DataField>ParticipatesInWorkflow</DataField> </Field> <Field Name="PricingErrorCode"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>PricingErrorCode</DataField> </Field> <Field Name="EstimatedCloseDate"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>EstimatedCloseDate</DataField> </Field> <Field Name="CloseProbability"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CloseProbability</DataField> </Field> <Field Name="ActualValue"> <rd:TypeName>System.Decimal</rd:TypeName> <DataField>ActualValue</DataField> </Field> <Field Name="ActualCloseDate"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>ActualCloseDate</DataField> </Field> <Field Name="OwningTeam"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>OwningTeam</DataField> </Field> <Field Name="OwningUser"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>OwningUser</DataField> </Field> <Field Name="OwningBusinessUnit"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>OwningBusinessUnit</DataField> </Field> <Field Name="OriginatingLeadId"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>OriginatingLeadId</DataField> </Field> <Field Name="CreatedOn"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>CreatedOn</DataField> </Field> <Field Name="IsPrivate"> <rd:TypeName>System.Boolean</rd:TypeName> <DataField>IsPrivate</DataField> </Field> <Field Name="CreatedBy"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>CreatedBy</DataField> </Field> <Field Name="ModifiedOn"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>ModifiedOn</DataField> </Field> <Field Name="ModifiedBy"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>ModifiedBy</DataField> </Field> <Field Name="VersionNumber"> <rd:TypeName>System.Byte[]</rd:TypeName> <DataField>VersionNumber</DataField> </Field> <Field Name="StateCode"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>StateCode</DataField> </Field> <Field Name="StatusCode"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>StatusCode</DataField> </Field> <Field Name="IsRevenueSystemCalculated"> <rd:TypeName>System.Boolean</rd:TypeName> <DataField>IsRevenueSystemCalculated</DataField> </Field> <Field Name="CFPKundenkategorie"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CFPKundenkategorie</DataField> </Field> <Field Name="CFCDeckungsbeitrag"> <rd:TypeName>System.Decimal</rd:TypeName> <DataField>CFCDeckungsbeitrag</DataField> </Field> <Field Name="CFIKundennummer"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CFIKundennummer</DataField> </Field> <Field Name="CFPLaufzeitinMonaten"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CFPLaufzeitinMonaten</DataField> </Field> <Field Name="CFPBefristung"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CFPBefristung</DataField> </Field> <Field Name="CFCMonatsumsatzderErweiterung"> <rd:TypeName>System.Decimal</rd:TypeName> <DataField>CFCMonatsumsatzderErweiterung</DataField> </Field> <Field Name="CFPAuftragseingangAuftragsÃ¤nderung"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CFPAuftragseingangAuftragsÃ¤nderung</DataField> </Field> <Field Name="CFPLeistungsart"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CFPLeistungsart</DataField> </Field> <Field Name="CFPNiederlassung"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>CFPNiederlassung</DataField> </Field> <Field Name="CFFDBDeckungsbeitrag"> <rd:TypeName>System.Double</rd:TypeName> <DataField>CFFDBDeckungsbeitrag</DataField> </Field> <Field Name="CampaignId"> <rd:TypeName>System.Guid</rd:TypeName> <DataField>CampaignId</DataField> </Field> <Field Name="New_Auftragswahrscheinlichkeit"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>New_Auftragswahrscheinlichkeit</DataField> </Field> <Field Name="New_WISKostenstelle"> <rd:TypeName>System.String</rd:TypeName> <DataField>New_WISKostenstelle</DataField> </Field> <Field Name="New_Kundennummer"> <rd:TypeName>System.String</rd:TypeName> <DataField>New_Kundennummer</DataField> </Field> <Field Name="New_Deaktivierungsgrund"> <rd:TypeName>System.Int32</rd:TypeName> <DataField>New_Deaktivierungsgrund</DataField> </Field> <Field Name="New_Stunden"> <rd:TypeName>System.Double</rd:TypeName> <DataField>New_Stunden</DataField> </Field> <Field Name="New_BeginnPhase1"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>New_BeginnPhase1</DataField> </Field> <Field Name="New_BeginnPhase2"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>New_BeginnPhase2</DataField> </Field> <Field Name="New_BeginnPhase3"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>New_BeginnPhase3</DataField> </Field> <Field Name="New_BeginnPhase4"> <rd:TypeName>System.DateTime</rd:TypeName> <DataField>New_BeginnPhase4</DataField> </Field> </Fields> </DataSet> </DataSets> <Width>16cm</Width> <InteractiveHeight>29.7cm</InteractiveHeight> <Language>de-DE</Language> <TopMargin>2.5cm</TopMargin> <PageHeight>29.7cm</PageHeight> </Report> The visibility of group2 is controlled by a boolean parameter expression in the hidden field. also i have a filter on group2. If I preview the report, the filtered row occours as an empty gray row. this only occurs if the filtered expression is the only row in group2. is this a bug? any suggestions? Thanks, Mike Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71477
  - 17
    - Target Actively Refused HELP! Hi All, I have a reporting server on SQL 2000 that accesses cubes on a separate Analysis Services box. For some reason administrators are able to run reports fine however normal users receive the error: No connection could be made because the target machine actively refused it. I am at a loss and have no idea what to look at. Thanks! Ash Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71476
  - 18
    - How to convert SSRS2005 report to SSRS2000? The SSRS2000 doesn't work with SSRS2005 rdl files. How could I convert them? Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71473
  - 19
    - conditions to successfully create a subscription? Hi, the report I am trying to create a subscription for has no parameters. it is not a linked report: it contains subreports and none of them has user-defined parameter. I tried Credentials stored securely in the RS, with a domain account (and selecting the windows authentication), or the SA account, or another sql account created for the occasion, the report runs fine, but I could not create a subscription, the error being: the credentials are not stored locally, or the report is a linked report (which it is not) with invalid link, or has user-defined parameters which is not true. So how to troubleshoot this problem and create the subscription? or could I do this with a sql script instead of the Report Manager? anyone has a script to share? Thanks Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71463
  - 20
    - no data handling I have created a sales checking report which will only show the items below the sales target, now I subcribe this report by email daily basis, but even there are no any data on the report, it will also sumbit a blank report to me. it is possbile to control no data handling for reporting or subcription. Thanks for any suggestions. Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71460
  - 21
    - Problem connecting to RS? From SQL Server 2005 i am connecting to sql server 2000 database. I try to connect to 'Reporting Services Configuration Manager' and i received error message 'Provider load failure'. What should i do to make RS work? Should i reinstall SQL Server2005? Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71455
  - 22
    - List Control - Group Header RS2000 I need to modify a report that has a list containing other controls, subreports..etc that can span multiple pages. How can we show a "group header" on each page rendered withing the list? We tried moving the list contents into a table cell but the group headers won't repeat on each page. Thanks Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71452
  - 23
    - using .rdlc sub report i want to use .rdlc for sub report but simply couldnt get the idea of nested objects (Objectdatasource) for subreports very clear so for the sake of knowing i would like to see some example Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71450
  - 24
    - Joining Tables Across Multiple Datasets I am trying to join two tables from two different datasets in SQL Server 2005 Reporting Services. How would one go about doing this? Since there are technically two spots to have SQL queries (one for each dataset), how does one go about doing SQL? Is joining across multiple datasets even possible? If so, are there clever workarounds? Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71449
  - 25
    - Displaying Top N subtotal as well as grand total I am currently migrating Crystal Report XI reports over to the Reporting Services and came across a problem. The Crystal Report displays Top N records, subtotal of these Top N records, and the grand total of all the records. SQL stored procedure underneath returns all the records. >From what I have been reading in online groups and helps, these types of features are not directly supported in the Reporting Services. The workaround I have found so far involves returning two sets of results ("Top N" results and "All" results) and combining the two result sets. Since some query takes up significant amount of time, I would like to avoid calling the stored procedures twice if necessary. Does anyone know how I can avoid this and work with just one result set? Thanks in advance. Shohei Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71443
- Next
  - 1
    - Excel Exports Hidden Images Hello, I think this may be a bug with SSRS 2005 but wanted to verify in case anyone has a remedy. My report contains a table with an image on the detail row whose visibility is toggled based on a value. Everything works as expected when viewing the report onscreen or exporting to PDF. However, the Excel Export ignores the visibility expression and displays the image for every detail row. Any thoughts or workarounds? Thanks in advance! Kathy Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71439
  - 2
    - controlling text box location I have a text box above a matrix and the matrix is set to start on a new page. how do I get the text box to start on the new page also? TIA Dean Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71438
  - 3
    - The permissions granted to user 'Adelso-PC\Adelso' are insufficient for performing this operation. (rsAccessDenied) When access http://localhost/reportserver$SQLExpress the first time after SQL Server with Advance Services installation on Windows Vista Ultimate, the SQL Server Reporting Services show the following error: "Reporting Services Error: The permissions granted to user 'Adelso-PC\Adelso' are insufficient for performing this operation. (rsAccessDenied) Get Online Help". After granted permissions to Adelso on the properties of the ADELSO-PC\SQLEXPRESS database the problem persist. There are something that I'm doing wrong or missing? Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71437
  - 4
    - Dynamic formatting Can someone please provide me some pointers on dynamic formatting. How can I change the formatting information from code. Where on SQL Books online can I get information on dynamic formatting Thanks Karen Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71435
  - 5
    - Report Builder - Add a report date any way using report builder ad hoc tool for users to add an "as of" date to a report using the TODAY function? Rich Belanger Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71434
  - 6
    - Mozilla Firefox and Report Viewer Print control Has anyone gotten the print control in report viewer to work with Firefox? One of our clients insists on using firefox and we would like to use reporting services. I found and downloaded the Mozilla Activex control and plugin support, added the CLSID for the RSClientPrint control, but have not had any success in having the control show up in the report viewer. Microsoft's knowledge base talks about what does and doesn't work in Firefox, but mentions only that the print control does not work in Safari. Any help would be greatly appreciated! Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71433
  - 7
    - Grouping Data in charts Is it possible to group data in charts? e.g. I need to return a graph with % and other data per office separately for a board pack so the charts either appear per office on a page or a couple of charts per page. Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71425
  - 8
    - Dates and Parameters I have created a report with parameters, I select the dates (01/05/2007) to (01/07/07) using the calendar and then click view report the dates then reset to (05/01/07) to (07/01/07) and no data is displayed yet the parameters which are displayed in the report are returning the correct values. When you click view report again without amending the dates the data is returned and the parameters values as displayed in the report are incorrect. Please help. Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71424
  - 9
    - sql90exception Hi! I'm getting this message on my 32 bit Windows 2003, SQL Server 2005, SP 2 (9.0.3054) EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 462f8102, P7 0, P8 00005253, P9 00000000, P10 NIL. Is there anyone who knows what this means? /* Fari */ Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71421
  - 10
    - Newbie Here: headers print even though drill down not clicked I have a report containing drill down detail. The headers for the drill down detail prints even at the summary level. This is causing two pages to print for every one due to the headings. How can I turn the headers off unless the user has selected to view the drill down data. Any help would be greatly appreciated. Thanks! Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71410
  - 11
    - Report referencing dynamic table Hi all Just wondering how one would approach buidling an RS report based on a dynamic table ie. Each time the report is run, the table may have a different number of columns. Here is what I'm trying to acheive: The user enters a date range for the report. The report then calls a SQL stored proc which generates a table containing columns for each day in the date range. That table is then used as a datasource in the report. Any assistance guidance will be appreciated Thanks in advance George Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71409
  - 12
    - run IIS error? When i go to My computer-Manage-IIS(restart). I have folowing error message; The service has not been started. I did reinstall IIS. What should i do to run IIS? Thanks. Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71407
  - 13
    - images loading slow corrupts the report I have a report with an embedded image which appears in every row(static), it also has a report that it drills down to. This page that calls this report uses the reportviewer. the report loads quick, but the images take a while longer. If I hit the column that drills to the next report, I can see the page call the server, but the report stays on the same page. Yet the reportviewer showbackbutton becomes active. If you hit the backbutton on the reportviewer, it errors with Execution 'v0v2zx550yizfieksuf1ya45' cannot be found . How do I get the images quicker? How do I keep the above problem from happening? Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71406
  - 14
    - Deploy Report error? I try to deploy report "rptInfo.rdl" and I receive this error; A connection could not be made to the report server http://localhost/ReportServer. Unable to connect to the remote server (Microsoft.ReportingServices.Designer). What should i do to make this work? Thanks. Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71405
  - 15
    - Best Practices for RS and VSS We are starting to use VSS2005 for storing projects and rdl files. We are mainly using it for the versioning capabilities in VSS. Does anyone have any tips for best practices on how to utilize Visual Studio 2005 and VSS 2005? IF anyone has a link or two to sites that go over this topic that would be helpful too. The problem have had so far is trying to check out the rdl files through VSS and then open them in Visual Sutdio to edit them. Whenever I have checked out a file in VSS and then opened the file using the options in VSS to get to Visual Studio (devenv) I either get a message stating that the carriage return is messd up in the file or it opens the rdl code... not the designer window. If I check out the file in VSS and then open the file through Visual Studio without using VSS to get to Visual Studio, everything works fine, but that just seems a little too manual. Thanks in advacne for your help. Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71404
  - 16
    - 2005 Datepicker control and dateformat Hi, we have an installation of MSSQL reporting services where users can select data based on date ranges. Since upgrading to 2005 we now have a nice new Date picker control alongside textareas which accept MSSQL datetime values. This is all very nice but the date picker automatically formats the date to US format mm/dd/yyyy. We need it to be in dd/mm/yyyy format. I have checked the regional settings of both the browser/ server etc. Scouring the Internet seems to point that this is a post SP2 problem but there seems to be no fix other than making the datefields a type of nvarchar and then converting them to dates in the Stored Procedure. If there really is no fix, how can I just disable this date picker control? In 2000 people just entered the dates manually, this was fine but know there is a date picker control people are obviously going to use it. Thanks Rex Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71403
  - 17
    - Modifying Templates If I create a new template, build reports from it, and then change the template, will the existing reports implement the changes? TIA Dean Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71402
  - 18
    - ReportViewer.PerformBack() Method Not Working Hello, I am using the PERFORMBACK method and am getting the following error: "The operation can only be performed from a drillthrough report". I am specifically running this method in a while loop only if IsDrillThroughReport is true. So, if IsDrillThroughReport is true, which it is, why would I be getting this message? Thanks, Dean Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71401
  - 19
    - color combinations Where can I find some good looking examples of reports and charts that showcase good looking design practices (my efforts leave a lot to be desired:). I can find lots of examples for FrontPage and PowerPoint, anything out there for SSRS? TIA dean Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71400
  - 20
    - Where to install Visual Studio 2005 We currently have Visual Studio installed on the Reporting Services server. Are there any issues with installing VS on another workstation instead? Thanks, Steve Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71396
  - 21
    - Report Viewer Control Drill Through Remote Reports losing its way Hello, After hitting the "back Button" from a drill-through report, it displays the parent report again. Once I click on another drill-through report, I get the following message: "Some parameters or credentials have not been specified". Anyone have any ideas? Thanks, Dean Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71388
  - 22
    - Showing value+percent in pie chart Hi, This may be a silly question, but how do I show both value and percent in a pie chart? Thanks in advance, R. Green Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71387
  - 23
    - How to stop report parameter taking default value I have a SSRS2000 report with three parameters: 1) Company - values from a query including NULL for ALL companies - no default value 2) From date - has default value 3) To date - has default value My problem is that the report runs automatically when launched. Even though there is no default value specified for the Company parameter it takes the NULL value. Is there any way to change this to force the Company prompt to display a <select a value> and allow selection of one of the options? -- Magendo_man Freelance SQL Reporting Services developer Stirling, Scotland Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71384
  - 24
    - How to create installation share for BI Development Studio We have SQL Server 2005 and reporting services on several servers. We want to enable developers to install BI Dev Studio to their desktop machines, and not have to obtain a SS 2005 install CD. We want to create a directory on a share that has the necessary files so they can just install it directly. Is that possible? If so, which directories or files do you copy to the sahre, and from where? Is there a directory with the needed files on the SQL Server 2005 (with reporting Services also installed) server - the one created by running the SQL SErver 2005 installation from the CD? Thanks. Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71383
  - 25
    - Summing data from different years I'm trying to use SRS to recreate a report that is currently in Crystal Reports. This is basically what the report displays: 2004 2005 2006 Customer Category1 $$$$ $$$$ $$$$ Category2 $$$$ $$$$ $$$$ Category3 $$$$ $$$$ $$$$ It basically groups by customer then by Invoice category, then adds up the totals from the invoices in that category for that year. To get the totals, I'm using an expression like this for each year: =SUM(IIF(Year(Fields!DOCDATE.Value) = 2004, Fields!Price.Value, 0)) This works just fine if I only pull data from 2004 but if I pull data between 1/1/2004 and 12/31/2005, The textbox just displays "#Error". It seems that if there is data from more than one year in a category for a customer, I get this error but if the customer for example bought in just 2004 but nothing in 2005 it works fine as well. Should I be doing this a different way? Tag: How to upgrade a ReportServer db from 2000 to 2005? Tag: 71382

Hi,
How to upgrade a ReportServer database 2000 to sql 2005? sql 2000 and sql
2005 are on 2 different servers (boxes).

Thanks

Top

Re: How to upgrade a ReportServer db from 2000 to 2005? by EMartinez

EMartinez
Mon Jul 09 23:16:23 CDT 2007

On Jul 9, 10:57 pm, "newToSql" <none...@hotmail.com> wrote:
> Hi,
> How to upgrade a ReportServer database 2000 to sql 2005? sql 2000 and sql
> 2005 are on 2 different servers (boxes).
>
> Thanks

This link might be helpful.
http://msdn2.microsoft.com/en-us/library/ms143747.aspx

Regards,

Enrique Martinez
Sr. Software Consultant

Top

Re: How to upgrade a ReportServer db from 2000 to 2005? by newToSql

newToSql
Wed Jul 11 12:51:13 CDT 2007

Thanks Enrique.

"EMartinez" <emartinez.pr1@gmail.com> wrote in message
news:1184040983.418437.41550@r34g2000hsd.googlegroups.com...
> On Jul 9, 10:57 pm, "newToSql" <none...@hotmail.com> wrote:
>> Hi,
>> How to upgrade a ReportServer database 2000 to sql 2005? sql 2000 and
>> sql
>> 2005 are on 2 different servers (boxes).
>>
>> Thanks
>
>
> This link might be helpful.
> http://msdn2.microsoft.com/en-us/library/ms143747.aspx
>
> Regards,
>
> Enrique Martinez
> Sr. Software Consultant
>

Top

Re: How to upgrade a ReportServer db from 2000 to 2005? by EMartinez

EMartinez
Wed Jul 11 19:39:57 CDT 2007

On Jul 11, 12:51 pm, "newToSql" <none...@hotmail.com> wrote:
> Thanks Enrique.
>
> "EMartinez" <emartinez....@gmail.com> wrote in message
>
> news:1184040983.418437.41550@r34g2000hsd.googlegroups.com...
>
> > On Jul 9, 10:57 pm, "newToSql" <none...@hotmail.com> wrote:
> >> Hi,
> >> How to upgrade a ReportServer database 2000 to sql 2005? sql 2000 and
> >> sql
> >> 2005 are on 2 different servers (boxes).
>
> >> Thanks
>
> > This link might be helpful.
> >http://msdn2.microsoft.com/en-us/library/ms143747.aspx
>
> > Regards,
>
> > Enrique Martinez
> > Sr. Software Consultant

You're welcome. Let me know if I can be of further assistance.

Regards,

Enrique Martinez
Sr. Software Consultant

Top