reference material

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
    - 5 digit zipcode I am trying to display just the first 5 digits of the zip code. How can I do this? Thanks Tag: reference material Tag: 71502
  - 2
    - Forms authentication ticket timeout How do we change the authentication from timeout to a larger number in report server with forms authentication? thanks! Tag: reference material Tag: 71496
  - 3
    - 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: reference material Tag: 71495
  - 4
    - 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: reference material Tag: 71494
  - 5
    - 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: reference material Tag: 71492
  - 6
    - 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: reference material Tag: 71490
  - 7
    - 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: reference material Tag: 71488
  - 8
    - Specify number of copies to print There has to be a way to do this! Tag: reference material Tag: 71484
  - 9
    - 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: reference material Tag: 71481
  - 10
    - 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: reference material Tag: 71480
  - 11
    - 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: reference material Tag: 71477
  - 12
    - 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: reference material Tag: 71476
  - 13
    - How to convert SSRS2005 report to SSRS2000? The SSRS2000 doesn't work with SSRS2005 rdl files. How could I convert them? Tag: reference material Tag: 71473
  - 14
    - 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: reference material Tag: 71463
  - 15
    - 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: reference material Tag: 71460
  - 16
    - 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: reference material Tag: 71455
  - 17
    - 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: reference material Tag: 71452
  - 18
    - 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: reference material Tag: 71450
  - 19
    - 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: reference material Tag: 71449
  - 20
    - 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: reference material Tag: 71443
  - 21
    - 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: reference material Tag: 71439
  - 22
    - 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: reference material Tag: 71438
  - 23
    - 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: reference material Tag: 71437
  - 24
    - 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: reference material Tag: 71435
  - 25
    - 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: reference material Tag: 71434
- Next
  - 1
    - 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: reference material Tag: 71433
  - 2
    - 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: reference material Tag: 71425
  - 3
    - 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: reference material Tag: 71424
  - 4
    - 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: reference material Tag: 71421
  - 5
    - 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: reference material Tag: 71410
  - 6
    - 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: reference material Tag: 71409
  - 7
    - 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: reference material Tag: 71407
  - 8
    - 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: reference material Tag: 71406
  - 9
    - 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: reference material Tag: 71405
  - 10
    - 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: reference material Tag: 71404
  - 11
    - 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: reference material Tag: 71403
  - 12
    - 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: reference material Tag: 71402
  - 13
    - 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: reference material Tag: 71401
  - 14
    - 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: reference material Tag: 71400
  - 15
    - 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: reference material Tag: 71396
  - 16
    - 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: reference material Tag: 71388
  - 17
    - 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: reference material Tag: 71387
  - 18
    - 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: reference material Tag: 71384
  - 19
    - 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: reference material Tag: 71383
  - 20
    - 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: reference material Tag: 71382
  - 21
    - On different server? HI All, Currently we have two servers in our poduction farm. One runs sharepoint and the other is the database server. Can i install reporting services o nthe sharepoint server and tell it point to the database server? Right now I have it installed the db server, but would like to move it to the other server. Any ideas Thanks! -SJ Tag: reference material Tag: 71381
  - 22
    - Interactive Sorting -prevent group from collapsing is there a way to configure interactive sorting so that a group that has been expanded does not get hidden again when the sort arrow in a column heading is clicked? TIA Dean Tag: reference material Tag: 71377
  - 23
    - Stored Proc for Report Model Hello I was wondering, is it possible to build a Report Model (VSBIDS2005) from a Stored Proc? Kind regards Ricky (SS2005/SSRS2005) Tag: reference material Tag: 71376
  - 24
    - Blank Pages After Sub Reports Hi - I have a report with multiple sub reports. Each sub report is in a separate detail area of a table. When I have a have a sub report that has a lot of data there will be blank space between the sub report and the previous sub report. In this case I have a sub report for employee hours and then a sub report for expenses. Both sub reports are within a table group for project. So for each project the report should list employee hours and then display a section for all the expenses for the project. The problem arises when there are a lot of expenses. Reporting Services will start the expense area on a new page resulting in a half page of white space after the employee section. It appears Reporting Services is attempting to fit each sub report on one page. I have KeepTogether in the table properties set to false and do not have fit to one page checked anywhere in the report or sub reports. I am using Reporting Services for SQL 2000. Has anyone else resolved this issue? From http://www.developmentnow.com/g/115_2006_8_0_23_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com Tag: reference material Tag: 71375
  - 25
    - Report paging problem I'm having a problem with a report i recently built. I use a table with three colums and one issue I have is there is a lot of white space left all over the report because a table group will not span onto the next column. With the exception of one group that is larger than 1 entire column. That one actually fills up one column and then starts agian at the top of the next column. Has any one else ran into this? Also if you know how to potentially fix this let me know. Thanks, Greg Tag: reference material Tag: 71374

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

Top