hardcoding password instead of showing password box everytime

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
    - question about transfering Access stuff into RS Hi, I'm new to Reporting Services: 1) First a question: what's the difference between Views and Stored Procedures? I am rewriting an Access Database to take it into RS....in there, I have 4 tables, 1 query and a report that depends on that query. 2) I need to make a new project in RS. The report wizard has asked me to Design the Query. Since I am rewriting my Access Database, I already have the following query from Microsoft Access. But it doesn't work in RS. I get errors. The errors are the following: 1) There's an error in the query. Line 2. Incorrect Syntax near '=3D' 2) Line 39. Incorrect syntax near 'DateConvert' The query is below. Please kindly help!!! SELECT Departments.Department, DESKS.Desk_ID, DESKS.Description, TRACE.TicketNumber, TRACE.Ticker, TRACE.Cusip, TRACE.Trace, TRACE.BuySell, IIf([Amount_Ind]=3D0,[Amount], IIf([Amount_Ind]=3D1,([Amount]/1=AD0), IIf([Amount_Ind]=3D2,([Amount]/1=AD00), IIf([Amount_Ind]=3D3,([Amount]/1=AD000), IIf([Amount_Ind]=3D4,([Amount]/1=AD0000), IIf([Amount_Ind]=3D5,([Amount]/1=AD00000), IIf([Amount_Ind]=3D6,([Amount]/1=AD000000),"PLEASE CHECK"))))))) AS Quantity, IIf([Price_Ind]=3D0,[Price], IIf([Price_Ind]=3D1,([Price]/10)=AD, IIf([Price_Ind]=3D2,([Price]/100=AD), IIf([Price_Ind]=3D3,([Price]/100=AD0), IIf([Price_Ind]=3D4,([Price]/100=AD00), IIf([Price_Ind]=3D5,([Price]/100=AD000), IIf([Price_Ind]=3D6,([Price]/100=AD0000), IIf([Price_Ind]=3D7,([Price]/100=AD00000), IIf([Price_Ind]=3D8,([Price]/100=AD00000),99999))))))))) AS Price2, DateConvert([Date]) AS Date2, TRACE.Time, TRACE.AsOfTime, DateConvert([AsOfDate]) AS AsOfDate2, TRACE.CustomerAccount, TRACE.DFA_BrokerCode, TRACE.Status, TRACE.ConfirmNumber, TRACE.RejectMessage, TRACE.RecType, TRADE_TYPE.Description, IIf(TRACE.RecType=3D"XTT",1.5,0) AS [Canceled Trade Fee], IIf(TRACE.RecType=3D"CTT",1.5,0) AS Corrections, IIf(TRACE.RecType=3D"PXT",3, IIf(TRACE.RecType=3D"PCT",3, IIf(TRACE.Date>TRACE.AsOfDate,=AD3,0))) AS [Late As Of Rpt Fee], IIf([Quantity]<201000,0.475, IIf([Quantity]<1000000,[Quanti=ADty]*0.000002375,2.375)) AS [Trade Report Fee], [Canceled Trade Fee]+[Corrections]+[Late As Of Rpt Fee]+[Trade Report Fee] AS [Total Trace Fee] FROM TRADE_TYPE INNER JOIN ((Departments RIGHT JOIN DESKS ON Departments.Department =3D DESKS.Department) RIGHT JOIN TRACE ON DESKS.Bloomber_Desk_ID =3D TRACE.Trader) ON TRADE_TYPE.RecType =3D TRACE.RecType WHERE (((DateConvert([Date]))>#2/28/=AD2005# And (DateConvert([Date]))<#4/1/200=AD5#) AND ((TRACE.ConfirmNumber) Is Not Null))=20 WITH OWNERACCESS OPTION; Tag: hardcoding password instead of showing password box everytime Tag: 30493
  - 2
    - Cannot add web parts to new page I have a WSS site that we have been using for many months (multiple pages, multiple sub-sites). Today I added a new page to the site (Modify This Workspace->Add Pages). The page appeared OK, but when I attempt to add a web part to the page I get this error in the web part pane... "The Web Part you attempted to add no longer exists in the Web Part Page Gellery. It may have already been added to the Web Part Page. Refresh your browser to update the Web Part Page and the Gallery." It doesn't matter which web parts I try to add. I can't add any of the standard web parts/lists (Events, Attendees, Page Viewer, etc.) or any third party web parts. I CAN add any of the web parts to any of my existing pages on any sub sites. This problem is ocurring only on new pages I add today. I have attempted to add the web parts while in FrontPage with no luck (same error message). I have done an IISRESET. I am hesitant to reinstall anything as this is a production server used by the entire company. Thanks for any help you can give. IAN Tag: hardcoding password instead of showing password box everytime Tag: 30491
  - 3
    - Problems with Scheduled Emailing on Datasources I'm trying to set up my report server to send reports by email to my management team in the company but I'm unable to do so. It seems like the report server is able to send hyperlinks but not any other format. The error I receive is strangely these, "Cannot create a connection to data source 'Datawarehouse'" "Database 'Datawarehouse' does not exist" This "Datawarehouse" is a Analysis Service datasource. Below is my connection string Connection Type = OLE DB Connection String Provider=MSOLAP;Client Cache Size=25;Auto Synch Period=10000;Data Source=AP5184;Initial Catalog=Datawarehouse I have no problems accessing the reports from the web browser but why is RS reporting that the datasource cannot be found? Anyone got any idea? Any advice is appreciated. Tag: hardcoding password instead of showing password box everytime Tag: 30485
  - 4
    - Simulate "create snapshot" functionality in a custom .aspx page Hi all, I have posted a similar question in this forum a while ago and I wanted to rephrase that question and hence this mail. for reference, I have included a thread that someone already posted and something very close to what I wanted(although, she wanted it to be done thru a .rss file whereas I am trying to do it from a .aspx page). I am trying to simulate the "creation of snapshot" of a report from a custom .aspx page. I would like to know if there any such thing-- possible. Thanks Jammer --------------------------------------------------------------------------- Hi Wayne, I found a solution to do this but I am not sure if it is preferred In the RSS file I use the following lines to create a snapshot for a given report: 'check if the report is rendered already from a snapshot. If not, create one... If Not rs.GetExecutionOptions(item.Path, scheduletype) = ExecutionSettingEnum.Snapshot Then rs.SetExecutionOptions(item.Path, ExecutionSettingEnum.Snapshot, scheduletype) End If 'update the snapshot rs.UpdateReportExecutionSnapshot(item.Path) Note that scheduletype is an object of type ScheduleDefinitionOrReference Q "Wayne Snyder" wrote: > I do not think that information is strored in the report xml file, but is in > the reporting services database.. YOu could store the info in the rrs file, > but you would have to write a program that parses the file, and does the > rendering yourself... > > -- > Wayne Snyder, MCDBA, SQL Server MVP > Mariner, Charlotte, NC > www.mariner-usa.com > (Please respond only to the newsgroups.) > > I support the Professional Association of SQL Server (PASS) and it's > community of SQL Server professionals. > www.sqlpass.org > > "Qbee" <Qbee@discussions.microsoft.com> wrote in message > news:897C0886-44FE-45FA-A658-C67D931BF51E@microsoft.com... > > Hi all, > > > > I want to simulate the "Render this report from an execution snapshot" and > > "Create a snapshot of the report when the apply button is selected" > > functionality from as .rss file. > > > > Any ideas? > > > > Thanks. > > > > Q > > Tag: hardcoding password instead of showing password box everytime Tag: 30484
  - 5
    - get SQL RS snapshot functionality working in a custom webpage Hey experts, I would like to know if there is a way to implement the "snap shot" functionality available in the SQL Reporting services in my own custom webpage.Like after my initial investigation, I found out that once the report is set to 'snapshot' mode, it is gonna be stored in the data server as a binary-encoded-format. Someone please confirm my investigation and also let me know if I could accomplish the same task from my own webpage(.aspx). I need an idea before I could discuss this with my team. thanks much for your continuous support Jammer Tag: hardcoding password instead of showing password box everytime Tag: 30482
  - 6
    - There is no Business Intelligence Projects folder in VB .net 2003 I've installed SQL reporting services on one of our SQL servers along with the .net framework. I then installed VB .net 2003 and I'm trying to open a new project to create a report. When I click on new project, the new project window opens, but there is no Business Intelligence Projects folder to choose a new report project from. Tag: hardcoding password instead of showing password box everytime Tag: 30481
  - 7
    - Generate Ad-hoc Reports with Microsoft Reporting Services 2005 article available Just a quick note to let you know about the availability of my article (http://www.devx.com/dbzone/Article/28047) about ad-hoc reporting with RS 2005. It explains the major components of Microsoft Reporting Services' ad-hoc architecture and semantic model, and walks you through an end-to-end example that demonstrates how to author, manage, and deliver ad-hoc reports. Happy ad-hoc reporting! --------------------------------------------- Teo Lachev, MVP [SQL Server], MCSD, MCT Author: "Microsoft Reporting Services in Action" --------------------------------------------- Tag: hardcoding password instead of showing password box everytime Tag: 30480
  - 8
    - Auto Generate Columns Is there a way, just like a datagrid, to auto generate the columns? I have a dynamic sql query, and some columns might not need to be displayed, so it would be best if the report would do it itself. Tag: hardcoding password instead of showing password box everytime Tag: 30479
  - 9
    - where is Report footer? I'd like to add a report footer to my report,but I don;t find it.Where is it? I have a Group footer and Page footer there,but can't find the report footer. Thanks Tag: hardcoding password instead of showing password box everytime Tag: 30478
  - 10
    - open report in new browser window Anyone know how to force the report to open in a new browser window? I am using the render method for example to create my report in pdf format. My problem is that it is embedded in my application and the report replaces all data on my webform and I have to hit the browsers back button to clear the report and proceed. I would rather just open in a new window and close it accordingly and return to my webform unchanged. -- Kristin Tag: hardcoding password instead of showing password box everytime Tag: 30477
  - 11
    - Custom Forms Authentication - fails every two or three hours after working fine. I'm enclosing the pertinent log entries form the ReportServer_DD_DD_DDDD_HH_MM_SS.log file. Problem: I've written a custom forms auth extension that (naturally) works fine in the test environment. In production, under about 25 - 20 users (80 - 150 report requests) per hour, everything works fine until after about two or three hours, for some reason, the following errors (below) appear in the log, and in the event log an error is thrown that simply states: "Report Server cannot load the forms extension." Then, no can access the report manager becuase you get an error that says a configuration file for report server was changed and it can't acces report server (sorry, i don't have the exact message text). NO CHANGE HAS BEEN MADE TO ANY CONFIG FILE! All I then do is restart the reporting service and restart IIS, and everything is just fine again for a few hours. My client has to have this Single Sign on solution, and it works really nice. But to have it go down every few hours on the production server doesn't instill confidence. The following two line from the report server logfile reference something about trying to add a 'delete schedules' key. We don't allow any subscriptions, nor do we have any custom schedules defined. We do have Sql Agent running for data feeds and execution log stats on our db server. I don't know where its getting 'delete schedules' from. Any help would help... btw we're running WIN2003 SP1, ENT RS SP1 on web server, WIN2003 SP1 on database server. here's the log file entries: w3wp!extensionfactory!c70!05/10/2005-15:12:03:: e ERROR: Exception caught instantiating report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Item has already been added. Key in dictionary: "DeleteSchedules" Key being added: "DeleteSchedules" at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization.InitializeMaps() at Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization..ctor() --- End of inner exception stack trace --- at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Reflection.Assembly.CreateInstance(String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Reflection.Assembly.CreateInstance(String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly assembly, String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly assembly, String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType). w3wp!extensionfactory!34c!05/10/2005-15:12:03:: e ERROR: Exception caught instantiating report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Exception: Number of catalog names don't match. at Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization.InitializeMaps() at Thrivent.FPM.ReportingServices.CustomSecurityExtension.Authorization..ctor() --- End of inner exception stack trace --- at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly) at System.Activator.CreateInstance(Type type, Boolean nonPublic) at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Reflection.Assembly.CreateInstance(String typeName, Boolean ignoreCase, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) at System.Reflection.Assembly.CreateInstance(String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly assembly, String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.AssertAndCreate(Assembly assembly, String typeName) at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetNewExtensionInstance(String extensionName, String extensionType). w3wp!library!34c!05/10/2005-15:12:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, Could not load Authorization extension; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files w3wp!library!c70!05/10/2005-15:12:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, Could not load Authorization extension; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!34c!05/10/2005-15:12:03:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!34c!05/10/2005-15:12:03:: e ERROR: Stack trace: at Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension() at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper) at Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext reportContext, String subreportPath, CatalogItemContext& subreportContext, GetReportChunk& getCompiledDefinition, DataSourceInfoCollection& dataSources) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, ServerDataSourceSettings A_7) w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: Stack trace: at Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension() at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper) at Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(CatalogItemContext reportContext, String subreportPath, CatalogItemContext& subreportContext, GetReportChunk& getCompiledDefinition, DataSourceInfoCollection& dataSources) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, ServerDataSourceSettings A_7) w3wp!library!c70!05/10/2005-15:12:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, Could not load Authorization extension; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: The Report Server has encountered a configuration error; more details in the log files w3wp!processing!c70!05/10/2005-15:12:03:: e ERROR: Stack trace: at Microsoft.ReportingServices.Library.Security.get_AuthorizationExtension() from here on everything comes up with the same error. Tag: hardcoding password instead of showing password box everytime Tag: 30475
  - 12
    - Security groups not working in RS I have RS installed and different security groups set on the server and those groups set up as browsers in RS. On the Home folder I have all groups present. On different sub folders I exclude different groups. I thought this should make that folder not viewable to users in that group. What I am finding is all the folders are viewable to all users in all groups. However, when a user in an unauthorized group tries to actually view a report they get rsAccessDenied. Is this how the security is supposed to work? If not, anyone have any ideas what I have configured incorrectly? Thanks for your help Tag: hardcoding password instead of showing password box everytime Tag: 30468
  - 13
    - disable client-side printing If we disable client-side printing, is it done at the server level or folder level? Tag: hardcoding password instead of showing password box everytime Tag: 30466
  - 14
    - Updating Report Server and Report Designer We would be updating the Report Server and Report Designer pieces together. If we update the Designer to SP 2 for testing, will that developer still be able to deploy to a production server at level SP 1 without problems? Tag: hardcoding password instead of showing password box everytime Tag: 30465
  - 15
    - definite sequence for install?? Is there a definite sequence for applying Windows 2003 SP 1, Reporting Services SP 2, and SQL Server SP 4? We are looking to avoid a reinstall of Reporting Services SP 2. At this time, there are no definite plans for any of the service packs mentioned. What would be the best sequence of events â?? or doesnâ??t it matter? Tag: hardcoding password instead of showing password box everytime Tag: 30463
  - 16
    - Chart - X Axis Can the labels on the x axis be rotated so that they display vertically. The user wants a report that shows the month-year like May-2005, but with the text rotated 90 degrees. Tag: hardcoding password instead of showing password box everytime Tag: 30462
  - 17
    - Insert a value in a SQL query result for a parameter list. I can create a parameter list box with values from a query from a database table. Note: The database table does not contain any spaces or Nulls. I am trying to find out if it's possible to have a value inserted into the results of the SQL query. This value could be a space or specific value. For example of the SQL resuts: Medium Low High Urgent I would like to insert a space into the above query results. Is this possible. Thanks. Tag: hardcoding password instead of showing password box everytime Tag: 30456
  - 18
    - problem after deploy After deploy already tested report to customer's ReportServer I have a very strange problem: 1.Embedded image is missed at all in Header,but after export report to pdf it exist. 2.Pressing on + icon for get subreport does not do nothing.No call to subreport.Testing subreport standalone works fine. What can be problem?Where I can check errors? Thanks, Vladimir Tag: hardcoding password instead of showing password box everytime Tag: 30455
  - 19
    - Use of System SPs in RS I need to pull up table dependencies in a report that I'm doing. Of course, SQL has a great tool for doing this in QA or EM, sp_depends @objectName. The problem being that because it returns multiple result sets due to its error trapping, so I can't see any fields available to choose from when I use this SP. Has anyone else used a system SP in RS? If so, how did you modify it to work correctly? Um, quick note: when I say "modify it", I don't mean did you modify the system SP, but did you create a user SP using part of the code or did you strip some code and put it in a DataSet text box? Thanks! Catadmin Random Thoughts: Just when you think life is getting easy, your boss will invent the impossible problem and turn to you for the solution. Tag: hardcoding password instead of showing password box everytime Tag: 30451
  - 20
    - Sub-report page headers Is there a way to have the page header and footer show up in a subreport? Basically I have 3 seperate "customer service" reports. I want to combine all 3 into one report to ease the printing of the report. I'm able to add all 3 reports to one main report, but then I lose the page header that is specific to each report. Or maybe there is a better way to accomplish this task? On a side note, is there a way to use snapshots inside sub-reports? Thanks, bill Tag: hardcoding password instead of showing password box everytime Tag: 30449
  - 21
    - SP2 Print Error I just installed SP2. I republished my report. When I view the report within my web application, I now see a print icon. When I click on the print icon, I get the following error: An error occurred during printing. (0x80004005) Does anyone know what this means? Tag: hardcoding password instead of showing password box everytime Tag: 30447
  - 22
    - The Globals Collection Regards, I'm looking for a way to return the current report URL (including QueryString) inside of a report. So for instance: https://reports.company.com/reportserver/?%2fCustom+Reports%2fPharmaReport&rs:Command=Render Would return the above URL including the ending querystring. I know that I can use the following formula: =Globals.ReportServerURL & Globals.ReportFolder & Globals.ReportName, but how do I return the "?%2fCustomer_Reports%2fPharmaReport&rs:Command=Render"? Any help would be greatly appreciated! Thanks, Ben Tag: hardcoding password instead of showing password box everytime Tag: 30446
  - 23
    - Notifcation Services and scheduling MSRS reports A guy here told me to check out using Notification Services to schedule a MSRS report. Anyone here used it or think it's even a good idea? Tag: hardcoding password instead of showing password box everytime Tag: 30441
  - 24
    - What is the procedure for upgrading from evaluation version to the regular one? My evaluation version has expired and I am wondering what the simplest procedure for upgrading to the regular version is. SP1 for reporting services is installed and it makes reporting services db format incompatible with RTM. Should I choose a different db name, install SP1 and then change db name to my original db? Should I also export the encryption key? Thanks, -Stan Tag: hardcoding password instead of showing password box everytime Tag: 30438
  - 25
    - Report Designer I installed RS on a SQL 2K server. Installation went fine. I didn't install the Report Designer since I have VS.NET on my XP box. However when I open VS.NET I don't see Business Intelligence project. Does it need to install as add-on in VS.NET? Thx. Tag: hardcoding password instead of showing password box everytime Tag: 30426
- Next
  - 1
    - Forms authentication sample and Win XP pro /win 2k3 server I developed an app which uses the forms authentication sample from microsoft as a security extension, but since i upgraded my system to sp2 it stopped working, besides it doent work on a win2k3 server but it works on a win2k, the problems seems to be with ssl im using the selfssl utility to get my cerificates as im still working on a test environment, but even if i get a test certificate from a trusted provider it tells me it doenst trust it. the message is the following " The underlying connection was closed: Could not establish trust relationship with remote server. " this happens when calling the logonuser method using soap, ive tried changing all the adresses in the config files for https but it doesnt work. Tag: hardcoding password instead of showing password box everytime Tag: 30421
  - 2
    - Multicolumn Mailing Label I've got a report that is supposed to output on an Avery 5160 sized (1" x 2.5") label. The report is set up with a 1" tall x 2.5" wide data area, 3 columns, appropriate gutters and margins. It seems that I'm having to do a lot of really small tweaks to get everything to line up correctly on a label sheet. Also, I;m having a problem with the reporting items not staying together at the end of columns (meaning that it will split a label in half, which is not good). I used a table to do my layout for the report. Should I have used textboxes instead? Just looking for some hints that will make this less painful, 'cause it's really ugly now. Thanks, Brandon Tag: hardcoding password instead of showing password box everytime Tag: 30418
  - 3
    - Watermarks I cannot seem to figure a way to implement a watermak. Does anyone have any suggestions? Thanks Josh Tag: hardcoding password instead of showing password box everytime Tag: 30417
  - 4
    - Problems with OLE headers for images (bmp) I'm using Reporting Services to create some reports that need to read database images. Those images are stored using a front-end MS Access project (adp), hence, every image has a OLE header store with it inside the database. I have read about striping those 78 bytes of the OLE head when you read it back. However, since we use Spanish version of Office 2003, that size is not 78 bytes but 88 bytes. LEN('Bitmap image') = 12 LEN('Imagen de mapa de bits') = 22 22-12 = 10 bytes longer in spanish. Other aproach that I have been told about is Reporting Services to remove the ole header setting the Value of the Image component to: =System.Convert.FromBase64String(Mid(System.Convert.ToBase64String(Fields!MyImageField.Value), 105)) But that fixed 105 is also language specific. After a day of tests I have guessed that for spanish ole headers the value that I need to use is around 121 but I haven't been able to make the image component show the picture at all. I always get red crosses. 1st Question: Is there any general way to remove the OLE header no matter the language, version, etc of the program that has written the image into the database? Any API function or whatever? 2nd Question: In Reporting Services, after a lot of tests, the best thing that I have been able to do is removing the OLE header directly in the query, by using select clauses like this: SELECT SUBSTRING(MyImagField, 89, DATALENGTH(MyImagField) - 89) AS MyImageField FROM MyTable in order to strip the header from the images that I have in the database (89 is spanish specific, for english you should use 79). However it seems I'm missing something since the Image fields in the report show red crosses on them as if the data being shown by that component was not properly formatted (corrupted). Any hints about this subjects? If the OLE header problem cannot be solved, is there any workaround for it? like not writing OLE headers at all inside the database and just the raw image data? How? Thanks in advance. Regards. Tag: hardcoding password instead of showing password box everytime Tag: 30413
  - 5
    - Report Server doesn't install Hi!! I'm trying to install SQL Report Services on my mahicne. I get the designer installed, as well as other tools, but the Report Server doesn't get installed, and I can't open or deploy any report. I have WXP Pro, S2K SP4, RS Dev Edition SP1, and using my admin account. The "ReportServer" or "Reports" virtual forlders on IIS doesn't exist after installation, nor does the "ReportServer" folder under the SQL Server harddisk folders. Anyone has experimented the same problem? Any help is really appreciated! Many thanks in advance!!! MNB Tag: hardcoding password instead of showing password box everytime Tag: 30410
  - 6
    - Matrix width How do you find out the width of a matrix control, I need this to enable me to size the width of a Textbox, as the width needs to be the same size as the Matrix control which keeps growing depending on the data Tag: hardcoding password instead of showing password box everytime Tag: 30408
  - 7
    - Martix sort and English dates I have a Matrix which is has its columns as dates, when I select the sort order they get sorted, but the problem I have is that when it is in US date format, it sorts all okay, but in English date format (dd/mm/yyyy) it does not sort correctly, it appears to sort in a string format not the actual date. Anyone seen this or know about how to fix it? Tag: hardcoding password instead of showing password box everytime Tag: 30406
  - 8
    - Field names must be CLS-compliant identifiers. While creating a report using 'CreateReport' API method for Report Services 2000, I am getting the following error. // A field in the data set â??MainDataSetâ?? has the name â??Count Borrower Nameâ??. Field names must be CLS-compliant identifiers. --> A field in the data set â??MainDataSetâ?? has the name â??Count Borrower Nameâ??. Field names must be CLS-compliant identifiers. // The error occurs due to the space on the computed field name. If I concatinate the words with '_' (for example) then I do not get an error. I would like know how can I create report that has field with the name like â??Count Borrower Nameâ??, etc? Thanks. -Sue Tag: hardcoding password instead of showing password box everytime Tag: 30402
  - 9
    - Report Parameter Display Formatting I have a report where I want to create a boolean parameter that has two radio buttons, where one radio botton has label "With Approval" and the other radio buttons label says "No Approval (Under Review or No Request), plus there is not leading text prior to the first radio. Basically I want my report parameter display to look like this: X - With Approval X - No Approval (Under Review or No Request) Note: X in the above text is the radio button. How is this done? I can easily set up the two radio buttons, with a single boolean report parameter, but I can only get the labels to say "true", or "false", plus a leading label that says "With Approval". Some thing like this: With Approval X true X false Tag: hardcoding password instead of showing password box everytime Tag: 30401
  - 10
    - Security Concept Hello togheter I'm a "new" Developer and I try to develop a salary-management-web-application with asp.net and sql. Now i will set up a right security-concept (so I can use it also in future) I'm searching for Articles or any informations where i can find diffrent kind of security-concepts for webapplication. Thx Michele Tag: hardcoding password instead of showing password box everytime Tag: 30397
  - 11
    - Using RS in ASP Give me some samples how to use reporting services in ASP. I have done with ASP.NET. Is there any possible way to use the rdl other than .NET application. Thanks In advance. Tag: hardcoding password instead of showing password box everytime Tag: 30396
  - 12
    - Legend Text Wrapping The text in my pie chart legend does not wrap. It is cut off ending with "...". Is this by design? Tag: hardcoding password instead of showing password box everytime Tag: 30395
  - 13
    - Format of input parameters Hi I've got a report which takes a start & end date as parameters. It works fine, except that RS seems to insist on my users typing US format dates (mm/dd/yy) rather than UK format (dd/mm/yy). Does anyone know how to change this? Sorry if this gets posted twice - cookie problems Chloe Tag: hardcoding password instead of showing password box everytime Tag: 30391
  - 14
    - Permitted Host Problem I have Reporting Service up and running and able to send email of the reports. I have a request from a client to set their system up so that reports are email to approved recipients. I have the DefaultHost (called DomainA) to the local SMTP domain, and have put in a domain in the PermittedHost (called DomainB), in the config file. When I send a report the the permitted DomainB, works fine. When I send same report to DomainC, (which is not a permitted host) and that report gets delivered also. I would think that since it was not a permitted host the report should have not been sent. Am I missing a configuration? If there were multiple hosts to permit, would they be separated with a comma(,) or semicolon (;)? The SMTP server has been setup to relay to a Smart Host for delivery. Below is my email configuration. I show the current setup and I also have show a 2nd setup that I have tried, but get the same results. <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider"> <MaxRetries>3</MaxRetries> <SecondsBeforeRetry>900</SecondsBeforeRetry> <Configuration> <RSEmailDPConfiguration> <SMTPServer>Relay Server</SMTPServer> Current Setup #** <SMTPServer>localhost</SMTPServer> Have also tried Setup #2 <SMTPServerPort></SMTPServerPort> <SMTPAccountName></SMTPAccountName> <SMTPConnectionTimeout></SMTPConnectionTimeout> <SMTPServerPickupDirectory></SMTPServerPickupDirectory> Current Setup #** <SMTPServerPickupDirectory>c:\inetpub\mailroot\Pickup</SMTPServerPickupDirectory> Have also tried Setup #2 <SMTPUseSSL></SMTPUseSSL> <SendUsing></SendUsing> Current Setup #** <SendUsing>1</SendUsing> Have also tried Setup #2 <SMTPAuthenticate></SMTPAuthenticate> <From>Server@DomainA.com</From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>True</SendEmailToUserAlias> <DefaultHostName>DomainA</DefaultHostName> <PermittedHosts>DomainB.com</PermittedHosts> </RSEmailDPConfiguration> </Configuration> Server Information (This is a development server, so everything is installed): W2K3 w/IIS and SMTP SQL 2000 SP3a SQL Reporting SP2 If you need more information, please let me know. Thanks in Advance for any help, Zing1atu Tag: hardcoding password instead of showing password box everytime Tag: 30390
  - 15
    - ReportingServices...add on? Does anyone know if the reporting services is an add-on to the SQL server license or does it have its own license that must be purchased? Tag: hardcoding password instead of showing password box everytime Tag: 30389
  - 16
    - Parameter in ReportingService I believe a simple question..but I'm new to SRS. I have three parameters. Two are pulling from queries which makes them drop downs, The first is a simple select query which upon selection passes a parameter of its value to the second. the third is a free form field which a person enters a date. For some reason upon selection of the first parameter, the second combo does not fire off... it waits until the date field is filled in and the view report button is clicked before it will fill. I have the parameters in the right order on the report parameters page so I am a bit at a loss as to what the problem is... Any help would be appreciated Dan Tag: hardcoding password instead of showing password box everytime Tag: 30387
  - 17
    - Start Report after a Succesful DTS-Package Hi, I dont want to Schedule our Reports, because I dont know when the data delivery of our DTS-Packages is finished. So is there a possiblity to Start a Report within a DTS-Package (after Success). Thx in Advance, Regards, Dieter Felix Tag: hardcoding password instead of showing password box everytime Tag: 30386
  - 18
    - Missing header in PDF I've built a fairly straight forward report in RS that looks normal in preview mode and HTML rendering but when I export it to PDF the column header row is missing when i just have group-footer on the page without any detail columns. The column headers are in the group header and RepeatOnNewPage is set to True. Any ideas as to why this is occurring? Any solutions? thnx Tag: hardcoding password instead of showing password box everytime Tag: 30385
  - 19
    - subreports This is a multipart message in MIME format. --=_alternative 0047992C86256FFD_= Content-Type: text/plain; charset="us-ascii" I am using a subreport to pull data from a different datasource (custdetail) which is linked to list on my main report through something called householdID. The main report does a good bit of authentication and only presents the data a particular user is authorized to see. For example, user X is only authorized to see households 1,2 and 3 while user Y can see households 4,5,6. The subreport takes a parameter of householdID. How can I prevent users from running the subreport directly and providing household keys that they aren't authorized to see? --=_alternative 0047992C86256FFD_= Content-Type: text/html; charset="us-ascii" <br><font size=1 face="sans-serif">I am using a subreport to pull data from a different datasource (custdetail) which is linked to list on my main report through something called householdID.  The main report does a good bit of authentication and only presents the data a particular user is authorized to see.  For example, user X is only authorized to see households 1,2 and 3 while user Y can see households 4,5,6.  The subreport takes a parameter of householdID.  How can I prevent users from running the subreport directly and providing household keys that they aren't authorized to see?</font> --=_alternative 0047992C86256FFD_=-- Tag: hardcoding password instead of showing password box everytime Tag: 30384
  - 20
    - Language settings Hi, I encounter the follwing problem: My standard language is german (in VS .NET as well as in Reporting Services), but sometimes (no idea by when) it changes to english. This is not very nice for some of our users. Can I assign the german language somewhere and supress all other languages ? Thx a lot. dajm Tag: hardcoding password instead of showing password box everytime Tag: 30381
  - 21
    - Add Row to Detail Section I have a simple report with 8 columns of output. The wizard created a table header row, a table row with a group heading and a detail section. I want to move one of the data fields in the detail into a row below the other detail information (it is a comment type field and needs more space). How do I do that? Wayne Tag: hardcoding password instead of showing password box everytime Tag: 30379
  - 22
    - Render Barcode Font to PDF Hi, I'm using a barcode font in one of my reports. This font is displayed correctly on my development machine. But when I deploy the report to the production server the PDF doesn't render the font. It's using another font instead. The font is installed on both machines. So I don't know why it doesn't use the right font. Regards, Flo Tag: hardcoding password instead of showing password box everytime Tag: 30378
  - 23
    - HELP...ME.!!! Hi all, I'm trying to past thru POST a parameter. Works fine but when the parameter has more than 1850 chars the report is not displayed and any error is throw. The server is installed in Windows 2003. Has some limitation the length of parameters when is send by POST? I'm desperate because I had be looking for the solution a lot of days. Kirsi Tag: hardcoding password instead of showing password box everytime Tag: 30376
  - 24
    - Newbie Stuck Trying to Resize Data Region I am trying to build my first report following instructions in a book (Wrox - SQL Server RS). The sample they use (using the wizard) calls for resizing the report header and the detail section in the body. They say to "..click anywhere in the grid and then click on the gray box at the intersection betweern the column and row headers..." I cannot get this to add the resizing handles to the detail section (the field names and field data rows). If I just click on the textbox in the header, it shows the resizing handles as expected. Clicking on that "gray box" toggels it between just a gray box and a gray box with a black square in it. I have no idea what that means? How do I resize the detail section, and then, the individual columns? TIA Wayne Tag: hardcoding password instead of showing password box everytime Tag: 30373
  - 25
    - Matrix fields dosn't toggle Hi I use a matrix with few toggled fields, which works fine when I run it in the browser directlly, but when I run it in my application, via iframe, I can not toggling Thanks Tag: hardcoding password instead of showing password box everytime Tag: 30371

Dear all
Everytime, when my aspx application connect with the reports, it will also
show the password box for the input of username and password, however, can we
avoid it to show the password box? I want to implicity hardcoding the
username and password into the aspx and i don't want to show the password box
in the IE

Re: hardcoding password instead of showing password box everytime by Robert

Robert
Wed May 11 23:50:54 CDT 2005

You can use stored credentials for the data sources. In report manager, go
to the properties page of the report, click on the data sources tab and
specify a user name / pwd and click apply to store these credentials.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

"Joe" <Joe@discussions.microsoft.com> wrote in message
news:81E41716-A88F-4C3B-B785-6012F6767E9D@microsoft.com...
> Dear all
> Everytime, when my aspx application connect with the reports, it will also
> show the password box for the input of username and password, however, can
> we
> avoid it to show the password box? I want to implicity hardcoding the
> username and password into the aspx and i don't want to show the password
> box
> in the IE
>

Re: hardcoding password instead of showing password box everytime by Joe

Joe
Thu May 12 01:58:02 CDT 2005

No the password prompt is from I.E. it ask from the domain user password to
see whether it have the right to see the reports or not, not the data sources
password

"Robert Bruckner [MSFT]" wrote:

> You can use stored credentials for the data sources. In report manager, go
> to the properties page of the report, click on the data sources tab and
> specify a user name / pwd and click apply to store these credentials.
>
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Joe" <Joe@discussions.microsoft.com> wrote in message
> news:81E41716-A88F-4C3B-B785-6012F6767E9D@microsoft.com...
> > Dear all
> > Everytime, when my aspx application connect with the reports, it will also
> > show the password box for the input of username and password, however, can
> > we
> > avoid it to show the password box? I want to implicity hardcoding the
> > username and password into the aspx and i don't want to show the password
> > box
> > in the IE
> >
>
>
>