How can I devide one column by another?

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
    - Stored procedures vs. command strings... My boss wants me to use stored procedures, but I thought somehow that ADO.Net was better. Any help is appreciated. Thanks, Trint Tag: How can I devide one column by another? Tag: 20111
  - 2
    - Can i use multiple Datasets in a single data region I want to know that is it possible to show data from more than 1 data sets in a single data region, for example i want to show Supplierid,Suppliername and other Supplier info stored in a table also i want to show the comapnies names where the Supplier supplies the material, with the supplier name, which is coming from different table. The problem is that these two tables are coming from different Databases, 1 table is from MS SQL server and the other is from Oracle. I want to show the data from these 2 data sets in a single table on the report, please help Tag: How can I devide one column by another? Tag: 20110
  - 3
    - using the "IN List " operator in reporting services. Hello all! I have a report in which i need to use the in list function in the where clause of my sql. ie 'country.country_name in list england, usa, china' how do I do this in Reporting services? at present I am getting the following error message: "Error in List of values in IN clause" Is there any way around this? I understand that RS may not support the in list operator? - seems like quite an oversight??? Thanks for any help given. Tag: How can I devide one column by another? Tag: 20109
  - 4
    - SQL Server reporting services I want to create a report which takes a parameter which should be able to select multiple values. I am not able to find a way to do so till now, For example i want a query which should be like select * from departments where departmentID in @DeptID now i should be able to provide multiple department values. please help me Tag: How can I devide one column by another? Tag: 20108
  - 5
    - Deserialization failed I got the following error message : Deserialization failed: File or assembly name Microsoft.ReportingServices.Interfaces, or one of its dependencies, was not found. I use Vault Source Control as my source controll system. I then opened a Reporting Services project with rdl's in it. Every RDL that is currently in source control opens with this error "Deserialization failed: File or assembly name Microsoft.ReportingServices.Interfaces, or one of its dependencies, was not found." can somebody help me out on this one ? it is verry urgent ! Tag: How can I devide one column by another? Tag: 20106
  - 6
    - Key not valid for use in specified state? Hi! I just ran into the same old problem that I got a few months back. Reporting Server stops working and logs the message "Key not valid for use in specified state". I did never manage to solve the problem when it occured before but at that time it happened on a development server, this time it is worse as it is on one of our production servers. I know that there was several people suffering from the same problem after applying .Net Framework 1.1 SP1. Did anyone find a solution? Best regards, Per Salmi Tag: How can I devide one column by another? Tag: 20104
  - 7
    - Email delivery not functional Hello all, I have programmed some subscriptions, containing sending EMails to different recipients. My Problem: The delivery of the mails is functional to Email-adresses like ...@web.de or sth., but NOT to emails like ...@t-online.de . It would be nice, if anyone could help me, itÂ´s very important. Thank you in advance Tag: How can I devide one column by another? Tag: 20101
  - 8
    - Default Parameter Date How do i set a pre determined time on a parameter date that is set as =(today) so it says today at 8:00 AM. Thanks Tag: How can I devide one column by another? Tag: 20099
  - 9
    - Bar Chart Help I would like to display the series field at the start of a bar instead of using a legend. thanks in advance Tag: How can I devide one column by another? Tag: 20098
  - 10
    - Embedded html formatting Is it possible to embed formating info along with the data. Such as html tags included with the data item in a text box field? It seems to just see the html tags as text as the renderer puts string delimeters around it. Tag: How can I devide one column by another? Tag: 20096
  - 11
    - Questions for SP2 Testers Can any of your folks check your documentation to see if either of these 2 issues have been addressed: 1) Large reports crashing with error: [An error has occurred during report processing Exception of type System.OutOfMemoryException was thrown] 2) Any improvements in report parameters such as allowing multi-select? Many thanks for any info! Tag: How can I devide one column by another? Tag: 20090
  - 12
    - How Hide Colum Headings I have a report that consists of 4 groups representing 4 levels of grouped data with separate column headings and no detail rows as follows: ColHeading 1 Level 1 ColHeading 1.2 Level 1.2 ColHeading 1.2.1 Level 1.2.1 ColHeading 1.2.2 Level 1.2.2 The report always prints a column heading at each level even when no data is printed at that level. I have tried using the invisibility test as follows: -Select ColHeading 1.2 row -Test for existance of first cell in Level 1.2 -Get error that item is out of scope Can this be done? Many thanks! Tag: How can I devide one column by another? Tag: 20089
  - 13
    - Multiple Detail Rows Rendering in CSV I'm not sure if this is the expected feature, but when I render a simple table that has two detail rows to CSV the second row is appended to the end of the first row. This does not happen in PDF/HTML/EXCEL. Here how the report is designed: Table Column1|Column2|Column3 TextBox1|TextBox2|TextBox3 TextBox4|TextBox5|TextBox6 In Excel, the output is: 1,2,3 a,b,c 4,5,6 a,b,c In CSV, the output is 1,2,3,a,b,c 4,5,6,a,b,c Is there any way to get the output to work in CSV as it does in Excel? Thanks scott Tag: How can I devide one column by another? Tag: 20087
  - 14
    - SQL 200 RS migrating to SQL Server 2005 I know this is jumping the gun a bit, but my company is about to move to a Reporting Services platform and rewrite a ton of reports. With that being said there are also alot of features being talked about that we want to use in the coming 2005 version of Reporting Services. I am not sure if this can be answered yet, but does anyone know if the migration from 2000 to 2005 is planned to be easy or is the product changing significantly? Tag: How can I devide one column by another? Tag: 20086
  - 15
    - SMS and Reporting Services ARe there any premade tools or products to provide sms reports through reporting services? Maybe even any guides if there isn't a solution on the market already. I am looking to provide SMS reporting through Reporting Services. Tag: How can I devide one column by another? Tag: 20084
  - 16
    - RTF Fields I think this has been asked before so apologies in advance. However, I stil have not found a solution or workaround. I need to print RTF data in a reports but cannot think of any way of doing this, short of creating a rendering extension - which is not documented (yet). I thought maybe SP2 would have something for this but I don't seem to be able to get access to the beta (I've been waiting since last week for access). Maybe SQL 2005 RS B2 has this ability? Either one of these options would be acceptable. Can someone tell me wether I should wait for SP2, use SQL 2005 or hand code the report? If I go with 2005 can I still use VS.Net 2003? Sorry, lots of questions for such a simple (?) thing. Thanks Tag: How can I devide one column by another? Tag: 20083
  - 17
    - page break Hi, I have a report with multiple pages. I added a page break but then went to the table properties and unchecked the page break checkbox. However, when i run the report from my vb.net application I can see a page break at the end of each page. How can I delete the page breaks? Thanks. Tag: How can I devide one column by another? Tag: 20080
  - 18
    - Changing the Encoding and the Layout I want the layout of my reports to be from right to left. I changed the direction of all the relevant controls to RTL, but the report layout remains from left to right.. I tried to change the direction through the encoding menu and found 4 places in which it can be done: 1. The encoding of the IExplorer (View => Encoding..) which doesn't influence anything. 2. The encoding of the first upper title (where I choose the parameters) using right click. 3. The encoding of the second upper title (where I choose the pages, the export menu, etc) using right click. 4. The encoding of the reprt body using right click. After changing all the 4 encodings the report look fine (RTL), but once I do "View Report"- everything return to the begining (LTR). What can I do? How can I save the deployed report with the correct definition of the encoding? Tag: How can I devide one column by another? Tag: 20076
  - 19
    - Sql Server 2000 Reporting service I want to use Sql Server Reporting service but I need the front end so can any one tell me is there any evaluation version of .Net so I can download from the net easily and use the reporting service of Sql Server 2000. Thanks Noor Tag: How can I devide one column by another? Tag: 20073
  - 20
    - Installatuin Problems Hi I have SQL SEVERVER 2000 ENTERPRISE EDITION (with sp3a) ON o/s 2003 I tried to install SQL SERVER REPORTING EVAL downloded from MS site. (pending CD from retailer) During the installation it tested for prerequisites and has thrown message saying IIS is not installed or neither configured for rs. But when I open .net report wizard etc are working fine. I can preview report in .net again Problem is when i tried to deploy it , it is saying reporting server is not available. I unistalled it and again checked while installing I found the following: again same problem related to IIS. ( I checked again ASP.NET ETC are installed properly) while installing it is not showing server componets and Report manager. It is just showing client components. Does'nt eval edit have reporting server. I dont know what to do at this ANY HELP Thanks in advance R.D Tag: How can I devide one column by another? Tag: 20072
  - 21
    - change the look of Report Manager I would like to change the look of the Report Manager. I have Reporting Services on both developement and production servers. I would like to be able to change the color or font etc. so that I can tell without having to look in the address box to figure out what server I am on. Is there a value I can change somewhere that will do this for me? Tag: How can I devide one column by another? Tag: 20071
  - 22
    - why install printing service must IIS why install printing service must IIS even i dont want use it in Web Tag: How can I devide one column by another? Tag: 20051
  - 23
    - SRS on WebHost.....URL Credentials Greetings, I have SRS on my Web Host......I would like to do the following: Get URL format to render report in BROWSER (would require adding credentials, which ones, data source or report server?) I would then want to put the SRS report in Sharepoint (also on Web Host), and deploy it as a Web part Page....I have managed to do this, but keep getting prompeted for credentials, thus the above question.... I will also post this on Sharepoint Site. Thanks in advance to all, Tom B Tag: How can I devide one column by another? Tag: 20050
  - 24
    - Introducing Microsoft Reporting Services Article The publisher of my book donated Chapter 1 of my book (Introducing Microsoft Reporting Services) to The Code Project website. It is available for free access here http://www.codeproject.com/books/MSReportingServices.asp?msg=1015597#xx1015597xx -- Enjoy it. --------------------------------------------- Teo Lachev, MVP [SQL Server], MCSD, MCT Author: "Microsoft Reporting Services in Action" Publisher website: http://www.manning.com/lachev Buy it from Amazon.com: http://shrinkster.com/eq Home page and blog: http://www.prologika.com/ --------------------------------------------- Tag: How can I devide one column by another? Tag: 20018
  - 25
    - Artice on RS Forms Authentication Just a quick note to let you know that DevX published part 1 of my two-part article about RS Forms Authentication. It is available for free access here http://www.devx.com/dotnet/Article/26759. "One of the most useful features of Microsoft Reporting Services is its extensibility model. Just about any aspect of Reporting Services can be custom-tailored to meet your specific requirements. Part one of this two-part series explains how to replace the default Windows-based security model of Reporting Services with forms authentication security. First, you'll learn the ropes of implementing forms authentication security and how you can leverage it for Web-based reporting. Then you'll enhance the form's authentication extension by adding role-membership features to simplify the security maintenance." Enjoy it! -- --------------------------------------------- Teo Lachev, MVP [SQL Server], MCSD, MCT Author: "Microsoft Reporting Services in Action" Publisher website: http://www.manning.com/lachev Buy it from Amazon.com: http://shrinkster.com/eq Home page and blog: http://www.prologika.com/ --------------------------------------------- Tag: How can I devide one column by another? Tag: 20016
- Next
  - 1
    - XML data reporting in SQL 2005 Hello, i am wondering if it would be possible to report against a deeply nested and complicated xml data structure stored in SQL 2005 without "flattening" the data first? We have not been able to do this in SQL 2000 because the reporting services are greared towards reporting against a relational style data (even if it's in XML format) Tag: How can I devide one column by another? Tag: 20013
  - 2
    - More than 3 groups, toggle items & page breaks G'Day, I have created a report that has 4 Groups in a Table (shown below), each with summary information displayed in other columns. The Detail row in the Table is not used and is set to hidden. - Office - Sign Up Month - Referrer Type - Referrer Name Each Group starts off as Hidden and the Toggle Item is linked to the Group directly above. When I preview the report to the screen I am presented with 4 Offices. Example: + Brisbane + Gold Coast + Melbourne + Sydney My issue is that Sydney is pushed onto a second page even though I only have 3 rows of data on the first page. If I remove the Referrer Name Group and put the Referrer Name data in the Detail row and unhide the Detail row, which means that I now have multiple referrer details displayed, the report will work fine!! That is, the 4 offices noted above all appear on one page when previewing the report to the screen. My deduction is that there is an issue with Reporting Services if you use Toggle Items and more than 3 Groups in a Table. Has anyone else come across this issue and have you found a way around it? Your response will be much appreciated. Tag: How can I devide one column by another? Tag: 20012
  - 3
    - End-user reporting? Hi - We are considering reporting tools - does MS Reporting Services have end-user report design capabilities? thx, Jan Tag: How can I devide one column by another? Tag: 20008
  - 4
    - Major difficulties deploying a custom data extension I have been trying for days to get a custmized data extension that I built using the example at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/RSDSetEx3.asp to be recognized by the report server on a Windows 2003 box. It is recognized and works well on my development machine. I have followed the recommended steps outlined below: 1) Create an entry in RSReportServer.config: <Extension Name="Dataset" Type="DataSetExtension.DSXConnection,RSCustomData"/> DatesetExtension.DSXConnection is the correct namespace (I customized it), RSCustomData.dll is the name of the assembly which has been placed in the following folder: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin 2) Create a new code group entry in rssrvpolicy.config. This potentially could be the source of the problem, as I have received conflicting recommendations on where in the code group heirarchy I should place the new entry. I am currently placing it under the "Url="$CodeGen$/*" entry 3) Restarted IIS and restarted SQLServer. Is there any reason why the PC should have to be restarted? When does RSReportServer.config and rssrvpolicy.config get loaded? I then created a web service client and called the ListExtensions method of the resportservice.asmx web service. It only lists the original 4 data extensions - SQL, OLEDB, ORACLE and ODBC. After dozends of attempts over several days and after reinstalling Reporting Services, I still am having no luck getting the data extension to be recognized on the server. Even though it works great on the dev machine and I can step through the code without a problem. Bonus question: One post mentioned the <securityPolicy> <trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" /> </securityPolicy> <trust level="RosettaSrv" originUrl="" /> entry in web.config as a potential source of the problem. Searches on google for RosettaSrv turn up almost nothing. Does this have any effect on giving permissions to custom assemblies? Thanks in advance for your help. Tag: How can I devide one column by another? Tag: 20006
  - 5
    - document mapping I have a report which has two items- chart and a matrix, both uses same datasets and produces same results. I want to give an option to user to choose between chart and matrix. I was thinking to use document mapping. But i can't create bookmarkID, or document map on chart or matrix name, it only gives option to use available fields from dataset. I end up using two dummy text box linking them to chart and matrix having chart and matrix hidden initially. I don't like this. Is there any other option? Thanks vipul Tag: How can I devide one column by another? Tag: 20000
  - 6
    - Parameters in url to make GIF question. What parameter can I send from my app that will render the report and then instantly convert it into a .GIF file? thanks, Trint Tag: How can I devide one column by another? Tag: 19998
  - 7
    - How can I add a page footer? thanks, Trint Tag: How can I devide one column by another? Tag: 19996
  - 8
    - Stored Procedures? Does anyone know if you can you call a stored procedure and pass in parameters collected within Report Services? -- Thanks in Advance, John Tag: How can I devide one column by another? Tag: 19994
  - 9
    - Form Auth on the ReportServer web - Image doesn't show I have an interesting issue. I setup my RS to use Forms Auth. I created a logon page for the Reports and ReportServer webs. The page displays a company logo, textboxes to enter credentials, logon button, etc. Nothing extremely fancy. The issue is this. When I navigate to the Reports web (Report Manager) the logon page displays correctly - then logo shows. When I navigate to the ReportServer web, the image doesn't show. Just the labels, textboxes, and logon button. What gives? -- Adrian Maull [MCP] Tag: How can I devide one column by another? Tag: 19993
  - 10
    - DateTime parameter without time part There is a post that tells how to do this: >>Use =Today() and set the field format to d but where do you set the field format of a parameter? -- Michael White Programmer/Analyst Marion County, OR Tag: How can I devide one column by another? Tag: 19991
  - 11
    - Resources not displaying in Windows Server 2003 Hello, Our application does retrieve reports as HTML via the Web Service using the Render method. Alongside the tags, this method returns a list of resources, which we manage to retrieve at a later time using RenderStream method. Those images are then stored in an application folder and made available for web users to see in Internet Explorer. It all works fine using XP/IIS5/IE v6.0.2900.2180. However, we have a problem with another configuration. If the server is located on Windows Server 2003, which is using IIS6 and IE6 v6.0.3790.0, the images simply do not want to display. After much investigation, we still do not know if IIS6 refuses to send the images or if it is the obscure build of IE6 that do not recognize them. One thing is certain, they do not display at all. I bet a lot of people may use the Reporting Services / Windows Server 2003 configuration... So, is this a known bug or a misuse of our part? Thanks! Marc Lacoursiere, CGI Tag: How can I devide one column by another? Tag: 19989
  - 12
    - Visual Studio .NET for Reporting Services We have installed and are currently starting to evaluate Reporting Services. I was just wondering if anyone could tell me if it matters which edition (Enterprise Edition, Professional Edition, or Developers edition) of Visual Studio you use for development purposes? Any assistance would be appreciated. Tag: How can I devide one column by another? Tag: 19987
  - 13
    - Problem with fonts and layout size in printer delivery We have problem as described in this post http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/46330b053c09f424/c93c870d44534209?q=emf+print&_done=%2Fgroup%2Fmicrosoft.public.sqlserver.reportingsvcs%2Fsearch%3Fgroup%3Dmicrosoft.public.sqlserver.reportingsvcs%26q%3Demf+print%26qt_g%3D1%26searchnow%3DSearch+this+group%26&_doneTitle=Back+to+Search&&d Printer delivery works and when we print on our site (on WinXP) report is printed OK; fonts, pictures and margins are OK. When we use same printer delivery extension on customer's site (Win2k3 server) print output is not correct. Report is wider and longer then it should be. We are using same report object on both installation and URL generated report with EMF rendering output produces same result. It seems that something goes wrong after printer delivery prints EMF file on network printer. Any hints !? Tag: How can I devide one column by another? Tag: 19986
  - 14
    - Install Issue - "IIS is either not installed or not configured for a server component installation" I'm getting this error: "IIS is either not installed or not configured for a server component installation" when attempting to install Reporting Services on W2K Server SP4 Configuration details: Windows Server 2000 5.00.2195 SP4 IIS is installed (Control Panel Add/Remove components confirms this) Default web site is present Default server IWAM account is active Default web site IP is mapped to (All Unassigned) The web server is functional, as it is hosting another .Net web application already. I can't seem to find any useful info on this error on the web. Any suggestions appreciated Tag: How can I devide one column by another? Tag: 19982
  - 15
    - Filters Top 5 showing more than 5 if a tie I have a filter with the top 5, and if I have 10 items with the same top value, it will show all 10. Is there anyway to cut this off show it just shows 5? Tag: How can I devide one column by another? Tag: 19980
  - 16
    - TIP: How to Search the Newsgroup and Get Answers Fast I will be unavailable for 3-4 weeks, so I'm leaving a powerful suggestion. Many of the questions asked are repeats of earlier questions. So here's how to find previous posts in the Reporting Services newsgroup using Google: http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs (I have this bookmarked, and it's where I go FIRST for RS answers. Why? Google is fast.) On this page, use the "Search this group" button on the top right. I'm sure Google will change the link when the their groups beta is done, but it should be easy to find. If you have an error message, it's usually best to search on the actual error text; if it's about something to do with code, search on a method name. Pay attention to the vocabulary used on the newsgroup, and details like singular or plural words when you search. Careful selection of search terms can usually produce an answer or decent opinion in a matter of seconds. Cheers, '(' Jeff A. Stucker \ Business Intelligence www.criadvantage.com -------------------------------------- Tag: How can I devide one column by another? Tag: 19970
  - 17
    - Netscape problem In IE report run is OK but when I open report in Netscape 7.1/7.2 page icon on tool bar are disabled and export file type dropdown displays items but clicking link next to dropdown does not take any action. Please suggest what I need to fix Thank you Tag: How can I devide one column by another? Tag: 19967
  - 18
    - XML Import I want to use an XML file as a data souce. Can I do that in Report Services? How do I connect? Tag: How can I devide one column by another? Tag: 19965
  - 19
    - Excel Export Garbeled When I export to excel... the reprot is garbeled 100% of the time... even with sample reports. My client is using Excel 2000. Is that a problem? Tag: How can I devide one column by another? Tag: 19964
  - 20
    - Excel export is garbeled When I try to export to excel... I get a bunch of garbage...100% of the time... even with the sample reports Tag: How can I devide one column by another? Tag: 19963
  - 21
    - How To Restrict Report Rendering In URL Access Hi there Does anyone knows how to limit user ability to export report to CSF and Excel. I know I can edit config file, but this will affect entier site. I need to do it for one report only. Thank you Tag: How can I devide one column by another? Tag: 19956
  - 22
    - Table, position and size Hello, in order to force a table to continue on a next page, is it possible to force a table to have a fixed size in height ?? How ?? Is it possible to force it to display records by a constant step ?? How ?? Is it possible to give an absolute position to a control ?? How ?? Tag: How can I devide one column by another? Tag: 19955
  - 23
    - Search/Find Box in a report I know that there is a find function available when viewing a report using Report Manager, but when i export my report as html w/ web components that feature dissapears. What can i do either keep that feature, or have a search box in the report? thanks -- -------------------------------------------- Yes, I searched first :) Tag: How can I devide one column by another? Tag: 19953
  - 24
    - Report Parameter Selection aid fir user. Hi, Am curious, have a report paramater the user selects from a pull down list that is smart enough to go to the record containing the first letter the user types in. Is there any more intelligence we can add to this ? For example expanding the record selection to perhaps two or three characters the user types in. Thanks, Steve. Tag: How can I devide one column by another? Tag: 19951
  - 25
    - Fields in charting Hi, I am working on some charts and I am using the following code: CREATE TABLE #Temp1 (themonth varchar(12), theyear varchar(12), averagedaystofilltotal float, averagefillratetotal float, delaytimetotal float, responsetimelagtotal float) INSERT INTO #Temp1(themonth, theyear, averagedaystofilltotal, averagefillratetotal, delaytimetotal, responsetimelagtotal) EXEC rptStatsGraphicalYEARoverYear @Location, @FromDate, @ToDate Create table #Temp2(averagedaystofilltarget float, averagefillratetarget float, responsetimelagtarget float) INSERT INTO #Temp2(averagedaystofilltarget, averagefillratetarget, responsetimelagtarget) EXEC Test1 SELECT * FROM #Temp1 Select * from #Temp2 drop table #Temp1 drop table #Temp2 How can I make it so that the fields in the chart correspond to both select statements? Right now I am either getting the fields from the first select statement or the second but not both, how can I make this work? Thanks Tag: How can I devide one column by another? Tag: 19946

How can I divide one column by another in a "detail" row?

RE: How can I devide one column by another? by Mardy

Mardy
Mon Jan 17 20:29:04 CST 2005

In a separate column in the detail row, right click to create an
expression.In the Expression dialogue box, create an expression like this =
col1.value/col2.value Should be fairly straight forward. you can pick the
column names from the pick lists to the left of the Expression dialog box..

"trint" wrote:

> How can I divide one column by another in a "detail" row?
>
>

Top