connection

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
    - Tool Tips for Charts Hi, I am using RS 2005 for charting. However, I am unable to display stats when the users hovers mouse over data points. I know i can display all data points... but graphs becomes very crowded if I do that. Please tell me if I am missing somthing. Thanks, zomer. Tag: connection Tag: 59486
  - 2
    - simple text box question I have a textbox on my group number one. It is the first box from the left. I want the data it outputs to show without it dropping to the next line, but I also dont want to resize my text box to make it fit on one line. My question: Is there a way to make it show up without stretching the box and without part of it dropping to the next line? Tag: connection Tag: 59485
  - 3
    - datediff() alters other values in nested iif i have a nested IIF statement, see below, that evaluates all possible field values of a particular field, and outputs appropriate text. The possible field values for Fields!STYLESEASON, are "FLASH","BASIC" and text consisting of year and month in "yymm" format. e.g. "0604" I convert the last possible value type to date by concatenation: CDATE("01/"+Right(RTrim(Fields!STYLESEASON.Value),2)+"/"+Left(RTrim(Fields!STYLESEASON.Value),2))) The report works fine like this , but once I introduce the DATEDIFF(), DATEDIFF("m",Fields!START_DATE.Value,CDate("01/"+Right(RTrim(Fields!STYLESEASON.Value),2)+"/"+Left(RTrim(Fields!STYLESEASON.Value),2))) all instances of Fields!STYLESEASON.Value are evaluated by CDATE() generating a invalid date function. In other words, instead of the values "FLASH" & "BASIC" being matched in the prior IIF conditions leaving only suitable values that can be converted to a date format, they too are subjected to CDATE(). You can clearly see this in the error below as "BASIC" is converted to "01/IC/BA" complete IIF expression: =IIF(UCASE(RTRIM(Fields!STYLESEASON.Value))= "FLASH","OLD",IIF(UCASE(RTRIM(Fields!STYLESEASON.Value))="BASIC","BASIC",IIF(DATEDIFF("m",Fields!START_DATE.Value,CDate("01/"+Right(RTrim(Fields!STYLESEASON.Value),2)+"/"+Left(RTrim(Fields!STYLESEASON.Value),2))) < -2,"OLD","FASHION"))) error generated when DATEDIFF() is introduced: Warning 1 [rsRuntimeErrorInExpression] The Value expression for the textbox â??textbox25â?? contains an error: Conversion from string "01/IC/BA" to type 'Date' is not valid. thanks for you help in advance. anthony Tag: connection Tag: 59483
  - 4
    - "cannot decrypt the symmetric key" I was wondering if anyone has any ideas on this error I am seeing on the Reporting Services server. The server has been working fine for several months and now we get these errors. When I go to the Report Manager http://servername/Reports/pages/folder.aspx I get the following error: "Response is not well-formed XML" When I goto the Report Server http://servername/ReportServer I get the following error: "The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content." I have done some searching and I have found that it is possible that my ASPNet account has had its password changed which could cause the above errors. But I am not sure if this would be the issue. Any thoughts out there? Thanks Rob Tag: connection Tag: 59481
  - 5
    - RS2005 configuration problem ASPNET account and DBs Hi all, I have instaled SQL Server 2005 on my W2K SP4 machine. When I go to RS configuration I get problems in two areas. First under "Web Service Identity" no account is listed. ASPNET account is set up on my machine correctly. Second, under "Database Setup" I can't set up dbs. When I click "New" and create ReportServer db and then click "Apply" I get an error that says something like "Virtual Directories have to be crated first." Under IIS I have ReportServer and Reports directories. What may be the problem? Thanks, Stan Tag: connection Tag: 59478
  - 6
    - Mail Configuration question I have created a subscription to send a mail...and I get a link for the report as below.... http://ServerName/reportserver?%...... But the name is not getting resolved and my Admin says I need to use the full qualified domain name(fqdn), Please let me know where I have to make change in reporting services so the email link I get will have the fqdn of the server like below instead of just the servername... http://ServerName.xyz.com/reportserver?%...... Thanks. Tag: connection Tag: 59477
  - 7
    - SSRS 2005 on NLB hi all, i just install SSRS2005 on MS NLB with Application cluster. when trying to edit subescription not from the node that i created the subsecription i am getting an error. my main Q is SSRS can be hoste on NLB ? i am not sure it is clear from the following MS articale http://msdn2.microsoft.com/en-us/library/ms157293.aspx thanks -Moshe Tag: connection Tag: 59475
  - 8
    - Email Subscription to Exchange Distribution List? Hi All, Being sort of new to Reporting Services, I'm up against a solution I need to provide and not sure how to attack it: With email subscriptions, is it possible to set the "To:" value to honor a MS Exchange distribution list? We need to send a report to 100-200 users. I'm not sure if the "To:" field can handle such a large list of email addresses (and that would be a nightmare to maintain anyway). Further, using a data-driven approach and a query would allow easier maintenance of the email address list as I see it. But truly, being able to use an existing MS Exchange distribution list would be the best if it's possible. Also - is there a way "outside of" the standard and data-driven methods of executing a report subscription to be emailed (i.e., based on a trigger)? Has anyone done something like this before? Please let me know - any ideas are greatly appreciated... Thank in advance! - Fred Tag: connection Tag: 59474
  - 9
    - Pre Printed Forms in Reporting Services 2005 Hello I have a requirement that I want to use reporting service for --- but I can't seem to get it to work. I've researched this all weekend with no luck. I'm trying to use reporting services 2005 to print content into pre printed forms. The building of the report is very simple --- the problem is placing the fields correctly in the designer. The approach that I'm using is a 5 step process as follows: 1) Scan an image of the form to a gif; 2) Add it in the designer in an image control; 3) Send the image control to the back; 4) Place text controls where the data is to be printed; and 5) Remove the image from the designer before publishing. What I'm experiencing is the image IS NOT being rendered as the original size within the designer so the printing doesn't match the physical forms. No matter what I've tried, I can't solve this issue. Do you know of a solution and/or could you forward to someone that can help me out? Thanks in advance. Clay Seifert Tag: connection Tag: 59471
  - 10
    - Creating Dynamic MDX Queries within SQL Server 2005 Reporting Services Please I need some help urgently, How can I create Dynamic MDX Queries within SQL Server 2005 Reporting Services to use Parameters created from SQL Queries Dataset. I was able to do this in SQL Server 2000 Reporting Services by replacing MDX Statement (1) with (2) below, but I notice the symbol =" at the begining of statement (2) is not allowed. (1) SELECT NON EMPTY { [Measures].[Expected Gross Ult Premium], [Measures].[Expected Ultimate Deductions Pct], [Measures].[IELR Pct], [Measures].[Expected Composite Ratio Pct], [Measures].[Booked Premium], [Measures].[Booked Deduction Pct], [Measures].[Booked Paid Loss Pct], [Measures].[Booked Incurred Loss Pct], [Measures].[Booked Composite Pct], [Measures].[Expected NPV], [Measures].[Expected NPV Pct], [Measures].[Expected ROE], [Measures].[Allocated Capital], [Measures].[Booked Tech Margin Inc Cat] } ON COLUMNS , NON EMPTY { DESCENDANTS( [Underwriting Year].[Underwriting Year].[All Underwriting Years], [Underwriting Year].[Underwriting Year].[Underwriting Year] ) } ON ROWS FROM [GroupReporting] WHERE ( [Transaction Original Currency].[Currency].&[85], [Lifetime Contract].[Lifetime Contract].[Originating Contract Reference].&[C12664] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, ACTION_TYPE (2) ="SELECT NON EMPTY { [Measures].[Expected Gross Ult Premium], [Measures].[Expected Ultimate Deductions Pct], [Measures].[IELR Pct], [Measures].[Expected Composite Ratio Pct], [Measures].[Booked Premium], [Measures].[Booked Deduction Pct], [Measures].[Booked Paid Loss Pct], [Measures].[Booked Incurred Loss Pct], [Measures].[Booked Composite Pct], [Measures].[Expected NPV], [Measures].[Expected NPV Pct], [Measures].[Expected ROE], [Measures].[Allocated Capital], [Measures].[Booked Tech Margin Inc Cat] } ON COLUMNS , NON EMPTY { DESCENDANTS( [Underwriting Year].[Underwriting Year].[All Underwriting Years], [Underwriting Year].[Underwriting Year].[Underwriting Year] ) } ON ROWS FROM [GroupReporting] WHERE ( [Transaction Original Currency].[Currency].&[" & Parameters!CurrencyCode.Value & "], [Lifetime Contract].[Lifetime Contract].[Originating Contract Reference].&[" & Parameters!MISOriginatingContractID.Value & "] ) CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, FORMAT_STRING" Tag: connection Tag: 59470
  - 11
    - Default Font Is there a way when designing reports using Visual studios to have the default font be something other than arial. Currently when I plop down an item it defaults to ariel 10 pt and I would like to default to Verdana 8pt. I'm not sure if this is a visual studios area or reporting services since i am editing a report. Thanks Tag: connection Tag: 59469
  - 12
    - Licensing Okay, I do need some help. I'm setting up a SQL 2005 Std for Reporting puposes, mainly. Approx. 1 or 2 developers will create the reports on the server using the BI Developers Studio. Approx. 5 users will create new reports using the Report Builder tool. Approx. 30 people will receive reports in their email from the subscription service in RS. Some reports will be used in a website as HTML Archives. What kind of licenses (and how many) do I need for a scenario like this. Any help is appreciated. McWawa Denmark Tag: connection Tag: 59463
  - 13
    - Report Server - Access Error Any help appreciated.... Installed Reporting Services on Win2003 machine with a SQL2000 db. Reporting Services was installed with an IIS without default website, running IIS5.0 Isolation mode. When navigating to http://<hostheader>/reports I get the folllowing error... The report server is not responding. Verify that the report server is running and can be accessed from this computer. When navigating to http://<hostheader>/ReportServer, the following error occurs.... The report server is not responding. Verify that the report server is running and can be accessed from this computer. I have ensure the account running reports is included in the group running the webservices. Also made the change to utilise <ReportServerURL> to the http://<hostheader>/ReportServer. Any assistance appreciated.... James Tag: connection Tag: 59461
  - 14
    - credentials I am using RS2000. I have created some reports and publish to the server. A folder has been created at /home/test1 in report manger and granted the access right to user A. I created a .net application with impersonation = false, how can I call the reports under test1 inside this application by using the RS2000 control? what I mean is how to pass the A's credential to reporting services so that I can access the report. Can anyone give me some suggestion? Thanks a lot! Tag: connection Tag: 59456
  - 15
    - ReportViewer Security Issues I am attempting to use the Reporting Services web service to get a report list and then select a report to render in my windows app using the ReportViewer control. I am able to connect the web service and request the file list using domain credentials by specifying them like this: rService.Credentials = new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text); But when I try to render the actual report, I get "access denied for user null. Not associated with a trusted windows account". I am specifying my reportviewer credentials like this: reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text); Why does the web service call authenticate but the reportviewer call not? Each user needs to be associated with a windows account when running the reports, but they will sometimes be running the windows app over the www. Glenn Thimmes Tag: connection Tag: 59454
  - 16
    - ReportExecutionService, Email and Embedded Images Hi I am experimenting with the ReportExecutionService, and trying to send an HTML mail message with the output from a report. I've succesfully been able to mail the report, but (even if they are embedded) images do not display in the mail message. I am using System.Net.Mail to send the message. I suspect the error lies in the fact that that image is still being refered to using it's host URL ... <IMG class="r1" SRC="http://localhost/ReportServer?%2fMY+reports%2fTestReport&rs%3aFormat=HTML4.0&rs%3aImageID=a3b75c24-e3cc-48f4-b6cc-62c80d437f27"/> Does anyone know of how to fix this or a different method of initiating the mailing of a report on demand (and with custom parameters if the report requires them). Many thanks Tag: connection Tag: 59453
  - 17
    - Reporting Services integration into Windows app My company is currently looking at requirements for integrating Reporting Services into our application, and there are several questions we have regarding how this will be possible in our deployment scenario. Our application is a Windows SmartClient app that is to be deployable within an office intranet or over the www for home users. Our application talks to a web service that is secured using SSL and user credentials. We would like for users to be able to view Reporting Services reports from within the application, but we need to be able to provide report security depending on who the current user is. The problem is that when accessing reports over the web, we need to still provide security. I've looked at a couple of possibilities for solving this problem and have not been able to conclude which option would work for my scenario. #1 I considered the options of passing all requests for reports through the web service, have it do the request, and pass the html back to the client. The problem with this is that many or our reports have multiple pages and will require addition post backs that would then have to be funneled through the web service. This seems messy and problematic. #2 Using the reporting services web service to request reports. Would this actually solve the security problem? Can I provide credentials to the web service that can be used for enforcing report level security? In this case, how would the next page button work for reports with multiple pages? #3 Using the ReportViewer component with LocalReport. Since we want our end users to be able to make their own custom reports for use within our system, this option would require interrogating the report for the sql that is used for each dataset, providing the parameters, performing the queries and then supplying the dataset to the report. Is this correct? Which of these three options would be best for our scenario? Any advice would be most welcome in helping us get on our way with this project. Glenn Thimmes Tag: connection Tag: 59452
  - 18
    - Subreport in table Hi to all! I create a report (used aftrer as subreport) where 200 record are displayed in a table. Looking alone via reportserver the report is right paged. I put this report in a master report as subreport and the pagination still work. If in the master report I use a table and in a cell I put the subreport the pagination doesn't work. So, why in a cell of a table the pagination of subreport doesn't work? How i can make a two level group (ex: date, type) to show my record without using subreports? Thanks Bye Kalman Tag: connection Tag: 59450
  - 19
    - Problem with Data Driven Subscription I have a Data Driven Subscription report using Reporting Services Enterprise 2000 that has been running just fine for several months. Last week, however, it did not run correctly. I checked the initial query where we get the list of all the emails the report will go to and one other parameter we need to run the main query and found that that initial query was all garbled. Part of the select clause was in the where clause (i.e., there where 2 FROM statements in the WHERE clause). I clicked on verify and the code would not verify. I closed Reporting Services and re-opened it and the query was back to where it should be. I tested it and it ran fine. Has this happened to anyone else? Is there anyway for me to stay on top of this? We sent out wrong emails to 140 users last week and we want to make sure that does not happen again. One more question. Does our backups of SQL Server also back up all of the subscriptions and reports in Reporting Services, or do I need to set something else up for that? Thanks.. Tag: connection Tag: 59449
  - 20
    - Help with charts Hi all, i'm trying to replicate some functionality I have seen in crystal reports 10, Im hoping it is also possible in SSRS (2005). Any help or pointers would be appreciated, im stuck! Basically I want to create a basic bar chart from a dateset. If one of the bars are clicked, I would like to re-render the chart with data specific to that bar (this involves performing some further grouping and sorting on the dataset). This framework needs to be repeated to 5 levels. Now, I know i can create a hidden report parameter (or a set of them) and then when the bar is clicked, send this information back to the report and rerun the report, but this takes time, especially if they are going 5 levels deep. Is there a better way? I would like to have a set of charts on my report and hide/unhide them as needed but pas the parameters between them when the bars aare clicked, I cant figure out how todo this though. Please help, any advice appreciated! Kind Regards Taz Tag: connection Tag: 59446
  - 21
    - Char Length Limit URL - Workarround? Hi there, I'm building reports for crm3.0. I try to create a report navigation on report items. When I try to pass MVP through a report the length of the report url spreads often the 2048 char limit of the internet explorer. Is there a workarround? Thanks in advance for any ideas! Tag: connection Tag: 59445
  - 22
    - Report Parameters Date keeps defaulting to MM/DD/YYYY I've added a date parameter to a reporting services (2000) report, I have created a table with the dates in the format YYYY/MM/DD I created a dataset for these dates (select dates from HDdates) but on viewing it in the dataset it changes it to dd/mm/yyyy which would still be ok, but going to the preview it is shown in the dropdown box in american format (mm/dd/yyyy). Has anyone had this problem and solved it, thanks for any help Sammy Tag: connection Tag: 59444
  - 23
    - Multiple-resultset stored procedures Hi, Is it possible to use multiple-resultset stored procedures with Reporting Services 2005? I use SS2005, SP1. Thanks in advance Nikola Milic Tag: connection Tag: 59442
  - 24
    - drilldown problem hi, i have a problem with the drilldown functionality of my report: in the preview pane in VS2005 everything works fine but when I try to execute the report on reportserver the only thing I see is the top level and I'm not able to drilldown into lower levels ... anyone has an idea? I did not implement the drilldown in mdx statement but used grouping & toggle item in VS2005. could that be the reason? thanks, rhapsy Tag: connection Tag: 59439
  - 25
    - Reports and Division with denominator 0 Hi, I'd like to design a report with a calculated measure (a division where I want to exclude every denominator equal to 0). How can I do that. In Analysis Services I use the case when statement --> what is the equivalent in Reporting Services? ------------------------------------------------------- If I calculate my division as a measure in Analysis Services how can I make this matrix work? Time Drill down (Hierachie) Measure (calculated in Analysis Serevices) How can I get the correct result in every drill down level? Thanks!! Tag: connection Tag: 59437
- Next
  - 1
    - Reports in an application I have VS2003, I can create reports but am not sure how to run them in a stand alone fashion ie someone just goes to a URL instead of having to use a reporting server to display the reports. Does any one know how to do this, thanks for any help Sammy. Tag: connection Tag: 59431
  - 2
    - Web Service URL When adding the webservice http://localhost/ReportServer$SQL2005D_1/ReportExecution2005.asmx to my asp.net application it seems that i can never change it. Even though the following key <add key="ReportExecution2005.ReportExecution2005" value="http://localhost/ReportServer$SQL2005D_1/ReportExecution2005.asmx" /> is added to the web.config file when I cange this to a production server i get a Bad Request 400 i.e. URL does not exist. How do you dynamically change the web service URL in an asp.net 2.0 appliaction. If i use a classy library it creates a confiuration settings section and put the url in there and I can change it and the it works. But it does not work when the web service is declared inside a web application and the seeting is under appsettings in the web.config. Any Ideas Thanks Toby. Tag: connection Tag: 59430
  - 3
    - Report Viewer showing content type instead of rendering the report i have encountered the following problem: i have a web page with an iframe which shows the reportviewer's rendering of the rerport according to the user's input in the other parts of the window. each time the user clicks submit, we submit the data to the iframe. sometimes instead of showing the report, we get the content type and the report fails to display. this happens sporatically. it appears as if the report viewer doesnt send the correct http headers and the browser shows these instead of the report showing in the viwer. any ideas??? thanks, Gal Granov Eyeblaster.com gal.granov@eyeblaster.com Tag: connection Tag: 59429
  - 4
    - export to excel from a report Hi, I would like to have a button on my report to export it to excel (instead of having to choose the format from the toolbar and then press "export"). Is there a way to do it? I know that there is a parameter that I can add to the url for this but i don't know exactly how to add it to the current url from my report). Thanks From http://www.developmentnow.com/g/115_0_0_0_0_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com Tag: connection Tag: 59428
  - 5
    - button to export to excel Hi, I would like to have a button on my report to export it to excel (instead of having to choose the format from the toolbar and then press "export"). Is there a way to do it? I know that there is a parameter that I can add to the url for this but i don't know exactly how to add it to the current url from my report). Thanks. Tag: connection Tag: 59427
  - 6
    - I found a tickets site I found a tickets site http://allticket.yourfreewebspace.com/ we can find and buy all tickets,fun! Tag: connection Tag: 59426
  - 7
    - I found a tickets site I found a tickets site http://allticket.yourfreewebspace.com/ we can find and buy all tickets,fun! Tag: connection Tag: 59425
  - 8
    - Exporting to CSV corrupted while no data returned Hi, I'm exporting my data to CSV and Excel. When my query return data to the RDL all works fine. The problem begins when the query return an empty result set. The excel works fine, but the CSV file is corrupted (looks like a chinese). Thanks Tag: connection Tag: 59424
  - 9
    - Possible to embed a list in a table text box? When a sub report is embedded in a text box in a table there is a problem when the report is exported to Excel - the sub report will not render in Excel. Is it possible to instead embed a list in a table text box, and if so will it render properly when exported to Excel? Bill Tag: connection Tag: 59423
  - 10
    - multivalued parameters Hi All, Consider my case... I have 3 cascaded multivalued parameters in a report... when I unchack any value from first parameter the cascaded values comes in rest 2 parameters with select all ... the problem is this when I chack any new value from first parameter rest 2 parameters does't show "select all".... Any Reply would be highly appriciated..... Kunj Tag: connection Tag: 59422
  - 11
    - Database Mail I read some articles about the new feature "Database Mail" in SQL 2005 and ite tremendous features. http://msdn2.microsoft.com/en-us/library/ms175887.aspx But I was concerned about encrypting email messages and signing them with digital signatures. But I don't know whether these options are supported or not? If they are supported could you please guide me how to do this? Thanks for your help Rami Tag: connection Tag: 59421
  - 12
    - Installation Path Hi, I need to create an installer to install a custom data processing extension. How can I get detailed information about SQL Server Registry settings so that I can get Reporting Services Installation path? I need this information for both SQL Server 2000 and 2005. Thanks in advance. -- Frederic Latour http://www.enesyssoftware.com http://www.enesys.fr Tag: connection Tag: 59419
  - 13
    - Pivot table to matrix (best workaround) I've got a matrix that generates 25 dynamic columns (Department). The columns are projects that a (Department) has hours assigned to, so the rows can vary greatly. I've found that I can't have more than one total row with custom logic, so I'd like to place a static table directly below the matrix, but I'm not sure the best way for it to matchup with the data above it. Is there a way I can reference data from a matrix? I'm trying to get get the delta of hours budgeted from hours assigned to a project. These are two seperate queries, but I need to find the difference between the two numbers. Also, can I filter at the textbox level? Each column needs to have a different filter applied to it. Tag: connection Tag: 59418
  - 14
    - Designer changing report element sizes during a save This is a repost using MSDN Subscription Using SQL Server Reporting Services Designer Version 9.00.1399.00 I'm having trouble with a three column report with a page header the width of the page. The designer is changing the width of elements when it is saved. As long as you view the report in the designer, the report renders as you would expect, but when it gets saved, some of the report elements get changed. Try this: New empty Report Server Project Add new empty report (Add -> New Item -> Select Report) No datasource Enable page header Add a text box (textbox1) to page header. Make it begin at the left margin/top margin and be almost the width of the page (6in). Set the height of the page header to the height of the textbox1. Insert five or six words in textbox1. Make the report a 3 column report. Reset the page header width to be 6.5in (1in right/left margins on 8.5in paper) using the resizer in the page header. The column width should be 1.83333in (1.83333 * 3 = 5.49999 + [column spacing] 0.5in + 0.5in = 6.49999in) Add a text box (textbox2) to the body (in column 1). Make it begin at the left margin/top margin and be almost the width of the column (1.625in). Insert a few words in textbox2. View the report. Appears to be fine. Save, Close the report, Reopen the report. The width of the page header is now 6in (was 6.5in), column width is now 1.66667in (was 1.83333in) Why did the width of the page header change? Make the width of the page header and textbox1, 6.5in. Save, Close the report, Reopen the report. The page header is 6.499999in wide, but textbox1 is the same width as one of the columns in the body (1.83333in) Why did the width of the page header and textbox1 change? Make textbox1 6in wide again. Make the report 6.5in wide. Add a new textbox (textbox3) in the page header to the right of textbox1 (starts at 6in, 0.5in wide), same height as the first one. Insert a few letters in textbox3. Save, Close the report, Reopen the report. The report is now 6in wide (instead of 6.5in), columns are 1.66667in wide. Textbox3 that was just added to the page header cannot be seen. It is at the right edge of the page header, and has a negative width. It can only be found using dropdown in the properties window. Why did textbox3 disappear/get a negative width? Are these known bugs? Are there any work arounds? Tag: connection Tag: 59416
  - 15
    - Clickable charts/graphs? Hi all, in Crystal reports it is possible to create a chart that you can click on (i.e. specific bars within the chart) which then lead to a different section of the report. Is this possible with SSRS? Thanks Taz Tag: connection Tag: 59413
  - 16
    - Upgrading database from RS 2000 to 2005, getting error Hello- When trying to upgrade a RS database from 2000 to 2005 (by hitting the upgrade button or when prompted to upgrade) I keep getting this error: "Creating upgrade script for database version C.0.0.40 Couldn't generate the upgrade script. There is no upgrade script available for this database version." So then I tried to create a new database, but again I was prompted to upgrade the database and I received the same error. I also saved the generated script, tried to run it, and I received a whole lot of 'column/index/table already exists' errors. I have seen in another newsgroup that someone else has received the same error, but had not gotten an answer back yet. thank you for any help! Johnny Armstrong Tag: connection Tag: 59412
  - 17
    - Parameter Drop Down- Type Along Selection - RS 2005 Posted this a while back and didnt get any response. trying again. basically my combo has like 50 product names in a drop down (populated from a stored procedure query) and i would like the user to type along the product to narrow down or select the product..rather than scrolling down with the mouse all the time to select the wanted one. I have crazy keyboarders/mouse haters here, they want this badly. I cant do this at the moment of what is available from SRSS 2005. Is there a way to replace this combo with the smarter combo available in .NET.? or any other workarounds? HELP!~ Cheers~ Ananth Krishna Tag: connection Tag: 59406
  - 18
    - Supressing Headers when exporting as CSV Hi, I am creating a report that will contain data that is going to be imported into an accounts system. I need the report to be a text file, so i export it as a csv. When i do this i keep getting the name of text box at the top of the report, as a sort of colum header. I dont want these in the file so is there any where i can supress it. I'm using SQL 2000 reporting services. Cheers Tag: connection Tag: 59404
  - 19
    - ReportViewe needs a connection? Doesn't make sense... Hi, I have a VB .NET 2.0 WinForms application that needs to display reports on a winform's ReportViewer control. The application project and a separate reports project are under the same solution. The report project has its own global connection and datasource object that is used by the report. I test the report inside the Visual Studio developing environment report's view mode and it works ok. Then I open the form that has the ReportViewer control (in the application project), and in the designer, I assign the properties and the report to the ReportViewer control. I run the application... the form displays, and the ReportViewer displays an error inside saying there's no dataset. Why? The report has a connection and a dataset and they work when I test it. So I create a connection and dataset in the application's project like the ones I have in the report project, but I can't find a way to assign the dataset to the ReportViewer... How can I make this work? Would you please Help me? This is the tip of the iceberg of all the problems we're having with our reports and RSvcs.... Thanks in advance. Sincerely, Richard Tag: connection Tag: 59403
  - 20
    - passing multiple parameters to subreport Hello Group, Is it possible to pass multiple parameters down to a subreport? If so how? I am using this code in the report to show the contents of the parameters on the top of the report. Function ParameterList(ByVal Parameter As Object) As String Dim sParamItem As Object Dim sParamVal As String = "" For Each sParamItem In Parameter If sParamItem Is Nothing Then Exit For sParamVal &= sParamItem & ", " Next '-- Remove last comma & space: Return sParamVal.SubString(0, sParamVal.Length - 2) End Function Therefore I was expecting to use this to pass it through like this: Code.Parameterlist(Parameters!Division.Value) But that doesnt work unfortunately. Does anybody know an approach that works..... Thanx Perry Tag: connection Tag: 59399
  - 21
    - Setup Error: A connection could not be made to the report server Reporting services is working, but i can't deploy... I get this additional information: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (microsoft.reportservices.designer) << OK >> I am new to reporting server and have only (very) limited IIS experience. I went thru RS tutorial all the way thru creating a basic report. Then tried to deploy...when i get the above message. Then I installed IIS on to Windows 2003 Server (Standard) to enable Rerporting Services web reporting. I realized after the fact that i should have installed IIS before reporting services. I deinstalled SQL2005 and reinstalled. I connected to my tutorial project and attempted to deploy and get the same error. Can anyone point the way out? Thanks! -- The Spirit gives life; the flesh counts for nothing! (Jn 6:63) Tag: connection Tag: 59398
  - 22
    - Automatically setup table from dataset I need to add tables to an existing "report" from datasets that have 50+ columns. Each table is a different dataset. Is there anyway to replicte the behiour of the wizard on an existing report? Adding columns one at a time is a pain, it'd be easier for me to add them all and then remove the few I don't need. And yes I know that db tables that wide and reports with this much info are somewhat useless but I'm forced to swim in the pond I'm in. Tag: connection Tag: 59397
  - 23
    - Newbie - Report Design help. Hi folks, New to RS, but have this really annoying colleague b*tching about coversheets and TPS reports. (Sorry, off-topic). Anyways, I've been ranting about the wonders of SQL RS to him, and then he turns up wanting me to actually do a real report for him. In the sample below, I'm using the Northwind database. Basic idea is: You select a year in a combobox and run the report. The report then shows the quanties sold for each product for that year in one column, and in the next column it shows the equivalent data for the previous year. Tables used in this sample: Orders, OrderDetails and Products. Hope someone can help me. :-) -McWawa, the next President of The United States of America. -------------------------------------------------------- Select Year: 1999 | 2000 | 2001 | <- these are in a combobox 2002 | 2003 | Products | 2001* | 2000** ----------------------------------------- Produkt A | 145 | 84 Produkt B | 200 | 129 Produkt C | 101 | 88 .. | ... | ... .. | ... | ... Produkt Z | 140 | 31 * = The Year selected in the combobox ** = The Year BEFORE the on selected in the combobox -------------------------------------------------------- Tag: connection Tag: 59396
  - 24
    - Averages in Matrix report Greetings, I have a report that works just great: Jan Feb Mar Apr Facility1 80 78 65 90 Facility2 85 79 90 49 It tells you a calculated score for each facility for each month. It's exactly what they asked for. Until I showed it to them. Now they want more info. So I added another row to sort by - Region Jan Feb Mar region1 facility1 80 78 65 facility2 85 79 90 region2 facility3 81 65 82 facility4 84 90 71 And that works great. The problem is, they want a YTD col, and these are scores. I can't just add them up, I have to either average them, or calc a YTD score for each facility and put it out to the right after the last months column. Jan Feb Mar YTD region1 facility1 80 78 65 74.33 facility2 85 79 90 84.66 region2 facility3 81 65 82 76 facility4 84 90 71 81.66 The second problem is, I'd like to be able to see an average for Regions. Is it possible? Jan Feb Mar YTD region1 facility1 80 78 65 74.33 facility2 85 79 90 84.66 region average 82.5 78.5 77.5 79.49 region2 facility3 81 65 82 76 facility4 84 90 71 81.66 region average 82.5 77.5 76.5 78.83 here's my RDL. <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <RightMargin>1in</RightMargin> <Body> <ReportItems> <Textbox Name="textbox1"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Times New Roman</FontFamily> <BackgroundColor>Brown</BackgroundColor> <BorderWidth> <Bottom>3pt</Bottom> </BorderWidth> <BorderColor> <Bottom>Black</Bottom> </BorderColor> <BorderStyle> <Bottom>Solid</Bottom> </BorderStyle> <FontSize>18pt</FontSize> <TextAlign>Center</TextAlign> <Color>White</Color> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>1</ZIndex> <rd:DefaultName>textbox1</rd:DefaultName> <Height>0.33in</Height> <Width>5in</Width> <CanGrow>true</CanGrow> <Value>Monthly Scorecard</Value> </Textbox> <Matrix Name="matrix1"> <Corner> <ReportItems> <Textbox Name="textbox3"> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>8</ZIndex> <rd:DefaultName>textbox3</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </Corner> <Style /> <MatrixRows> <MatrixRow> <MatrixCells> <MatrixCell> <ReportItems> <Textbox Name="textbox2"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>N0</Format> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>9pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <ZIndex>2</ZIndex> <rd:DefaultName>textbox2</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=(Sum(Fields!MonthTotal.Value) & " % ")</Value> </Textbox> </ReportItems> </MatrixCell> </MatrixCells> <Height>0.24in</Height> </MatrixRow> <MatrixRow> <MatrixCells> <MatrixCell> <ReportItems> <Textbox Name="textbox9"> <Style> <PaddingLeft>2pt</PaddingLeft> <Format>N0</Format> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>9pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> </Style> <rd:DefaultName>textbox9</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Sum(Fields!month.Value)</Value> </Textbox> </ReportItems> </MatrixCell> </MatrixCells> <Height>0.24in</Height> </MatrixRow> </MatrixRows> <MatrixColumns> <MatrixColumn> <Width>0.96875in</Width> </MatrixColumn> </MatrixColumns> <DataSetName>Cypress_APP</DataSetName> <ColumnGroupings> <ColumnGrouping> <DynamicColumns> <Grouping Name="matrix1_month"> <GroupExpressions> <GroupExpression>=Fields!month.Value</GroupExpression> </GroupExpressions> </Grouping> <Sorting> <SortBy> <SortExpression>=Fields!month.Value</SortExpression> <Direction>Ascending</Direction> </SortBy> </Sorting> <ReportItems> <Textbox Name="month"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Times New Roman</FontFamily> <BackgroundColor>=iif(RunningValue(Fields!PortfolioName.Value & Fields!name.Value, Countdistinct, Nothing) mod 2, "LightBlue", "White")</BackgroundColor> <FontSize>9pt</FontSize> <TextAlign>Center</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>7</ZIndex> <rd:DefaultName>month</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=choose(Fields!month.Value, "Jan Score", "Feb Score", "Mar Score", "Apr Score", "May Score", "Jun Score", "July Score", "Aug Score", "Sept Score", "Oct Score", "Nov Score", "Dec Score" )</Value> </Textbox> </ReportItems> </DynamicColumns> <Height>0.24in</Height> </ColumnGrouping> </ColumnGroupings> <Width>4.90625in</Width> <Top>0.33in</Top> <RowGroupings> <RowGrouping> <DynamicRows> <Grouping Name="matrix1_RowGroup2"> <GroupExpressions> <GroupExpression>=Fields!PortfolioName.Value</GroupExpression> </GroupExpressions> </Grouping> <ReportItems> <Textbox Name="textbox5"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Times New Roman</FontFamily> <BackgroundColor>=iif(RunningValue(Fields!PortfolioName.Value & Fields!name.Value, Countdistinct, Nothing) mod 2, "LightBlue", "White")</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>9pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>6</ZIndex> <rd:DefaultName>textbox5</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Fields!PortfolioName.Value</Value> </Textbox> </ReportItems> </DynamicRows> <Width>0.875in</Width> </RowGrouping> <RowGrouping> <DynamicRows> <Grouping Name="matrix1_RowGroup3"> <GroupExpressions> <GroupExpression>=Fields!name.Value</GroupExpression> </GroupExpressions> </Grouping> <ReportItems> <Textbox Name="textbox4"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Times New Roman</FontFamily> <BackgroundColor>=iif(RunningValue(Fields!PortfolioName.Value & Fields!name.Value, Countdistinct, Nothing) mod 2, "LightBlue", "White")</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>9pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>5</ZIndex> <rd:DefaultName>textbox4</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=Fields!name.Value</Value> </Textbox> </ReportItems> </DynamicRows> <Width>3in</Width> </RowGrouping> <RowGrouping> <DynamicRows> <Grouping Name="RowColor"> <GroupExpressions> <GroupExpression>=1</GroupExpression> </GroupExpressions> </Grouping> <ReportItems> <Textbox Name="textbox6"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Times New Roman</FontFamily> <BackgroundColor>=iif(RunningValue(Fields!PortfolioName.Value & Fields!name.Value, Countdistinct, Nothing) mod 2, "LightBlue", "White")</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>9pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>4</ZIndex> <rd:DefaultName>textbox6</rd:DefaultName> <CanGrow>true</CanGrow> <Value>=RunningValue(Fields!PortfolioName.Value & Fields!name.Value, Countdistinct, Nothing)</Value> </Textbox> </ReportItems> </DynamicRows> <Width>0.03125in</Width> </RowGrouping> <RowGrouping> <Width>0.03125in</Width> <StaticRows> <StaticRow> <ReportItems> <Textbox Name="textbox7"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Times New Roman</FontFamily> <BackgroundColor>=iif(RunningValue(Fields!PortfolioName.Value & Fields!name.Value, Countdistinct, Nothing) mod 2, "LightBlue", "White")</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>9pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>3</ZIndex> <rd:DefaultName>textbox7</rd:DefaultName> <CanGrow>true</CanGrow> <Value>Month Total</Value> </Textbox> </ReportItems> </StaticRow> <StaticRow> <ReportItems> <Textbox Name="textbox8"> <Style> <PaddingLeft>2pt</PaddingLeft> <FontFamily>Times New Roman</FontFamily> <BackgroundColor>=iif(RunningValue(Fields!PortfolioName.Value & Fields!name.Value, Countdistinct, Nothing) mod 2, "LightBlue", "White")</BackgroundColor> <BorderStyle> <Default>Solid</Default> </BorderStyle> <FontSize>9pt</FontSize> <TextAlign>Right</TextAlign> <PaddingBottom>2pt</PaddingBottom> <PaddingTop>2pt</PaddingTop> <PaddingRight>2pt</PaddingRight> <FontWeight>700</FontWeight> </Style> <ZIndex>1</ZIndex> <rd:DefaultName>textbox8</rd:DefaultName> <CanGrow>true</CanGrow> <Value /> </Textbox> </ReportItems> </StaticRow> </StaticRows> </RowGrouping> </RowGroupings> </Matrix> </ReportItems> <Style /> <Height>1.05in</Height> </Body> <TopMargin>1in</TopMargin> <DataSources> <DataSource Name="Cypress_APP"> <rd:DataSourceID>ed3b9625-deb2-4de7-b3be-35b5117506fa</rd:DataSourceID> <DataSourceReference>Cypress_APP</DataSourceReference> </DataSource> </DataSources> <Width>7.375in</Width> <DataSets> <DataSet Name="Cypress_APP"> <Fields> <Field Name="name"> <DataField>Name</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="PortfolioName"> <DataField>PortfolioName</DataField> <rd:TypeName>System.String</rd:TypeName> </Field> <Field Name="month"> <DataField>Month</DataField> <rd:TypeName>System.Int16</rd:TypeName> </Field> <Field Name="measureID"> <DataField>MeasureID</DataField> <rd:TypeName>System.Int32</rd:TypeName> </Field> <Field Name="MonthTotal"> <DataField>MonthTotal</DataField> <rd:TypeName>System.Decimal</rd:TypeName> </Field> </Fields> <Query> <DataSourceName>Cypress_APP</DataSourceName> <CommandText>SELECT e.Name, Portfolios.Name AS PortfolioName, sc.Month, sc.MeasureID, dbo.udfn_M1vsM2(CASE WHEN sc.[MeasureID] IN (26) THEN (CASE sc.[Measure1] WHEN 0 THEN 0 ELSE sc.[Measure2] / sc.[Measure1] END) ELSE sc.[Measure1] END, CASE WHEN sc.[MeasureID] IN (26) THEN sc.[Measure4] ELSE sc.[Measure2] END, m.BusinessRule, m.partialScore, m.Score) AS MonthTotal FROM ScoreCard sc INNER JOIN Enterprise e ON sc.EnterpriseID = e.EnterpriseID INNER JOIN Measure m ON sc.MeasureID = m.MeasureID INNER JOIN Enterprise_View ev ON e.EnterpriseID = ev.EnterpriseID INNER JOIN (SELECT EnterpriseID, [Name] FROM Enterprise WHERE EnterpriseTypeID = 2) Portfolios ON Portfolios.EnterpriseID = ev.ParentID WHERE (sc.Year = YEAR(@date1)) GROUP BY Portfolios.Name, e.Name, sc.Month, sc.MeasureID, m.MeasureID, sc.Measure1, sc.Measure2, sc.Measure4, m.BusinessRule, m.partialScore, m.Score ORDER BY sc.Month, e.Name, m.MeasureID</CommandText> <QueryParameters> <QueryParameter Name="@date1"> <Value>=Parameters!date1.Value</Value> </QueryParameter> </QueryParameters> </Query> </DataSet> </DataSets> <LeftMargin>1in</LeftMargin> <rd:SnapToGrid>true</rd:SnapToGrid> <rd:DrawGrid>true</rd:DrawGrid> <rd:ReportID>1577349c-ff67-4564-9cb1-afa782e635fe</rd:ReportID> <BottomMargin>1in</BottomMargin> <ReportParameters> <ReportParameter Name="date1"> <DataType>DateTime</DataType> <DefaultValue> <Values> <Value>=DateAdd(DateInterval.Day, (DatePart(DateInterval.Day, Now)) * -1, Now)</Value> </Values> </DefaultValue> <Prompt>date1</Prompt> </ReportParameter> </ReportParameters> <Language>en-US</Language> </Report> Tag: connection Tag: 59394
  - 25
    - Sum the results of a IIF Hey all I have a field in my stored proc that returns a cumalative value I.E Code Cumalative A 5 B 5 C 10 C 10 When i sum the field, the cumalative for C obviously shows 20, however, I need it to display 10 without having to add more groups to the report (this will screw everything up) I managed to do this fine in crystal using the sum on change of group, however, i can't avoid this in sql report I wrote a iif on the line level and that shows this, this returns the correct result set per se =iif(RowNumber("Group4")=1, Fields!cumulative.Value, 0) Results Code Cumalative A 5 B 5 C 10 C 0 I want to be able to sum on the results of my IIF, but i can't. I tried to create a calculate field, but the calculated field won't accept any aggregates or it won't accept items with scope so i can't use RowNumber("Group4") Please help, it's driving me nuts and my deadline has passed :( Tag: connection Tag: 59393

Hi All,
I have two DB's with same store procedures but different data on the tables,
and base on a condition I want to be able to select a different DB.
Can I change database connection in dynamic way from Reporting Services for
sql2000?
How?
Tks in advance...
JFB

Top

Re: connection by zomer

zomer
Tue Sep 05 12:33:42 CDT 2006

you can use this...

exec server_name.db_name.dbo<owner>.proc_name pram1,pram2

JFB wrote:
> Hi All,
> I have two DB's with same store procedures but different data on the tables,
> and base on a condition I want to be able to select a different DB.
> Can I change database connection in dynamic way from Reporting Services for
> sql2000?
> How?
> Tks in advance...
> JFB

Top