sqlserver ROWID !

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
    - Dynamically Set Default Value and Hiding Parameters Can someone give snippet for dynamically setting the default value for a report, before rendering? I need to do this for my Create Snapshot functionality, as the reports all take a UUID to identify a user for the query. Also, although SP1 allows for hiding parameters, when the user uses the Copy function, the formerlly hidden param is now visisable in the copy. So, I'm guessing to solve this would be to check for parameters first, provide UI for input and simply hiding the entire parameter's tool bar. Tag: sqlserver ROWID ! Tag: 8604
  - 2
    - Newbie question using Render method I'm using the render method to return a report to an ASP.net web app. I have several panels on the page, which alternate visibility. I want to display my report in the 3rd panel. My question is, how do I tie the results returned from the report server to this panel so that i can control its location and visibility via the panel? I'm pretty new to ASP.net. TIA, Brian Tag: sqlserver ROWID ! Tag: 8603
  - 3
    - Charts I have a Custom Dundas Charting library that I utilize normally. I'm having troubles getting my chart object (and tried to return and image) to render within my reports. I'm confident I have the custom assemblie referenced. I don't want to use the chart field from the toolbox, I want to set it to what my assemblie returns. Anyway to get around this? I'm aware of the custom data extensions, although, I wanted to just have my existing assemblie which returns charts do it instead. so all my reports that need graphs can just reference the assemblie and graph that is needed. Anyway to accomplish this? I'm getting data type reference errors etc. Clint Tag: sqlserver ROWID ! Tag: 8602
  - 4
    - Page Size I have a report that needs its page header / report header to be portrait the pages after this are to be landscape (detail) and the last 2 pages portrait. (report footer) Anybody got any ideas here, i suspect it isn't possible though. Regards Toby. Tag: sqlserver ROWID ! Tag: 8600
  - 5
    - ##### Sorting a column in the report ##### Hi I am using SQL Server 2000 Reporting Services. I want to add sorting in my reports so that when a user clicks on the column header the data in the report gets sorted by that column. How can i achieve this. A descriptive explanation would be really helpful Thanks Gautam Kashyap Tag: sqlserver ROWID ! Tag: 8593
  - 6
    - How to Suppress the Hiden Row Hi Group, When i rendered the report to MHTML the hidden items are still displaying and in the preview mode a blank space is displayed.So how do i suppress the hidden items. Tag: sqlserver ROWID ! Tag: 8592
  - 7
    - reports on AD elements Is there a way that RS can create reports using the DC Active Directory as the data source? I need to pull a report listing two fields: User and e-mail address(from exchange). Any help is appreciated. Thanks, Ron Tag: sqlserver ROWID ! Tag: 8591
  - 8
    - Custom Data Extension problems Hi all, I'm trying to develop a custom data extension for a proprietary database we use, and I'm running into problems. I've built a test harness for it and it works fine; however when I try to use it with RS I get the following error just after having entered my query and pressed Next in the New Report wizard: "An error occurred while the query design method was being saved. Object reference not set to an instance of an object" When I step through my code, I can see that everything goes well until the designer tries to call the Parameters property on the Command object. Because my database doesn't support parameters I'm returning null here, something I've seen in several code examples. As soon as I've exited the property I get the error, with the debugger saying it originates from Microsoft.ReportDesigner.Design.Query.HasParameters. Other background information (in no particular order): - Before I get to the Parameters property, I see that the GetName and GetFieldType properties on my DataReader are called the same number of times as there are columns in my resultset, and then the Dispose method is called on the DataReader. - My queries are in XML, and here's the sample I'm using for testing: <DVAutoXMLFetch Database="C:\Program Files\IMS Health\DATA\DBPINT01.PRM"> <TimePeriods Count="4"> <TimePeriod>QTR/3/02</TimePeriod> </TimePeriods> <Variables Count="3"> <Variable>UN</Variable> </Variables> <Dimensions Count="16"> <Dimension Name="CTY" IsGroup="False" BaseDim=""> <Member>AUSTRIA</Member> </Dimension> </Dimensions> <FetchDefinition> <NumberPrecision ValColNumPrec="1000" ValColRndPrec="1" CalcColRndPrec="3" /> <AcrossMeasures Count="2"> <AcrossMeasure Index="1" DimName="TimePeriods" /> <AcrossMeasure Index="2" DimName="Variables" /> <Columns Count="1" Rank="0" CalcRank="0" /> </AcrossMeasures> <DownMeasures Count="1"> <DownMeasure Index="1" DimName="CTY" /> </DownMeasures> </FetchDefinition> </DVAutoXMLFetch> - I'm running RS SP1 on Windows 2000. - I can post the source code if anyone wants... Thanks in advance for any hints! Chris Tag: sqlserver ROWID ! Tag: 8590
  - 9
    - Problems with Parameters (C#) I am passing parameters from Bryan Keller's C# program that has been mentioned here many times to my report. I get the following error: Default value or value provided for the report parameter 'fromclient' is not a valid value. The execution log shows 'rsInvalidReportParameter'. 'fromclient is a string value and it is the 3rd parameter of seven. The first two are boolean, and I pass them as "0" and "1". I don't seem to get past this point. What am I doing wrong? Gerhard Tag: sqlserver ROWID ! Tag: 8589
  - 10
    - Fetching Data from Table result This may not be possible but if I don't ask.... I have a SQL query which returns something like : Category Value1 Value2 Value3 Value 4 A 10 12 14 15 B 8 22 44 55 C 5 33 55 88 I have a table which displays the above data like: Category Values C 5 33 55 88 B 8 22 44 55 A 10 12 14 15 Note the ordering of the resultant table. In the Table Properties | Sorting I have a function which returns the highest value given a set of values. Hence the sorting is set to Code.HighestValue (Value1, Value2, Value3, Value4). Sure there's a better way to do this and am open to suggestions. Finally we come to my problem. I want to display 88 (highest value from category C) in another part of the report. Is there a way to do this other than changing the sorting in the SQL query so I can grab the first row? Martin Tag: sqlserver ROWID ! Tag: 8588
  - 11
    - Is Active Directory required for RS Enterprise? Can we create an Enterprise RS setup (including Network Load Balanced Report Servers) without deploying Active Directory? Thanks for any advice, Chris Tag: sqlserver ROWID ! Tag: 8585
  - 12
    - How to Add a rowcount in matrix? hi, there. I want to add a rowcount in matrix like as.. Accessory 1. Helmet Bike 1. Mountain Bike 2. Road Bike Clothing 1. Bib-Short 2. Cap 3. Gloves 4. Jersey I'm trying a RowNumber() Function..But It Not work Correctly...-.- Please let me know that.. have a nice day. Tag: sqlserver ROWID ! Tag: 8577
  - 13
    - When is the "custom code" best useful In what scenarios will i have to use "custom code" (Report->Properties->CustomCode tab) for a report ? Is there any example i can see ? thanks Anand Sagar anandsagar@gmail.com Tag: sqlserver ROWID ! Tag: 8576
  - 14
    - Execution snapshots not being added to report history Hello, I'm trying to generate a snapshot everytime a report is viewed. I've setup the properties of the report to "Store all report execution snapshots in history" but no report is being created under the History tab. The datasource uses hardcoded credentials. The only thing I have found in the log file that may relate to this is the following (but it does not consistently occur every time): INFO: LoadSnapshot: Item with session: [session id], reportPath: [report path], userName: [my username] not found in the database Can anyone help? Thanks Tag: sqlserver ROWID ! Tag: 8575
  - 15
    - Superscript in Textboxes Hi, Is there a way to create superscript in RS? Looks like it is currently not supported... I tried creating 2 textboxes (1 regular text and 1 very small text with font size 4) and placed them side by side trying to produce some similar effect but the result after the report was rendered is not good. I would like to put the "TM" trademark text in my product listings, can anyone confirm if superscript is supported or not? Thanks! Also, I would like to bold a portion of the text in a text box. How can I do that? Currently I have to create multiple text boxes (mixed with bold and normal text) and place them together, any better solution? CCC Tag: sqlserver ROWID ! Tag: 8566
  - 16
    - Stack Bar Fill Effect Is there any filling effect on the stack bar ? e.g. Apply two colors on single bar and have gradually effect i.e. like Excel Tag: sqlserver ROWID ! Tag: 8565
  - 17
    - How to Avoid Label overlaping in Pie Charts Hi, I am totally new to Reporting services. I currently ran in to this problem, Any help will be appreciated. I currently have a pie chart with one piece having 95% and the rest 5% is shared by 5 to 10 peices of the pie chart. Now here when I have label in the pie chart, The percentage values for these 5-10 peices get overlap. It is a must for me to display the % some way either as label or in legand Thanks Bala Tag: sqlserver ROWID ! Tag: 8564
  - 18
    - "Must declare variable" error caused by stored procedure I'm having the most difficult time trying to generate a report that first calls a stored procedure and then retrieves the data produced from it. I get the error, "An error has occurred during report processing...query execution failed for data set dsOrgs...Must declare the variable @INum" when I try to run the report. The dataset below (dsOrgs) first calls a stored procedure (SV_GetSubordinates) that populates a table with hierarchical data. The second part (the Select statement) then retrieves the data produced by the stored procedure. I have no problem running this set of SQL statements in the Data view of the Reporting Services Report Designer. EXEC SV_GetSubordinates @INum,'Groups',@OrgNum SELECT v_Orgs.* FROM v_Orgs, SVSiblings WHERE v_Orgs.INum = @INum AND v_Orgs.INum = SVSiblings.INum AND v_Orgs.OrgNum = SVSiblings.Num By the way, @INum is a parameter that will be passed to the report in a URL string eventually. But for now, I have to use both the Preview capability of the Report Designer and the Report Manager rendering engine to test out my report. I have another dataset that gets the @OrgNum parameter value from a selection in a drop down in my report. Here is the query for that data set... SELECT NULL AS OrgNum, '-- ALL Orgs --' AS [Description] FROM SVGroupDefs WHERE INum = @INum UNION SELECT OrgNum, [Description] FROM SVGroupDefs WHERE INum = @INum ORDER BY [Description] As you can see, I'm using @INum in this dataset first so I can populate my drop down list. When the user selects an Organization from the drop down list, the selection returns the value for the parameter @OrgNum, which is used in my dsOrgs dataset along with @INum to retrieve the hierarchical data for my report. You may be asking why I need to get hierarchical data when the table object in the report designer uses a parent-child relationship. The reason why I'm going through all this pain is because I need to recursively get all the children from a starting parent level, which @OrgNum supplies. SQL Server does not natively support a way to recursively get all the children in a hierarchy. The only way to do this is to run through my stored procedure, which recursively calls itself and then populates a table with the child OrgNum values (fortunately Yukon has solved this recursive nightmare). Anyway, how can I generate my report when the error states I must first declare @INum? Tag: sqlserver ROWID ! Tag: 8563
  - 19
    - Tables with groups, filter and new pages I have a table that has groups and group headers that start on separate pages for each grouping. When I add a 'visibility' filter the page breaks for different groups no longer work. Is this a bug in SP1? Tag: sqlserver ROWID ! Tag: 8554
  - 20
    - Background Image Specification I need to set up a background image that only renders in the top right hand area of the page/screen. Is this possible & how do I go about briefing a branding/design team to create an image that will fit correctly in terms of image size etc. Thanks Tag: sqlserver ROWID ! Tag: 8552
  - 21
    - The required field DataSource is missing from the input structure I am trying to change the DataSource of a report programatically using SetReportDataSources and I am receiving the following error: The required field DataSource is missing from the input structure The report has a datasource. What could be the problem? Tag: sqlserver ROWID ! Tag: 8551
  - 22
    - Sort Columns by clicking header I know you can make this work using this approach: http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=0064e121-fd26-4c83-8add-4a694e4fea7d&sloc=en-us ...but my problem is I have additional parameters to my report and when I click a header column they are not being supplied so I get a blank page. How can I pass ALL the parameters back to the same report. Tag: sqlserver ROWID ! Tag: 8548
  - 23
    - Page break after second group I have two groups, and specify a page break at the end of the second group. It works fine until I export to PDF. It will show the first group, and repeat the second group, and thats it. Here is an example: Group1 - Account Managers Group2 - Category Managers Excel -------------------------------------- AccountManager1 CategoryManager1 CategoryManager2 CategoryManager3 AccountManager2 CategoryManager1 CategoryManager2 CategoryManager3 But when exported to PDF I get: AccountManager1 CategoryManager1 CategoryManager2 CategoryManager3 No AccountManager2. Any ideas? -- If ignorance is bliss, why aren't more people happy? Tag: sqlserver ROWID ! Tag: 8546
  - 24
    - viewing same report using different cultures Hello, I have a report that needs to be seen in other cultures. I don't see resource files for a report, so i'm wondering the preferred method to do this. Surely I don't have to create a report for each culture. Tag: sqlserver ROWID ! Tag: 8536
  - 25
    - how to change query that runs report programmatically I have a report that will display certain records based on the user that logs in. I need to be able to change the query the report uses programmatically. I havent had any luck trying to find how to do this online. If anyone can help me that would be great. --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. Tag: sqlserver ROWID ! Tag: 8534
- Next
  - 1
    - New version installation trouble Uninstalled previous version - was recommended in another post - but when starting reportmanager it says: unable to finde script library /aspnet_client/system_web/1_1_4322/webuivalidation.js try placing this file manually or reinstall by running aspnet?regiis-c This is close to be russian for me - and I'm danish so that's a problem. I actually found the file mentioned in the directory above so I haven't got a clue what to do. Is it the asp net version it doesn't like ? --Michael Vardinghus Tag: sqlserver ROWID ! Tag: 8532
  - 2
    - Export Web Archive (MHTML) not working after SP1 installed Exporting to Web Archive (MHTML) is not working anymore after I installed SP1. When I export to Web Archive and open the file directly IE just hangs. When I save the file to my disk and open it from there it works. All other formats for export work fine. Here is a line from the report file. w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ### GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found! this=88b2b869-7080-4a6f-8c92-54eed686a400 Any tips would be appreciated. Thank you. Tag: sqlserver ROWID ! Tag: 8516
  - 3
    - Yet another Forms Authentication problem This is more of a .NET/permissions issue, but it is in the context of RS' forms authentication, which is making it more difficult for me to understand/debug. I have forms authentication working like a charm. However, I am now trying to do some authentication against an Oracle database. What's very strange is that as soon as I try to bind to Oracle's client (Oracle.DataAccess in, by default, C:\oracle\ora92\bin\Oracle.DataAccess.dll), I get "System.Security.Policy.PolicyException: Required permissions cannot be acquired." I've definitely narrowed it down to the Oracle binding, but can't figure out how to make it work. I've looked in "Microsoft .NET Framework 1.1 Configuration" under "Runtime Security Policy" and did an "Evaluate Assembly", which returned "Unrestricted". I also tried editing rssrvpolicy.config (in "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\") to add a full trust for the Oracle.DataAccess.dll, but none of this has helped. Any other ideas or suggestions? Despite being much more capable, I often find .NET permissions much more confusing, especially trying to debug this type of failure. If anyone can point me to some good tools and/or techniques on this topic, I'd MUCH appreciate it. I suppose part of the problem is that I don't have time to read an entire book - I just want to skip to the good parts! :-) Thanks a lot! Brad. Tag: sqlserver ROWID ! Tag: 8503
  - 4
    - Calendar in parameter drop down Hi all Is it possiable to have a calendar drop down in a date parameter field? I am not a programmer so be kind. This would be much easier for users than typing in a date. thanks Tag: sqlserver ROWID ! Tag: 8502
  - 5
    - styletemplate ... what can I put on this file? Hi, I'm currently creating a new style but there is a lack of information about what can I put in the styles list. For example : Page Group Level 1 describe how to format a list in a report. I've setup a background color, but the color is applyed to the list + the "title" of the section in the report. I want to apply the background color only to the "title" of the list, not to the background of the list. Attention: I don't talk about the title of the report and I don't talk about the title of a table. I mean : the text where the group of the list is based on! When I go in the wizard, I select my country as a page group, then the country appear on the report as the "title" of the list. (I want to control the format of this text from the styletemplate file) so, to accomplish this, I'm looking for the complete list of all the possible properties useable in the styletemplate document. can you help me?. thanks. Jerome. Tag: sqlserver ROWID ! Tag: 8494
  - 6
    - Creatiing a link to download an attachment I have a database where one of the fields is a large binary object. I would like to create a report where one of the columns shows a link to the "attachment". When the user clicks on the link, they should be able to download the raw binary data (with the mime type of my choosing). Can this be done? Thanks, Steve Tag: sqlserver ROWID ! Tag: 8493
  - 7
    - Double Byte Characters scrambled in PDF Output Does anybody know how I can Clean up some European Characters such as "?" in a text field: "45000 m² new office project designed by Arquitectonica. Revised proposal and clarifications issued to client on 26 Aug: 1239K? for MOEX, 985K for Synthese as option. Ten competitors, including Coteba. Contract award expected by 15 Sept 04." Is there a certain data type to use or is there a conversion fucntion to use? Help Tag: sqlserver ROWID ! Tag: 8490
  - 8
    - 405 Error when passing parameters to reports - IIS and Reporting Services When trying to use a report that requests parameters, while in Visual Studio everything works fine. I can preview the report and select a parameter, click view report and the report works. When I deploy the report to the server and test on the web site, after I select the parameter from the drop down and click the View Report button I get an error in the selection criteria fram that says.... (Clip) The page cannot be displayed The page you are looking for cannot be displayed because the page address is incorrect. -------------------------------------------------------------------------------- Please try the following: If you typed the page address in the Address bar, check that it is entered correctly. Open the finreports.mc.vanderbilt.edu home page and then look for links to the information you want. HTTP 405 - Resource not allowed Internet Information Services -------------------------------------------------------------------------------- Technical Information (for support personnel) More information: Microsoft Support (/Clip) The Report page itself stays blank. When checking the IIS logs, I see.. (Clip) 443 POST /ReportServer %2fDepartment+of+Finance+Reports%2fDNFB+Test+Data 405 1 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) (/Clip) It's giving a 405 error on the post to the ReportServer path. This report, and other reports, work perfectly when used without any parameters, it's only giving this error when I add parameters for the user to select. Does anyone have any ideas? I'm sure it's something I've overlooked, but I've been gazing at this so long just trying to get Report Server working in an SSL and Domain locked environment that I'm cross-eyed. I need an outside view and opinion. Thanks for any help anyone can give. TnNytehawk Tag: sqlserver ROWID ! Tag: 8488
  - 9
    - Subscription Error: AuthzInitializeContextFromSid am getting the following error when trying to execute a email or file share subscription: AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs. The Report Server Windows service is running as a domain account. Here is the stack trace: ReportingServicesService!library!54c!08/31/2004-12:36:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx ception: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason - service account doesn't have rights to check domain user SIDs.; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx ception: The Report Server has encountered a configuration error; more details in the log files ReportingServicesService!library!54c!08/31/2004-12:36:05:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties. ReportingServicesService!emailextension!54c!08/31/2004-12:36:05:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report Server has encountered a configuration error; more details in the log files ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx ception: The Report Server has encountered a configuration error; more details in the log files at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntP tr userSid) at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(Strin g userName, IntPtr userToken) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(S tring userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation) at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper) at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionF romCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyDate) at Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials) at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(Catalog ItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters) at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RS Service rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames) at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMes sageBody(IMessage message, Notification notification, SubscriptionData data) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessag e(Notification notification) at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti fication notification) ReportingServicesService!notification!54c!08/31/2004-12:36:05:: Notification 4fef3e68-0450-47de-abe3-04144220dd50 completed. Success: False, Status: Failure sending mail: The Report Server has encountered a configuration error; more details in the log files, DeliveryExtension: Report Server Email, Report: Monitor, Attempt 0 ReportingServicesService!dbpolling!54c!08/31/2004-12:36:05:: NotificationPolling finished processing item 4fef3e68-0450-47de-abe3-04144220dd50 Tag: sqlserver ROWID ! Tag: 8483
  - 10
    - Displaying CustomerID in the report header on mutliple pages Hi everybody, I would like to have a field (CustomerID) that is displayed in the header of the page. I can reference a field of the page with ReportItems!CustomerID.Value. This works fine as long the customer information is not spanned across two different pages. If this is the case the field in the header is empty on the second page. Is there another solution to this? Why can't I just reference a field item? Thanks, tom Tag: sqlserver ROWID ! Tag: 8475
  - 11
    - Display textboxes depending on rendering format I would like to display some textboxes depending on the rendering format. I would like to write an expression like this in the Visibility.Hidden =renderingFormat="Excel" Is this possible? Tag: sqlserver ROWID ! Tag: 8470
  - 12
    - Automate hiding of parameters Hi, I have a number of reports which hidden parameters. The problem is that when I change the reports, or as the number of reports grows, I'm then having to manually go through the report in report manager and remove the prompt string, making sure that 'Prompt user' is checked to put the 'hidden-ness' back. Is there any way I could do this automatically? All the report parameters I wish to hide will have consistent names so it would make my life a lot easier if I could do this. Can I do it through the web service - or maybe through scripting? Any help would be greatly appreciated. Thanks, Phil Aldis Tag: sqlserver ROWID ! Tag: 8469
  - 13
    - info Good Morning, I have a question. For Use sql reporting services I need on the same server Sql reporting services and VB .Net? Can I use Visual basic 6 or Crystal Report to create a report and only than use Sql Reporting Services to sharing the report? Tag: sqlserver ROWID ! Tag: 8467
  - 14
    - HELP!!! Question about SQL Reporting Services Licensing Hi, I urgently need the answer to a question about SQL Reporting Services licensing. I need to install SQL Reporting Services on an IIS server that hasn't got SQL Server installed on it. The Reporting Services database will deliberately go on a remote SQL Server. I don't want to install SQL Server on the IIS server - I just want to install SQL Reporting Services and put in a valid SQL Server license code when prompted during the setup. However, I can't seem to get a license code from anywhere as our company has some sort of global agreement with Microsoft which means we don't get to see the actual license codes. I'm also told by our licensing guy that SQL Reporting Services isn't on our Select CDs. Has anyone else installed SQL Reporting Services on a server that hasn't got SQL Server on it? If so, how did you do it? I'm genuinely not after some giving me a dodgy license code - I want to pay for the license, but I can't seem to get one through our company!!! :-< Is SQL Reporting Services on Select CDs in a way that means I won't be prompted for a license code? If not, what are you meant to do if your company has a global agreement with Microsoft? I'm almost at the point of going down to PC World to buy a copy of SQL Server, but I imagine this would be viewed very dimly by my company! There must be a sensible solution to this. I really need to know the answer to this VERY soon, so any help with this will really be appreciated. Thanks, Rich Tag: sqlserver ROWID ! Tag: 8463
  - 15
    - changing the internet port number of MS RS Server I tried to change the MS RS Server port from 80 to let's say 8080. But when going back to MS RS home page I have an error page from MS RS with the following message : "The underlying connection was closed: Unable to connect to the remote server." I can't solve this Could anybody help me. Regards, PS: OS is Win2K all Windows Updates, and IIS5 Tag: sqlserver ROWID ! Tag: 8462
  - 16
    - About dynamic URL link I want the URL link to be generated dynamically by a function written in a custom assembly. However instead of generating the link each time the link is clicked. The function only called once when the report is generated. Therefore that link always return the same value. How can i implement this? Thank you veru much. Tag: sqlserver ROWID ! Tag: 8460
  - 17
    - Combine rows data into a Column I have two tables, which you can call master and details. I want to pull data from master table and respective details from details table. Here are tables and data information. Master Table MID Description 1 Person â?? 1 2 Person -2 3 Person â?? 3 Detail Table DID MID Credit Card 1 1 Visa Card 2 1 Master Card 3 2 Visa Card 4 3 Visa Card 5 3 Master Card and I want report something like this: ================================= Description Credit Card ================================= Person -1 Visa Card, Master Card Person â?? 2 Master Card Person â?? 3 Visa Card, Master Card Now I am not sure this is possible in Reporting Services. Tag: sqlserver ROWID ! Tag: 8458
  - 18
    - Combine Detail rows in one column I have two tables, which you can call master and details. I want to pull data from master table and respective details from details table. Here are tables and data information. Master Table MID Description 1 Person â?? 1 2 Person -2 3 Person â?? 3 Detail Table DID MID Credit Card 1 1 Visa Card 2 1 Master Card 3 2 Visa Card 4 3 Visa Card 5 3 Master Card and I want report something like this: ================================= Description Credit Card ================================= Person -1 Visa Card, Master Card Person â?? 2 Master Card Person â?? 3 Visa Card, Master Card Now I am not sure this is possible in Reporting Services. Tag: sqlserver ROWID ! Tag: 8457
  - 19
    - Date enquiry How would I do a datediff between the date within a record in the dataset and an entered in parameter? The following works in giving me the difference from the record to now... but I need to change the now to the @to parameter. DATEDIFF([day], view.DATE, GETDATE()) AS noofdays Thanks Tag: sqlserver ROWID ! Tag: 8455
  - 20
    - How to set multiple Table on TWO pages Hi, In order to print the reports in PDF i fix my page size in 21X29.7 cm (Portait) in report properties This give me a work space where i can design In this work space i have plenty table . I need to add a Table , but there is no space left What can i do in order to keep this new table with the other Table (Same dataset), without pertubing rendering in PDF Thanks Philippe Tag: sqlserver ROWID ! Tag: 8454
  - 21
    - Recursive Data - Expand / Collapse Is it possible to toggle the visiblity of recursive data in a table to give the effect of expanding and collapsing the hierarchy. I have created a table that displays the content of my parent child table and indented it appropriately show the different levels, however I want to be able to expand and collapse the levels. I can easily create tables that with the expand / collpase functionality but the data has been in a flat structure - i.e. a column for each level. Is it possible to do it with a parent child structure. Any help on this would be much appreciated. Cheers KW Tag: sqlserver ROWID ! Tag: 8453
  - 22
    - Cannot restart report server Report Service stopped automatic and cant restart it in server. when i'm render a report, an error message occur as below: Exception Details: System.InvalidOperationException: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- Line 547:"", RequestNamespace:="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices", ResponseNamespace:="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices", Use:=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle:=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)> _ Line 548: Public Function Render(ByVal Report As String, ByVal Format As String, ByVal HistoryID As String, ByVal DeviceInfo As String, ByVal Parameters() As ParameterValue, ByVal Credentials() As DataSourceCredentials, ByVal ShowHideToggle As String, ByRef Encoding As String, ByRef MimeType As String, ByRef ParametersUsed() As ParameterValue, ByRef Warnings() As Warning, ByRef StreamIds() As String) As <System.Xml.Serialization.XmlElementAttribute("Result", DataType:="base64Binary")> Byte() Line 549: Dim results() As Object = Me.Invoke("Render", New Object() {Report, Format, HistoryID, DeviceInfo, Parameters, Credentials, ShowHideToggle}) Line 550: Encoding = CType(results(1),String) Line 551: MimeType = CType(results(2),String) anyone encounter this problem before, i really need help. thanks in advance. Tag: sqlserver ROWID ! Tag: 8450
  - 23
    - Info on Reporting Services Anyone have a source for detailed specs on this? Specifically inclusion of the ad-hoc interface like CR has? (ActiveView?) We are looking at a potential dump of CRE and using SRS if the funcitionality we need/want is there. thanks -- Curt Christianson Owner/Lead Developer, DF-Software Site: http://www.Darkfalz.com Blog: http://blog.Darkfalz.com Tag: sqlserver ROWID ! Tag: 8449
  - 24
    - PDF, Fonts, and Table Header or Group Header I have a table header or a group header. In this header, I have specified that I want the text underlined (text decoration). When the report is rendered to pdf it loses the underline. This does not happen to the data rows in a table. I have tested this on several reports, and it is consistantly an issue. I am using the same laptop to create the report, render the PDF, and view the PDF. Wouldn't that tell me that the fonts are installed? Is there anything else that I can do to get this font to generate correctly? BTW - this is on RS SP1. Tag: sqlserver ROWID ! Tag: 8448
  - 25
    - Validate Filter Input All How do I go about validating input that is entered into a filter without using a drop-list? ie. Validate that a date is in the correct format and not greater than today's date. Thanks Tag: sqlserver ROWID ! Tag: 8447

Hi everyone,

Just need to know how to issue a select clause to return a record physical
rowid just like the oracle statm:

select ROWID
from .. blah blah

thx for the help ..

Top

Re: sqlserver ROWID ! by Brian

Brian
Mon Sep 06 01:42:35 CDT 2004

Not sure of the SQL syntax but you could use RowNumber() in the report.

--
Brian Welcker
Group Program Manager
SQL Server Reporting Services

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

"MB" <buenomc@yahoo.ca> wrote in message
news:eK%Zc.26850$7i2.1117265@news20.bellglobal.com...
> Hi everyone,
>
> Just need to know how to issue a select clause to return a record physical
> rowid just like the oracle statm:
>
> select ROWID
> from .. blah blah
>
>
> thx for the help ..
>
>

Top

Re: sqlserver ROWID ! by noonie

noonie
Mon Sep 06 03:56:10 CDT 2004

Greetings,

> Hi everyone,
>
> Just need to know how to issue a select clause to return a record physical
> rowid just like the oracle statm:
>
> select ROWID
> from .. blah blah

SQL Server 2000 does not have this feature but it is rumored to be in
Yukon ;-)

You could use Reporting Services' RowNumber() as Brian suggests but if
you absolutely MUST do it on the Database Server then there are
work-arounds.

--
Regards,
Neale NOON

Top