Email connection setup

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
    - ***** Deployment error: Connection closed ****** c:\Report1.rdl The underlying connection was closed: An unexpected error occurred on a send. When i deploy I get this error sometimes. It gets resolved on its own. Its like a hit and trial thing, sometimes it runs, sometimes it doesnt. Wonder what am I doing wrong? Thanks Tag: Email connection setup Tag: 10424
  - 2
    - Deserialization failed: File or assembly name Microsoft.ReportingServices.Interfaces not found Hello, I just installed Vault Source Control on my machine. 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." If I open another instance of the MSIDE without Vault (locally) and open a different RDL it works fine. Is this an issue with the source control or with the way it opens the file? Any help will be appreciated. Need to get this solved. Ponnu Tag: Email connection setup Tag: 10423
  - 3
    - Converting Date-Time to Date Conundrum I need to be able to convert a Date-Time Field to a Date Fied in my SQL Tables. Using CONVERT (varchar, "Date-Time Field", 103) gives me the correct result but because it converts the date value to a string I can say goodbye to localization..... any ideas on how to convert the field but still allow localization. Tag: Email connection setup Tag: 10422
  - 4
    - Forms authentication error. Can't log on, server error I'm running Reporting Services using the forms authentication sample but after a period of time I can't log into the login.aspx form for the site at: http://[servername]/reports unless I change the URL to http://[servername]/reportserver then once I am logged in can change the suffix to 'reports' the error message I get on the server through eventviewer is: Failed to CoGetClassObject for provider "ReportingServicesWMI". Error code 0x800703E6 was returned. anyone any idea what this means or what the cause might be? (I'm running reporting services SP1 on Windows 2000 Server) Tag: Email connection setup Tag: 10421
  - 5
    - initially the load of the default page takes to long. To All, I have looked all over to get an answer to the following: I have installed Reporting Services with the latest service pack. When I or any of my customers try to initially load the default page (http://localhost/reports/Pages/Folder.aspx) it will take 20-30 seconds. After the initial load it is fine. The next day when we try to access it again, it takes 20-30 seconds again. I have seen two people ask the same question on the newsgroups with no answers. Some may feel this is not a big deal, but I am moving from one reporting service to "Reporting Services" and the less issues my customers have the easier it will be for me to sell this. If I could get this corrected it would be great, but if I can not, I would at least like a logical reason why this occurs. Also Is there an equivalent function in RS to Crystal's "Next" command I am converting a report from Crystal to Reporting Services and I need the ability to look ahead by one row (the Next command in Crystal) and use this data from the result set to perform certain calculation. If there is not a similar command is there a way to do this short of creating a temp table and using a cursor??? Thanks, Tom Tag: Email connection setup Tag: 10420
  - 6
    - Reporting Services initial page load takes to long. I have looked all over to get an answer to the following: I have installed Reporting Services with the latest service pack. When I or any of my customers try to initially load the default page (http://localhost/reports/Pages/Folder.aspx) it will take 20-30 seconds. After the initial load it is fine. The next day when we try to access it again, it takes 20-30 seconds again. I have seen two people ask the same question on the newsgroups with no answers. Some may feel this is not a big deal, but I am moving from one reporting service to "Reporting Services" and the less issues my customers have the easier it will be for me to sell this. If I could get this corrected it would be great, but if I can not, I would at least like a logical reason why this occurs. Also Is there an equivalent function in RS to Crystal's "Next" command I am converting a report from Crystal to Reporting Services and I need the ability to look ahead by one row (the Next command in Crystal) and use this data from the result set to perform certain calculation. If there is not a similar command is there a way to do this short of creating a temp table and using a cursor??? Thanks, Tom Tag: Email connection setup Tag: 10416
  - 7
    - Database connection problem Hi, We have two SQL servers. To generate reports, we need to go to both servers to collect data. The reporting service is installed in server 1. The database connection b/t server 1 and reporting service is fine. However, we couldn't create connection to server 2. When I ran a report that the data is retrieved from server 2 and Data source is referred to server 2, I always got the error: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'ds2'. (rsErrorOpeningConnection) Get Online Help SQL Server does not exist or access denied. I am just wondering if the reporting services only can connect to the server where it is hosted or it can connect to different servers? How can I create the connection b/t reporting services and Server 2. (Of course, I configured the Data Sources from Properties.) Thanks for your help!!! Tag: Email connection setup Tag: 10411
  - 8
    - Dates parameters I create a report that brings information from an informix database. I have a problem with date parameters when I put them static on query design (with date format mm/dd/yyyy) it retreives information on a good response time. But if I preview report with the option to add date paramaters reports doesn't display information it always says "Processing report". I think that the problem is that SQL adds the time to parameter because if I add time to date value on design mode it sends an error. Please let me know if you have comments I will appreciate it thanks Tag: Email connection setup Tag: 10405
  - 9
    - XML DataSet Data Extension - datasource & coding I know this question has been asked a zillion times and will be asked again and again but here are some of my outstanding concerns after spending almost half a day browsing this group for answers. I read and followed and deployed the extension available in the September 2004 article in MSDN on Implementing and deploying / using a DataSet data extension. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/rsdsetex3.asp In my report project, while creating a datasource, I can see the DataSet provider in the list. I specified no credentials. And saved it. While creating a new report I used that dataset and when i clicked Next it gave me an error saying "A connection cannot be made to the database. Set and check the connection string." this is my first issue and i hope someone can help me out. Now I read in some posts (and the article in MSDN i followed) once i can get to the next screen I can specify the xml which will load the designer the very first time. Subsequently i will have to write the code in the my aspx.cs page to pass a custom dataset which i programmatically create, to the report. Can someone point me to a little sample that does this dataset or xml passing to the report via VB.net / C# code? If there is anything else that i may be missing, i'd greatly appreciate your suggestions. Thanks & regards Gary Tag: Email connection setup Tag: 10404
  - 10
    - RS Web Service to programmatically render reports Hello, when I call the render method of a ReportService() object with the following... data = rs.Render("/OnlineInvoice", "PDF", Nothing, Nothing, paramaters, Nothing, Nothing, encoding, mimeType, parametersUsed, warnings, streamIds) with the argument paramaters being... Dim paramaters(2) As ParameterValue paramaters(0) = New ParameterValue paramaters(0).Name = "P_ClientID" paramaters(0).Value = 815 paramaters(1) = New ParameterValue paramaters(1).Name = "P_InvoiceID" paramaters(1).Value = 22230 I get the error... System.Web.Services.Protocols.SoapException: The value of parameter 'Parameters' is not valid. Check the documentation for information about valid values. --> The value of parameter 'Parameters' is not valid. Any Ideas? thank you for the help! -- Tag: Email connection setup Tag: 10398
  - 11
    - wrong email address in subscription Hi all, I have an Email Subscription for a report that includes several email addresses. If even one of the email addresses is wrong or misspelled, noone gets an email. Is there a way to send email to other email addresses when some of the email addresses are wrong? I knwo I can create different subscription for each email address. But we don't want to do that. Thanks... -Nikhil Tag: Email connection setup Tag: 10396
  - 12
    - RS communication with SQL Server Hallo, I have a question about the communications between Reporting Server and SQL server works, when using the drill down funtion: Does the RS requests all the data from the SQL Server at the first time the client opens the report (not expanded in the first step), or not? If the user does a drill down now, how does it work in the backend: a.) client - RS - client [a lot of data allready stored in RS] b.) client - RS - SQL Server - RS - Client [every request from the user needs a communication between RS and SQL Server] Thanks for your help! Best regards, Dietmar Tag: Email connection setup Tag: 10394
  - 13
    - 3 Matrix Questions I created a matrix where the Data box is a SUM of employee daily hours grouped by week. I then created a drill down on week that will break the sum into the daily hours for that week. 1 - If I assign conditional formatting to the SUM, when I drill down to the daily hours, it keeps the same conditional formatting as the SUM. How can I prevent this? 2 - When I drill down to see the daily hours, my SUM disappears. How can I see the drill down and keep the SUM at the same time? 3 - I'd like to be able to see the composition of the SUM using a tool tip. My problem is that I don't know how to call each day of the week. Id like my tool tip to look like this when I hover over the sum. ------------------------- Daily Hours Monday - 8 hrs Tuesday - 7.5 hrs Wednesday - 8.3 hrs Thursday - 9 hrs Friday - 6 hrs ------------------------- How can this be accomplished? Now I've seen that some answers come in the form of an RDL file instead on instructions... How can I view that RDL file? I've tried creating a new project and then adding the RDL file to it but I get a deserialization error. Tag: Email connection setup Tag: 10391
  - 14
    - CSV Exporting Hi All, I have a report with 2 tables and one matrix in between them. As you know the number of columns in the tables is static and number of columns in the matrix is calculated dynamically. When RS export the report in CSV format, total column is calculated as Number of columns in Table1+No of columns in Matrix + No of columns in Table2. Table1 contains 10 rows and Matrix contains 2 rows and Table2 contains 5 rows. Since the matrix does not contain 3rd row, the table2 columns are coming in the place of matrix columns and empty commas that are suppose to be added immediately after the Table1 columns is added at the end. Is it a bug in RS? Or Shall I have to set any option? TIA, Samuel Tag: Email connection setup Tag: 10389
  - 15
    - Displaying report parameters in report header or body Hi, I like to see in the generated report what the parameters value are for the current report like startdate and enddate Thanx Wimmo Tag: Email connection setup Tag: 10387
  - 16
    - Multi-line export to Excel Hi, One of our reports has a table with multilpe-lines. separated by cr/lf combinations Everything is OK, except the export to Excel gives additional lines.Anything that can be done about this? (like tweaking the cr/lf's) thanks, Dick Tag: Email connection setup Tag: 10386
  - 17
    - Reporting Services with SQL Server Express. Can we design reports using Reporting Services with SQL Server Express? Tag: Email connection setup Tag: 10385
  - 18
    - Size pdf-export The export of pdf-files from RS that include images, generates files that are much larger than if I generate from other applications. An example is a report that contains 5 images that get the size of 7.5MB from RS in relation to 2.5 MB from other applications. I have tried different image-types, but I got the same result in RS. Anyone who have the same problem? Any solution? Tag: Email connection setup Tag: 10383
  - 19
    - Does RS 2000 work with Visual Studio 2005 express? Hi, I want to try an evaluation version of Reporting Services 2000, but it requires Visual Studio 2003 which I don't have. I don't see an evaluation version of Visual Studio 2003 anywhere, but a free download of Visual Studio 2005 Express is available. Will Reporting Services 2000 work if I install Visual Studio 2005 Express instead of Visual Studio 2003? Thanks, Evert Tag: Email connection setup Tag: 10382
  - 20
    - Key not valid for use in specified state Hi! On thursday last week one of our clients Reporting Services installation stopped working and reports "Key not valid for use in specified state" error message in the log files. This is strange as we have not done any changes to the server. It is running Windows Server 2003 Standard Editon with SQL Server 2000 Std Ed... Anyone got similar problems or know what could cause this behaviour? I have tried reinstalling the encryption keys and finally removing and reinstalling the complete Reporting Services but the same error is logged and the service doesn't work. Best regards, Per Salmi Tag: Email connection setup Tag: 10381
  - 21
    - licensing ACTUAL PROCEDURE hi all, i have read through the FAQ of Reporting service,which talk about the lincensing senerio....., but what EXACLTY i have to do to register the reporting service? thanks in advance Jason Tag: Email connection setup Tag: 10380
  - 22
    - page navigation in preview tab Hi, since i installed SP1 I cannot browse through the pages in the Preview tab. The preview shows only one page and there is no page footer. Most probably its displaying all the results in one page but cutting through at some point. Can i fix this? Tag: Email connection setup Tag: 10378
  - 23
    - Static & Dynamic Columns in One Matrix? I am trying to create a Matrix that contains two static columns followed by x number of dynamic columns. Ex. (x, y and z just fill in space and are not relavent to my problem) staticCol1 staticCol2 dynamicCol1 dynamicCol2 ... row1 x x x x row2 y y y y row3 z z z z Is this possible? I can get the following, but this is not what I want. dynamicCol1 dynamicCol2 staticCol1 staticCol2 staticCol1 staticCol2 row1 x x x x row2 y y y y row3 z z z z I realize that I could change my sql to always return the static data as rows in the result set appended to the dynamic data but that is not what I want to do. Can someone please help? Thanks. Tag: Email connection setup Tag: 10376
  - 24
    - How to include a dataset field value in the header Since I can not directly use a field value of a dataset in the header and footer section of a report, I'm trying to store this field value in a variable in the custom code. Is there a way to do this? Thanks... Tag: Email connection setup Tag: 10373
  - 25
    - Repeating data on every page's header My report has 9 subreports. When main report has 3 records then this report goes into loop and run these 9 subreports 3 times. But I want the heading in all the pages and should change the data as record changes.. This report can be 30 - 40 pages long. I am giving you an example on my report. Suppose I want to show the detail of 3 staffs. A, B and C In heading, I want to show the name, age and gender of staff which will change on next record. In detail, In 1st subreport shows the brothers of the staff and 2nd subreport shows the sisters of that staff etc. I want to show the heading in all the page. Thanks Tag: Email connection setup Tag: 10372
- Next
  - 1
    - I need help to capture information of names and directories of Rep Would I like to know how to do the same dear type folder that presents in the Administration of RS, but could I manipulate the data configuring the screen? Type removing buttons, increasing illustrations in short showing for the user a new screen. aspx Tag: Email connection setup Tag: 10368
  - 2
    - Need VB.NET code to generate snapshot reports automatically I need to generate hundreds of snapshot reports, which would be refreshed every night. Each employee would view a snapshot report pertaining to his employee number (which is the parameter in the report). The employee is not allowed to look at anyone else's report, and the company doesn't want employees to be refreshing reports all day long. So, here's what I need: 1. VB.NET code that calls the Reporting Services web service to generate a linked snapshot report for each employee report and every employee number (for the employee parameter) in my SQL database 2. Code to automatically schedule these snapshots for a nightly run using a shared scheduled execution time 3. A way to name each linked snapshot report using some kind of naming convention (e.g. "Employee Report - Employee 100", "Employee Report - Employee 205", etc.) Can anyone help? Does anyone have any sample VB.NET code to share? Tag: Email connection setup Tag: 10365
  - 3
    - Need VB.NET code to generate snapshot reports automatically I need to generate hundreds of snapshot reports, which would be refreshed every night. Each employee would view a snapshot report pertaining to his employee number (which is the parameter in the report). The employee is not allowed to look at anyone else's report, and the company doesn't want employees to be refreshing reports all day long. So, here's what I need: 1. VB.NET code that calls the Reporting Services web service to generate a linked snapshot report for each employee report and every employee number (for the employee parameter) in my SQL database 2. Code to automatically schedule these snapshots for a nightly run using a shared scheduled execution time 3. A way to name each linked snapshot report using some kind of naming convention (e.g. "Employee Report - Employee 100", "Employee Report - Employee 205", etc.) Can anyone help? Does anyone have any sample VB.NET code to share? Tag: Email connection setup Tag: 10364
  - 4
    - RSExplorer Example I try to modify the RSExplorer example by using form authentication. I have create a window logon form. Could anyone can help me how to integrate form authentication and the sample together ??? Actually I don't know how the report server can regonize the logon user. Thanks Tag: Email connection setup Tag: 10363
  - 5
    - Custom authorization on a particular report Hi, I have created a report that displays order summaries based on a parameter CustomerName. I have many customers and want to give them all access to this report. I've installed the Forms Authentication sample and am able to authenticate, so each customer has a login. The problem is that I want each customer to be able to view only his own order summary (i.e. the CustomerName parameter to the report must be set to the customer's login id and he cannot change it). Is there a way to pass the username given in Forms Authentication to the report? Passing it in the URL is no good because users can modify the URL. The authorization pieces in the Forms Authentication sample seem only to grant or deny access on to a particular report, but not on parameters to the report. Any tips would be greatly appreciated. Thanks, Don Tag: Email connection setup Tag: 10362
  - 6
    - Is it ready? My CIO bought and is pushing for me to deploy Hyperion Performance suite reporting as the enterprise reporting tool... I farking hate it... Is MS SQL Reporting services mature enought to be relied on for enterprise wide reporting? I am risking my job on this fight... thanks ken Tag: Email connection setup Tag: 10361
  - 7
    - Generic Query Designer quotations I am trying to use the generic query designer so that I can add dynamic parameters. My problem is that my query contains double quotes already, ie: SELECT PRODUCTION_DATE, TESTDATE, "524CLPRXD1_CONS", "524ALPRXD1_BRITE", "524ALPRXD1_PH", "524ALPRXD1_COND", "524TLPRXD1_TEMP", "524CLPRXD2_CONS", "524ALPRXD2_BRITE", "524ALPRXD2_PH", "524ALPRXD2_COND", "524TLPRXD2_TEMP", "524CLPRXD3_CONS", "524ALPRXD3_BRITE", "524ALPRXD3_PH", "524ALPRXD3_COND", "524TLPRXD3_TEMP", "615CLKRAFT_CONS", "615ALKRAFT_TEMP", "615ALKRAFT_BRITE", "565ALPOTWR_CSF", "565CLPOTWR_CONS", "565CLWW11_CONS", "524ALTMPSS_COND", "565ALPRTWR_BRITE", "524ALTMP11_CSF", "524CLTMP11_CONS", "524ALTMP11_BRITE", "524ALTMP11_PH", "524ALTMP11_COND", "524TLTMP11_TEMP", "631ALTMP_CSF", "631CLTMP_CONS", "631ALTMP_BRITE" FROM GP4_LAB How would I put this into the generic query designer, because when I try to do it, I get an error "End of statement expected". Tag: Email connection setup Tag: 10360
  - 8
    - Using Today and Yesterday in subscription I have a report where I have a date parameter, with two non-queried available values. One is Today, which has a value of =Today(), the other is Yesterday, which has a value of =Today.AddDays(-1). Both work in the designer perfectly. However, when I deploy the report and try to set up a subscription, I get an error that says that I can't use a User-Defined parameter values. How do I go about correcting this? Tag: Email connection setup Tag: 10359
  - 9
    - Wiki for Reporting Services? I googled around a bit today and couldn't find anyone with a wiki for Reporting Services. Has anyone considering putting one up? I think it could be very handy - a place for the community to contribute tips, bits of code, etc. It could also serve as a home for an up-to-date FAQ. (Some questions get asked over and over again on the newsgroup...some with good answers / solutions, some without) I may go ahead and host one myself if no one else is already in the process of putting one up. Of course, it could be I'm the only developer using R.S. who likes wikis! ;) -BA Tag: Email connection setup Tag: 10358
  - 10
    - Display SQL server Image fields in reporting services headers or footers I know you cannot directly place data fields in the headers or footers with SQL server reporting services. You can trick it by putting a hidden text field in the body of the report and referencing it in the header or footer by using ReportItems. How do you display SQL server Image data fields in headers or footers? I tried using Report parameters, but that caused unpredictable results with my text fields. Report parameters don't have an option for Image fields for the data type which makes sense. Appreciate your help. Tag: Email connection setup Tag: 10356
  - 11
    - Controling language of returned schedule description Hi! When I GetScheduleProperties, I would like to control the language of the returned schedule description. Any thoughts on how I might accomplish this? The language of this schedule description changes when I use Report Manager, so there must be a way to accomplish this. Thanks in advance for any enlightenment, Bob Tag: Email connection setup Tag: 10352
  - 12
    - I sent you an image of it<eom> Tag: Email connection setup Tag: 10347
  - 13
    - Form Authentication in reportingservices and timeout Hi, I have an web application that uses reporting services. Once the user signs in the user is automatically singed in to reporting services.I have enabled Forms authentication for my reporting services. Everything seems to be working fine. The current timeout for the reportingservices is 60 min. When the user uses the application for more that 60 minutes and tries to access reports, the report server say the authticket is not valid. How do I renew the login for the sqlserver after I logon. I want maintain the validity of the login to the report server as long the user is logged in to my application. I tried setting the expiration for the cookie returned by the reportserver. But that is not helping. Thanks in advance, j_a5 Tag: Email connection setup Tag: 10345
  - 14
    - Parameter Bar Style I would like to hide the top part of the report viewer ( the section withthe tabs) and change the color of the bar that has the parameters and the "view report" button I seems that the Style sheet only affects the upper section ( the one I want to hide ) TIA Ray -- Illusion is the first of all pleasures. Tag: Email connection setup Tag: 10340
  - 15
    - Web Service API - Parameter Value Hi all, I want to set parameter's value for the report using web service. I am not using URL access method to access reports. I am working on simple report which gives list of airlines. I have to pass airline range scope and from and to value, which i will get from user. I badly need some code in vb.net using web service API about how to set values for this parameters from code itself. Report has no valid values, no default values. Thank you for your help. Tag: Email connection setup Tag: 10339
  - 16
    - Database Memory Hi, I'm wondering, is there any option/tool that could let me monitor a database's memory. There's a maximum amount that we can allow, and it would be nice to have some kind of alarm/warning message that would tell us we're at our maximum, or close to it. Thank you kindly. Marc Tag: Email connection setup Tag: 10338
  - 17
    - Subreport Size How would I manage the height of a subreport from a master report so that no matter how many records are returned, the subreport would only take up (n) height? I have created a data source that limits the # of records that are returned, although sometimes I get rows that are pushed due to linebreaks in text which is fine, but it creates a new page which I do not want. I'd rather take the rows I can see on the one page and chop or not display the remaining records. Any Ideas on a solution? Tag: Email connection setup Tag: 10335
  - 18
    - Authentication Question Hello, I want to setup authentication so that if any requests come from a certain ip address they are automattically accepted. Is there an easy way to do this or is using some kind of custom extension using forms the only way? Thanks, David Tag: Email connection setup Tag: 10332
  - 19
    - General questions I am evaluating reporting software for website very high web traffic. I love the fact that I can create the same report in different formats. RS seems like a great choice. But I have 2 questions which I can't figure out how to accomplish this. Does anyone know an answer? 1) I need to embed html check boxes in detail lines on a report. The idea is that the user checks the boxes on each detail line where he want to know more information, then after he clicks the "submit" button, a javascript function determines which check boxes were are checked. 2) Can you embed the same report multiple times on a page. For example, let's say I created a report with information relating to an apartment rental. If there are 10 appartment rentals, I want to list all 10 reports in the same browser. This way, the user can quickly view all the appartment rentals in one glance. If these features are not available, then will they be available with the next SQL Server 2005? Thank you for your help in answering these questions! SteveS Tag: Email connection setup Tag: 10328
  - 20
    - PDF export I have a main report with 2 subreports as the only items in a list control. I am linking the 2 reports to a field in the dataset of the main report. When I view the report from the report manager or just from the report URL it looks fine. When I export to PDF the first page is blank. The 2nd page and all other pages are fine, but the data from the first page just isn't there. The data on the 2nd page is supposed to be the 2nd page so it's just the first page that is not showing up. Has anyone else seen this and have an idea of how to correct it? Tag: Email connection setup Tag: 10322
  - 21
    - is this scenario possible? I want be able to have one xml file that is an .rdl xml file that contains the snapshot data and all the report formating and query information. Is this approach supported? Could some one send me a link to a sample xml file that contains both the report definition and the snapshot data? I need to be able to deliver an interactive report with the snapshot data and the ability to refresh on demand - but not connect to the server unless the request to refresh is made. We already have a viewer/render for other types of xml files.. thanks in advance, willp Tag: Email connection setup Tag: 10320
  - 22
    - Chart Max/Min highlighting I'm trying to add expressions that will highlight the highest/lowest values on a chart, but I'm having some difficulty. It's a simple bar chart showing total charges by customer. In an interesting twist, as I was writing this post VS.NET has screwed up my project, I get a 'object reference not set to an instance of an object error' when I double-click on a chart, or try adding a new one, so I'm writing from memory. Category Field : Customer Data Field : total_charge The chart displays a bar for each company, plotting the sum of total_charge's for each company. I would like to write an expression which can conditionally format the highest/lowest value on the chart, which would seem to me to be a fairly straightforward exercise (and a time-saver as the chart control has done the grunt work for you), but I can't seem to be able to do it. The only way I see of doing this is to create a new dataset/filter to calculate to the sum/maximum sum for each customer. I would have thought you could programmatically access the data the chart is displaying, but so far I've found little/no documentation on the subject. I hope this makes sense, any help would be appreciated. Tag: Email connection setup Tag: 10313
  - 23
    - Problem with Reporting Server Security. I can not have the correct permissions. Hi, I'm trying to configure the RS's Security. i 've created two rules, one rule for administrators and the other one for IUSR_machine. I connect to Windows 2000 server as administrator. The problem is that when i access the Report Administrator via URL, it applies the rules of the IUSR_machine, so i can't make administrator tasks. ¿Why does the Report Administrator think that I am an IUSR_machine user, and how can I connect as administrator? Please, anybody can help me, thanks in advance. Oliver. Tag: Email connection setup Tag: 10311
  - 24
    - URL parameters Hi ! I've some parameters on my reports,and i want to filter my report on loading For example, i want to create reports for articles, i have 1 parameter => @Article Can I use the URL to get this parameter like this http://myserver/ReportServer?/Example/Report1&Article=2344 Is it possible ? and How ? Thanks in advance Alex Tag: Email connection setup Tag: 10308
  - 25
    - Generate report using XML as data source Hi How can I generate report using XML file as Datasource? And I need to pass XML Filename dynamically at run-time.. -- Thanks in advance Bhavesh Tag: Email connection setup Tag: 10306

Hi,

Top