question on altering parameter layout on preview tab

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
    - LinkButton Hello All, Please help to figure out. I am new to Reporting Services and I'm using sql server 2000. Question 1. How could I display a text(example: name of person) in Linkbutton instead of in a default textbox available in the report? I would like to make this LinkButton triggers a code behind in a page instead of javaScript. Question 2. How could I put a CheckBox in line of everyrow displayed in a report? Thank you very to much and more power! Best regards, Chesk 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: question on altering parameter layout on preview tab Tag: 80729
  - 2
    - Hyperlink --> Download the file displayed as hyperlink Hello All, I badly needed help from all of you guys... I been stucked with this problem. Please help. I had created a report which displayed the list of files (filename only) that was saved in the database. The table were the files being saved had two columns: 1. FileName--> where the filename part of the file was saved. (i.e. samplefile.doc) --> this displays in the report(rdl) 2. Physical_Location -->This is the path that points to the physical location of the file. -->Example: \\servername\foldername\samplefile.doc The objective is when the user clicks the displayed "Filename", the download dialog box should be displayed. And when he/she clicks the "Save" button from the download dialog box the file will be downloaded to its local machine. but when he/she selected the "Open" button the file will be open BUT the path SHOULD NOT be shown in the address bar. By the way I tried to put this statement at the "Navigation --> Jump to URL" : =Fields!Physical_Location .Value.ToString() and the Download dialog box already popup/shown but when I clicked the "Open" button,the file displays in the browser but the PATH shown at the address bar. Please help me if there is anything I can do with this to make the path not shows in the address bar when clicking the open button. All suggestions are highly appreciated. Thank you very much and more power! Best Regards, Chesk From http://www.developmentnow.com/g/115_2005_2_0_13_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com Tag: question on altering parameter layout on preview tab Tag: 80727
  - 3
    - Migrating Sql RS 2000 to a new Sql 2005 server. hi I have a sql server 2000 with reporting services and various schedules set up which is going to be retired. I have a new server where I will be moving all the relevent databases to. What would be the best way to move all these reports onto a new Sql Server 2005. I know a sql 2005 to sql 2005 move will involve a database move but I don't think a 2000 RS database move to a Sql 2005 server is possible. Has anyone any experience of this. thanks for any advice Sammy. Tag: question on altering parameter layout on preview tab Tag: 80725
  - 4
    - BusinessObjects and Cognos vs Reporting Services Someone know if there are documents about a comparison of RS and BO XI and Cognos? Thanks. Tag: question on altering parameter layout on preview tab Tag: 80721
  - 5
    - Reports displaying date formats correctly for international suppor I have some reports that I want to beable to have one version of them, and display the proper date format for wherever they are deployed. For instance in the US I want them be displayed as mm/dd/yy, deployed in the UK I want dd/mm/yy, etc. I have found that this is supposed to happen if I change the report language itself to the expression "=User!Language", but it looks to me as though the date field cells in the report still have a "hard coded" format property of mm/dd/yy? Does the language expression over ride this, if I go into the RDL's XML and delete the date format tag itself, I get the entire date, hours, minutes, seconds, etc. I also noticed the date field cell in the report has it's own language property, that is set default. How should I set these to get them to work properly? Thanks, Jason Tag: question on altering parameter layout on preview tab Tag: 80719
  - 6
    - Snapshot doesn't work Hello. I have a report that when I'm going to the reporting services to the "History" tab I can press "new snapshot" and it works fine (The snapshot was created). When I try to go to "properties" and then to "history" to configure it to schedule a snapshot every 5 minuts - nothing happen and the snapshots does't appear. I don't see any error on the server. Is there a way to see way the snapshot can be created manually but not with a schedule? Thanks Tag: question on altering parameter layout on preview tab Tag: 80717
  - 7
    - Dynamic Reports via SSRS Web Services We want to embed reporting capabilities into a web application where the user can select the columns they want in a report and build a where clause on thier own. What is the best way to handle this with SSRS? I was thinking we would handle building the sql stmts in C# and then we would fill a strongly typed dataset and set it as a the datasource for a rpt. I have not been able to find any sample code on how to dynamically build a report with SSRS given a dataset. Is this possible? Am I even taking the right approach for this problem? Tag: question on altering parameter layout on preview tab Tag: 80712
  - 8
    - Report Subscriptions Issue SSRS 2005 / SQL SERVER 64 BIT Issue: Users under the Browser Role who have the Subscription attribute checked can create subscriptions, however they cannot view them. Indications: I as administrator can see their subscriptions and they run without any issues. Also when setting up the subscription, after typing in the email address(es) when selecting the scheduled runtime the email addresses are erased. Other information: Users are Non Domain (Local) Windows Users. The SQL Server is running under a Service account, typical setup. Tag: question on altering parameter layout on preview tab Tag: 80707
  - 9
    - RS 2000 "Search For" Feature quit working We are using RS 2000. The "Search for" feature has worked in the past and was really nice for finding a particular report. However, today it is not working. I put text in the box and click Go and nothing happens. Reports run OK. Any ideas what would cause this to fail? Thanks in advance, Kevin Tag: question on altering parameter layout on preview tab Tag: 80705
  - 10
    - Microsoft Report Viewer Redistributable 2005 SP1 Hi, Can "Microsoft Report Viewer Redistributable 2005 SP1" be installed in Windows 2008 server? Thanks Anurag Tag: question on altering parameter layout on preview tab Tag: 80704
  - 11
    - Columns question Hi, I have a simple report (for labels) split into 3 columns... the alphabetically sorted data goes down column 1, then column 2 then the 3rd before starting again on the second page. Is there any way I can get the data to work left-right? over 3 columns and then start again on the 2nd row? and turning the page when needed? Any ideas would be appreciated! cheers Tag: question on altering parameter layout on preview tab Tag: 80703
  - 12
    - Barcode in a report Hello everybody, I need to add a barcode in a report using Reporting Services. I saw there are a lot of commercial components, but I was aiming at something more... "cheaper". Any recomendation of where to start? Thanks a lot. -- ____________________________ Carlos Sosa Albert Tag: question on altering parameter layout on preview tab Tag: 80702
  - 13
    - Problem with "Start without debugging" Hello, I read the tutorial of Reporting Services 2005 on the MSDN website and when I want execute the report with the option "Start without debugging", appear the request of user and password, but I have windows authentication. If I connect SQL Server Reporting Services with Management Studio I don't have the request. Where is the problem? Thanks. Tag: question on altering parameter layout on preview tab Tag: 80700
  - 14
    - hdmi input dvi i kabel dual hdmi cable hdmi dvi kabel 5m x1650 hdmi hdmi input dvi i kabel dual hdmi cable hdmi dvi kabel 5m x1650 hdmi +++ BILLIGE HDMI KABEL KAUFEN +++ BILLIGE DVI KABEL KAUFEN ++ http://HDMI-KABEL.BUYONLINE24.INF http://HDMI-KABEL.BUYONLINE24.INF http://HDMI-KABEL.BUYONLINE24.INF http://HDMI-KABEL.BUYONLINE24.INF http://HDMI-KABEL.BUYONLINE24.INF http://HDMI-KABEL.BUYONLINE24.INF http://HDMI-KABEL.BUYONLINE24.INF http://HDMI-KABEL.BUYONLINE24.INF http://ibm-news.for-um.de/showthread.php?t=1492 http://ibm-news.for-um.de/showthread.php?t=1465 http://ibm-news.for-um.de/member.php?u= http://ibm-news.for-um.de/showthread.php?t=1470 http://ibm-news.for-um.de/showthread.php?t=1488 http://ibm-news.for-um.de/showthread.php?t=1176 http://ibm-news.for-um.de/showthread.php?t=1479 dvi adapter kabe dvi d kabel 5 belkin hdmi kabe pure innovation hdm 690g hdm hdmi kabel 15 watson hdmi kabe x1650 pro hdm mini dvi hdm hdmi 15 hdmi control cente dvi kabel 10 vga hdmi kabe hdmi ohne hdc hdmi hdmi kabe hdmi kabel 7 3x hdm hdmi versio langes dvi kabe hdmi outpu 1 hdmi kabe radeon x1650 hdm 1 hdmi kabe x1600pro hdm hdmi control cente meter hdmi kabe am2 hdm hdmi kabel real matri dvi kabel 30 meter hdmi kabe hdmi kabel is hdmi 1.3 dvi kabel foru 6370 hdmi kabe hdmi adapter kabe dvi kabel 18 1 Tag: question on altering parameter layout on preview tab Tag: 80698
  - 15
    - Web service as a data source for a SSRS report Hi All, We have a need to use a web service as a data source for SSRS report/ s. Basically we have data from remote systems available as a web service and I would like to source this into SSRS. The reason they have been published as a web service is to enable real time reporting. Please advice how I can do this in SSRS. Thanks Karen Tag: question on altering parameter layout on preview tab Tag: 80696
  - 16
    - Installation on Windows 2000 Server I have a client that has run SQL Reporting Services 2000 for the last 4 years. They have have installed SQL Server 2005 and are finally ready to move their reporting services to the new version. The installation completed without error. Running the configuration, steps 1 - 4 went through seamlessly, however when attempting to set the Web Service Identity, the ASP .NET Service Account is blank. All attempts at manually changing the rsreportserver.config file have made no change. Help please. They are running Windows 2000 Server SP4, IIS5. Thanks in advance. Tag: question on altering parameter layout on preview tab Tag: 80695
  - 17
    - Totals with Top N or other filter When using the Top N operator on the detail section, any group totals continue to display the totals for the entire set. For example, if I want to see the top 5 products for each department by sales, and I have a group on department, I want the totals to reflect just those top 5 products for each department, but the totals reflect all products. We put a query in to MS, and they said this was by design. Does anybody have a workaround for this? Tag: question on altering parameter layout on preview tab Tag: 80693
  - 18
    - Aligning Matrices and tables in SRS I am working on creating custom report cards for our school district using SRS 2005. The problem I'm having is that I have several Matrices and tables side by side on the report and I have set the items to be in the correct spot on the layout tab but when I go to preview the report there is an excess of white space between the different areas making the report longer. Different things I've tried are: I had one rectangle for all the tables and matrices on the report and they were all in one but still had the same problem. Tried seperate rectangles for each column of tables and matrices with the same result Tried seperate rectangles for each of the items with the same result. All Items are grouped together but I have yet to figure out how to keep the items together on the report. I was going to attach some screen prints but the forum won't allow attachments so you can see what I'm looking at. Thanks in advance for any suggesstions. -- Wayne Hess Tag: question on altering parameter layout on preview tab Tag: 80692
  - 19
    - Upload rdl file via Report Manager Hi All, I am trying to "manually" deploy a report to my Reporting Services Server using Report Manager. Basically, I used the Business Intelligence Development Studio to create my report. After that, I have tried to upload my report using Report Manager. Namely, I tried to do an "Upload File" of the .RDL file. The report itself showed up correctly but when I invoked it, I noticed that it does not provide the two datetime parameters that I specified as needed in my report. Basically, my report consists of running a stored procedure that takes two datetime parameters. When I preview the report, it does contain the two date time parameters that the user can populate and works correctly. But as I said, when I manually upload it to the server, it does not. I also tried to upload the .data file associated with my report but that didn't change anything. BTW, I have created other reports that call stored procedures and that require 2 datetime parameters and they all worked correctly. The difference was that I used the "Deploy Report" option in Business Intelligence Development Studio rather than manually uploading the .RDL file. Am I missing something? Thanks! Tag: question on altering parameter layout on preview tab Tag: 80691
  - 20
    - Report Services Web Part - How to set default zoom I am using a report services web part in sharepoint. The Report was designed using Visual Studio 2005 and I can't figure out how to change the Report Web Part's default Zoom from 100% to 75%. Any help would be appreciated. Tag: question on altering parameter layout on preview tab Tag: 80690
  - 21
    - restrict report folders hello. I need help with this report permission issue that is driving me nuts. On the report server we have certain reports folders that is suppose to ONLY be visible by departments. Now all the folders and contents can be seen by every user. I went and created a folder stripped all the permission and left just my account and it still visible by others. Can any help with identifying where permissions are inherited from or how to resolve this issue. Thanks in advance for your help. Tag: question on altering parameter layout on preview tab Tag: 80688
  - 22
    - Render a dynamic image with handler Hello, All. I'm trying to use a HttpHandler( .ashx ) to generate dynamics images. I have a image object in my report with the source property setted to "External" and a expression to my handler. If i try to use the handler outside of the report everything works , but inside the report the image is never showed. Everyone already try to use this! Eug=EAnio Tag: question on altering parameter layout on preview tab Tag: 80687
  - 23
    - How to load in ReportViewer a rdlc report located in another assembly Hi, I'm using VS2008 and I'm trying to use ReportViewer in WinForm applications. I created a project containing a report that i have to load in a ReportViewer control. The ReportViewer control is in a different project so i referenced the project where the report is contained as embedded resource. I tried to load the report with this code: ReportViewer.LocalReport.ReportEmbeddedResource = "MyApp.Reports.MyReport.rdlc"; but when i try to load the report i receive the following error message: "The report definition for report 'MyApp.Reports.MyReport.rdlc' has not been specified" So, how can I solve this? Tnx Tag: question on altering parameter layout on preview tab Tag: 80683
  - 24
    - SSRS - Get IP - returning wrong IP address I am trying to resolve a simple problem, yet am again totally stuck - please help!! I have 2 datasets - one dataset should get the IP Address of the person running the report: SELECT client_net_address as p_IP_Address FROM master.sys.dm_exec_connections WHERE session_id = @@SPID; I pass the p_IP_Address from this dataset as a default value for the report parameter into my second dataset - which merely runs a simple SP to get several rows which are displayed on the report - this is working fine now. The GET_IP_Address dataset does return one row with one field - but it is returning the IP Address of the SSRS SQL Server machine - where the RDL is run from - not the end-user IP Address. I have tried several different tacks to get the correct IP address into the second dataset, but to no avail. When the report is run in Visual Studio 2005, it shows the correct IP Address, but when I deploy it to the produciton server, and then run it - it does not return the IP address of the person running the report - the report is executed via URL. Please help -- vpdj @ yahoo.com TIA Tag: question on altering parameter layout on preview tab Tag: 80681
  - 25
    - SQL Server 2005 express "report design" folder not found I user SQL server 2005 express reporting service to design a report, also a net .dll library is required , i need to copy it to "C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer.", however i can not find this folder on my box, i can only see "C:\Program Files \Microsoft SQL Server\80\Tools\", there are "Binn" and "Devtools" sub folders under that folder, no "Report Designer" sub folder, did I miss something during installing SQL Server 2005 and SQL Server 2005 Toolkit? Thanks, Bob Tag: question on altering parameter layout on preview tab Tag: 80680
- Next
  - 1
    - Kerberos Errors and Reporting Services only accesable from localho I've setup SQL Reporting Services 2005 a coupld of times in the past have never had this issue. However this time, it seems that the reporting sites are only available via the http://localhost/reports Logon fails when trying to login to the sites via their fqdns and I'm getting kerberos errors in my systems logs. I've tried using setspn for this however, it just doesn't seem to resolve the issue. Right now my only work around it to run of integrated windows security in IIS and turn on basic authentication. However some links still wnat users to login via http. Has anyone run into an issue like this where integrated windows authentication will not work to authenticate users to the SSRS web sites (if so how can on resolve the issue). Tag: question on altering parameter layout on preview tab Tag: 80679
  - 2
    - How do you create a new chart for each variable? I am using SSRS 2005 SP2. I am wondering if it's possible to create a new chart for every variable from a query. My data consists of server/database/log sizes. So server A has databases DB1, DB2, DB3. I want to have each database/log pair show on a separate chart. Eash server could have several databases and of course databases could come and go, so this needs to be dynamic. Is this even possible? Thanks, Peter Cwik Tag: question on altering parameter layout on preview tab Tag: 80677
  - 3
    - Sub-report within Matrix Hello, Is it possible insert a table as subreport into a Matrix? What i want is to allow the user to drill-down and see the detail of the matrix. Thanks in advance, Carlos Tag: question on altering parameter layout on preview tab Tag: 80675
  - 4
    - Error when i try access Report Server Hello, After i applied SP2 in a Cluster of SQL SERVER 2005 the Report Server stop working. The message is "The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors " How can I fix this issue ? I already try rsconfig to recreate the key. Thank you. Marcelo. Tag: question on altering parameter layout on preview tab Tag: 80674
  - 5
    - RSViewerPage failing RSViewerPage.aspx will not display reports. Configuration- Reporting services in Sharepoint Integrated mode, all security is managed in the underlying database. Data model and connection use integrated security. User can create and modify Sharepoint content freely in the reports folder. If we create a wep part page, we are able to add a reporting web part, which shows the data appropriate to that user. However, when RSViewerPage.aspx tries to render a Reporting Services Report, 'Access Denied' is returned to the browser. Something specific to the execution of RSViewerPage.aspx is failing. Is there anything else I should be investigating? Tag: question on altering parameter layout on preview tab Tag: 80672
  - 6
    - gif image shows jpg image does not I am puzzeled as to why one image type will show in the browser when the report is viewed and the other type (jpg) will not. I have both image files in the same folder as the report. When I view the report with te gif image and select the properties for the image I get all the infomationsuch as type = GIF location etc. When I use the jpg image I get a red x box and no values show for the image when right clicked and the properties option is selected. Any ideas of why this may be? Thanks, Tag: question on altering parameter layout on preview tab Tag: 80669
  - 7
    - SSRS-Grand totals in the last page when grouping is applied Hi All, My report consists of a single group based on customer name and we print totals in group footer for each customer. The "Page Break On End" is set to true for the group. I have also placed the grand totals in the table footer. However, the grand total alone prints in the new page, after the last reporting group. I want it to be printed just below the group total of the last group in the report, instead of printing in a new page. Is there any way to do it?. Any help will be appreciated. Cheers, Pradeep Tag: question on altering parameter layout on preview tab Tag: 80667
  - 8
    - Subscriptions on SRS 2005 We are in the process of migrating all of our reports from anSRS 2000 implementation to an SRS 2005 implementation, and I am having a problem with subscriptions. On the old box, when someone wanted to subscribe to a report, they simply clicked on the subscription link and their domain name (example: pmcbride) would appear in the To: field. They would add a subscription, hit enter, and the subscription would work. Now, it appears to work exacltly the same. However, when they submit the description, it does not work. Why? Because the new implementation requires not just the domain name, but the entier email address in the To: box. So where the subscription page opens with "pmcbride" on the screen, what SRS needs is the full email address of pmcbride@mycompany.com. Did we forget to set some important configuration? Thanks in advance... Paul Tag: question on altering parameter layout on preview tab Tag: 80658
  - 9
    - Adding a dataset problem Good Morning, I have a very frustrating problem. I have a report that needs two datasets from two different data sources. i have reaports that already have multiple datasources, and eveything is okay. THis report however, when i add the dataset and source, once i save the report, it chages the datasource. let me explain: dset A uses dsource 1 i added dset B that uses dsource 2 everything sets up ok, then, i go into the properties of dset A, and it has dsource 2 as the dsource if i change that back to 1, then it changes dset B's dsource to 1 also This is really driving me nuts! TIA ~K -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200807/1 Tag: question on altering parameter layout on preview tab Tag: 80655
  - 10
    - Reporting Services - Portfolio Server Installation/Config Issue Hello I'm setting up a demo box for Portfolio Server for the PM group. I installed everything on the one box for the demo: Microsoft Windows Server 2003 R2 SP2 SQL Server 2005 SP2 SharePoint Server 2007 SP1 Project Server 2007 SP1 Portfolio Server 2007 After installing SQL Server, I ran the configuration utility for Reporting Services and everything was successful. After installing Portfolio Server 2007, I was supposed to check to see that the Reporting Services integration was successful by browsing to a couple of sites: http://<servername>/ReportServer http://<servername>/Reports I can navigate to http://<servername>/ReportServer, but when I navigate to http://<servername>/Reports I get the following error: Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'. Source Error: Line 183: </webParts> Line 184: <machineKey validationKey="588ECF8DDE8B5707B90224C2C11E60EAA6B8A6974AC80560" decryptionKey="74F69FA872AED6DDB83CEECC7644DCE1FFDB34ECF6A949CF" validation="SHA1" /> Line 185: <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> Line 186: </system.web> Line 187: <runtime> Source File: c:\inetpub\wwwroot\web.config Line: 185 -- any help would be appreciated. Tag: question on altering parameter layout on preview tab Tag: 80652
  - 11
    - Dynamic Report on Dynamic recordset sorry, maybe I didn't searched enough, but I can't find an answer for this question ... I'd like to build a dynamic report based on a dynamic record set. How can I do it? Just to make me understand, here you find an hypothetical origin of data I'd like to output: create procedure [dbo].[SP_Dynamic_report] @param int =1 as BEGIN if @param=1 select top 10 * from SYSOBJECTS else select top 10 * from syscolumns end then the user can chose between param 1 or 2 and get in the same report different data ... exec [SP_Dynamic_report] 1 exec [SP_Dynamic_report] 2 Is it possible? Can you provide me an example? or a link? Thank you very much for any help! Lorenzo Tag: question on altering parameter layout on preview tab Tag: 80649
  - 12
    - Can I define what order I want reports displayed via SQL Server I have a list of reports, which I have published into one folder. Ideally, I would like to order the reports when the user logs onto the web page. At the moment they default to A to Z sorting. Users would not want to see the details screen. can this be done? Thanks Paddy Tag: question on altering parameter layout on preview tab Tag: 80647
  - 13
    - What is the best way to setup SSIS, SSRS, SSAS within a two note cluster? Hi All, I'm fairly new Clustering and I'm looking for advices. I have successfully setup a test SQL Server Database Engine on a two node ( passive/active ) cluster using MS Virtual Server. I would now like to setup SQL Server Reporting, Integration, and Analysis Services on the same cluster. I know Reporting Services and Integration Services are not cluster aware. Can anyone give me advices on the best way to install these three components for high availability within a two node cluster. Are there any good articles or install guides on the web? Current Setup: 1) SQL Server 2005 Ent - Windows 2003 Ent 2) Node1 - Windows 2003 Ent 3) Node2 - Windows 2003 Ent Sorry if my Cluster terminology is incorrect. Many thanks Colin Tag: question on altering parameter layout on preview tab Tag: 80646
  - 14
    - return results from stored procedure Hi All, I have managed to get my Reporting Services 2005 up and running. I have a question though: Instead of defining my dataset as a text query (such as select * from table..) I would like to define it as executing a stored procedure. This stored procedure will be a little bit more complex than just a simple (select * from..) In other words, it will look into some tables and then iterate through some values... WHILE BEGIN -- get my values here -- Here i Used to build a string with the data needed and just print it (e.g., SET @PrintString = @Value + N' ' + @Value2... ) -- PRINT @SPrintString FETCH NEXT..@Value, @Value2.. ... END I used to create a string and print that, but now I would like the results in a table form so that Reporting Services renders them correctly as a report. Should I somehow create a temporary table and insert the values in it and then have my query something of the form (INSERT INTO TempTable exec sp_StoredProcedure) ? Is this the correct way of doing it or should I go about it a different way ? And if this is the solution, how would I create this table and how would I actually return it ? Would I just create it before calling the stored procedure and drop it after that? Thanks. Tag: question on altering parameter layout on preview tab Tag: 80645
  - 15
    - Access a named parameter in an RDLC report in local mode I need information on how to programmatically access a named parameter within an RDLC file associated with a ReportViewer in local mode. I also want to verify that a parameter set up like this =Fields!personID.Value will return what I am expecting. For example if "LName" is displayed in a box and the parameter name is 'person_id' with the associated parameter value =fields!PersonID.Value then when the user clicks on the textbox with "George" then the ID for george will be available in that parameter and can be obtined programatically from the ReportViewer1_Drillthrough event. Thanks, Doug Tag: question on altering parameter layout on preview tab Tag: 80644
  - 16
    - Help on installing Reporting Services NOT on Default Web Site Hello: Long story short, our IIS box does not have the "Default Web Site". And, for whatever reason, it does not appear that you can configure SRS 2005 to use a site other than the Default Web Site. I have followed Microsoft's instructions, on creating a new web site for SRS. The problem is that we cannot use port 80, because that is our Sharepoint port. (The instructions seem to indicate the typical port used is the one for the Default Web Site--port 80.) Anyway, when I went into SRS Report Configuration Manager to create a new virtual directory, it errorred-out saying that it could not create one. Has anyone out there been able to successfully configure SQL Reporting Services 2005 to use a site (and a port) other than the Default Web Site? If so, I really would like instructions for this, other than the ones that Microsoft has posted (because they are not any good). You may please send them to my Hotmail address at sqlprogrammer@hotmail.com. Thanks! Please let me know, if you have these instructions. SQL Programmer (it's just a name) Tag: question on altering parameter layout on preview tab Tag: 80640
  - 17
    - Problem with printing a SSRS report Hi I'm working with SQL Server 2005 and Visual Studio 2005. I'm creating an SSRS report and everything works fine...until I try to print it. When I do so on the local printer it prints fine, but when I run the application via Citrix and use ThinPrint to print it the report prints itself, but strangely, on paper I get black rectangles instead of my textboxes with information. Help would be appreciated, thanks! Da From http://www.developmentnow.com/g/115_2006_3_0_1_0/sql-server-reporting-services.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com Tag: question on altering parameter layout on preview tab Tag: 80638
  - 18
    - Export to MSProject Is there a direct way to export a SQL Server report to a Microsoft Project file? -- stullhe104 Tag: question on altering parameter layout on preview tab Tag: 80637
  - 19
    - change label, error with asp and network reports Hi, I hope someone can help me with three newbie problems . 1) When I have a user editable parameter in my reports, the user can edit the parameter and then hit the "View Report" button to see the report. Is it possible to change the label of the "View Report" button to something else? I basically need to translate "View Report" to a different language. 2) For some reason, I can't start my Report Server. All the configuration sections are OK except the "Web Service Identity" one. In that particular section, my ASP .NET Service account is listed as "COMPUTERNAME\ASPNET" where COMPUTERNAME is my computer name. The ASP.NET State service is started. When I hit the Apply button, I get an error stating: "There was an error setting the identity for the web service. The previously set identity will still be used." If I click "Tell me more about this problem... " it says "ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 8007056B" in the "SetWebServiceIdentity" function. 3) I am using SQL Express and I have two computers on a network (no domain, the computers are just in a workgroup.) I have both SQL Server Express and Reporting Services installed on Machine 1 together with IIS. Would it be OK to connect from Machine 2 to Machine 1 via IIS and navigate to the Report Server and see the Machine's 1 reports ? By that I mean, is it technically possible and is it allowed by the licensing constraints ? Thanks! Tag: question on altering parameter layout on preview tab Tag: 80634
  - 20
    - Document layout in reporting services Good morning, I have a question about reporting services. I have to generate a report in a document format, not a table format. Does it allow a report layout to simulate a document? Fields in a paragraph, text dinamically suited to margins.... If not, could you give me any suggestions?? I have to generate it for ms crm. Thank you very much!!! Tag: question on altering parameter layout on preview tab Tag: 80633
  - 21
    - Connecting with management studio? I recently installed a new server with SQL 2005 Server and want to use Reporting Services. I've logged into the server as the local administrator, launched the Management Studio and tried to connect to the Reporting Services. It blanks the server name so I reenter it and click connect. That's when I get the error message listed below. I added the local adminastrator account as well as the Domain Admins account to the Distributed COM User group but I still cannot connect. What am I doing wrong? Why can't I connect to the Reporting Services Server? Heck, while I'm here, I was reading through the tutorials on Microsoft's web site and it tells me to go to the following URL: http://<serverName>/reports I find that when I go there, replacing the <serverName> tag with my actuall server name, it prompts me for login credentials but won't take anything I give it. If I go to http://localhost/reports, it works just fine. Can someone explain that too me too? Why does it do this? The server name does resolve in DNS. Thanks in advance, Linn TITLE: Connect to Server ------------------------------ Cannot connect to cmw-sql2k5. ------------------------------ ADDITIONAL INFORMATION: A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ BUTTONS: OK ------------------------------ Tag: question on altering parameter layout on preview tab Tag: 80629
  - 22
    - subtotal problem of calculated field I have a matrix report that is based on an AS cube. There are two dimensions defined as rows. The report has three measures, 'Total Value' and 'Number of Orders' are from the cube, and 'Average value' is an calculated one, equals 'Total Value'/'Number of Orders'. Below is what the report shows. State Zip Total Value Number of Orders Average Value AZ 11111 100 10 10 11112 200 5 40 11113 90 10 9 Total 390 25 10 (should be 15.6) AK 22222 400 2 200 22221 50 1 50 Total 450 3 200 (should be 150) As you can see the problem, in total, I am getting the currect sum(Total Value) and sum(Number of Orders), but Average Value is not correct, it's replicating the first row of the group. Can someone tell me where the problem is coming from? Thanks very much. Tag: question on altering parameter layout on preview tab Tag: 80626
  - 23
    - Access to the temp directory is denied I receive the following error when I go to http://<server>/reports for SSRS 2005. Access to the temp directory is denied. Identity 'CASINO\MichaelP' under which XmlSerializer is running does not have sufficient permission to access the temp directory. CodeDom will use the user account the process is using to do the compilation, so if the user doesnt have access to system temp directory, you will not be able to compile. Use Path.GetTempPath() API to find out the temp directory location. This issue seemed to go away when full access was given to the 'Everyone' group on C:\Windows\Temp. I want to avoid giving the 'Everyone' group full access to the Server's Temp directory. Any ideas? Tag: question on altering parameter layout on preview tab Tag: 80623
  - 24
    - Querying ExecutionLog Table I'm writing a quick and dirty report to give to the powers that be showing just how often - or not - certain reports are run. I'm also going to include some other anecdotal information. One of the things I'd like to include are average times (rendering, data retrieval, etc.). Here's what I've got so far that works really well: SELECT DISTINCT c.Name, c.Path, c.CreationDate, c.Description, COUNT(e.ReportID) AS [Number of Times Executed], MAX(e.TimeStart) AS [Last Time Executed], AVG(e.[RowCount]) AS [AVG NUMBER OF ROWS], AVG(e.timedataretrieval) AS [AVG DATA RETRIEVAL TIME], AVG(e.timeprocessing) AS [AVG TIME PROCESSING], AVG(e.timerendering) AS [AVG TIME RENDERING] FROM ExecutionLog AS e INNER JOIN Catalog AS c ON e.ReportID = c.ItemID GROUP BY c.Name, c.Path, c.CreationDate, c.Description ORDER BY c.Name While this works great, there's one problem. When calculating the averages, I only want to include those executions that had a status of rsSuccess. For example, one report was run three times. One execution had an rsInternalError with a row count of half a million. The other two times succeeded and had significantly lower row counts. When calculating the averages, I'd like to throw out the "bad" executions, so as not to skew the results. Could someone suggest how I can tweak this query to accomplish this? Thanks!! Tag: question on altering parameter layout on preview tab Tag: 80621
  - 25
    - Parameter not being passed to stored procedure eI have created a report that contains several stored procedures and they except a parameter to be passed to it... The parameter name is the same in all the stored procedures. I created a report parameter and named it exactly like the parameter in the stored procedures. I can run the report on my local machine without a problem. However, when I depolyed the report to a report server and try to run the report it comes back with an error that one of the sp's is excepting a parameter. How can I fix this since it works on my machine without an issue. Thanks in advance. Tag: question on altering parameter layout on preview tab Tag: 80615

All,

Just a minor annoyance, but I am wondering if anyone can help me.
When I preview my report using the preview tab, my parameters appear
up top in two columns. I have _lots_ of parameters, so it would be
much easier for me if i could get them in three columns, thereby
shortening the height necessary to view all parameters.

Is this possible?

Best,
Kathryn

Top

Re: question on altering parameter layout on preview tab by Bruce

Bruce
Wed Jul 23 09:37:47 CDT 2008

Unfortunately this is out of our control. I don't believe this has changed
in RS 2008 either.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"kbutterly" <kbutterly@yahoo.com> wrote in message
news:2b0261be-f4ee-49f6-9e59-ad7b97525b7f@59g2000hsb.googlegroups.com...
> All,
>
> Just a minor annoyance, but I am wondering if anyone can help me.
> When I preview my report using the preview tab, my parameters appear
> up top in two columns. I have _lots_ of parameters, so it would be
> much easier for me if i could get them in three columns, thereby
> shortening the height necessary to view all parameters.
>
> Is this possible?
>
> Best,
> Kathryn

Top