Top n dynamic sql

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
    - Array in expression editor anyone? I'm kind of a newbie at all this and I'm wondering if I can do the following. Whithout having to use custom code is there a way to use the IN function in the expression editor? I'm currently using the following to accomplish something quite simple: =IIF((month(Fields!por_POSTING_DATE.Value) = 10 or month(Fields!por_POSTING_DATE.Value) = 11 or month(Fields!por_POSTING_DATE.Value) = 12), True,False) I'd like to use: =IIF(month(Fields!por_POSTING_DATE.Value) in (10,11,12),True,False) Can you not use an array in the expression editor (and only in custom code?) Thanks, Ryan Tag: Top n dynamic sql Tag: 5762
  - 2
    - Jump to URL Action in a New Window I've read countless postings now but haven't yet found an answer to this frequently asked question: "When using the Jump to URL option in the Action property of a textbox, how do you make that URL open in a new window?" Is it possible? Tag: Top n dynamic sql Tag: 5758
  - 3
    - Alternating line shading in a matrix Is there a way to do alternating line shading in a matrix where not every cell contains data? RowNumber isn't consistent in this case because it only counts cells that contain data. Michael Carr Tag: Top n dynamic sql Tag: 5757
  - 4
    - How to add Total to Matrx Column/Row Hi there, I have a report with 2 column groupings and 5 row groupings looks like this: +Unit +Time +Type +Sub_Type +Start +Result +Orig SUM(!Field1.Value) I want to add "Total" to every column and every row and final total like this: +Unit +Time +Type +Sub_Type +Start +Result +Orig SUM(!Fieldxx) Total_of_Row Total_of_Column Total How can I add a column at the right end and a row at the bottom? What kind of expression should I use? Thanks a lot. Henry Tag: Top n dynamic sql Tag: 5754
  - 5
    - Dynamic sort column data retrieval It is possible to change the sort property dynamically on the client side by clicking on column headings without making a round trip back to the data and refetching the entire dataset? I've got a clickable column sort working based off of a newsgroup post based off of the link below, but it appears to requery the database each time a column is re-sorted. Any help is greatly appreciated! Brent http://www.microsoft.com/sql/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=aeefab11-46bb-4a84-b140-770b808dc0c1 Tag: Top n dynamic sql Tag: 5750
  - 6
    - Conditional Font Weight I need to conditionally set the font weight of my data when a calculation is equal to or less than 70. I am using the following expression in the font weight property: =iif(( Fields!Answer1.Value/ Fields!SumStudents.Value)*100 <=70, "Extra Bold", "Normal") I get no errors when I run my report, however it does not apply the correct weith to my display. I am positive the calculation is correct since I use it in other conditions and they work fine. Any help would be apreciated. Tag: Top n dynamic sql Tag: 5746
  - 7
    - Session ID in Data Extension Is it possible to get the session id in Data Extension or Report Designer thanks Tag: Top n dynamic sql Tag: 5744
  - 8
    - UPgradring to latest trial ...but got an error at the end when it tried to start the report server - that was denyid - said something about rights and I could only choose to cancel which resulted in rolling back the entire upgrade. Does this have something to do with my operating system being danish ? http://support.microsoft.com/?kbid=832976 Didn't have any security problems when installing the first version. If i need to uninstall and i have one - two reports i need to keep is it enough to keep these files or do i need the old reportserver sql base .. or something else ? Michael Vardinghus Tag: Top n dynamic sql Tag: 5741
  - 9
    - Properties Expressions I can create an expression for the visibility property as follows: =iif(countDistinct(Fields!RefNbr.Value)=1,True,False) BUT when I try to do something similar for the fontweight property like =iif( Fields!Carryover.Value = 2 ,Heavy,Normal) I get the following error message Name Heavy is not declared ???? Tag: Top n dynamic sql Tag: 5733
  - 10
    - Determining a schedules references using Web Services Hi! I would appreciate any thoughts on the best way to determine using Web Services what the references to a schedule are when ReferencesPresent is true. Thanks for any ideas, Bob Tag: Top n dynamic sql Tag: 5722
  - 11
    - Error starting svc at end of install I get this error right at the end of installing the server components. Product: Microsoft SQL Server 2000 Reporting Services Developer Edition -- Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify that you have sufficient privileges to start system services. I am logged in as Administrator. It then decides to rollback the install. My machine is Win2k2003 with IIS6. Any ideas? Thanks, Dave Tag: Top n dynamic sql Tag: 5711
  - 12
    - Obtaining Reporting Services CD. Hi, I have been using the evaluation edition of RS but it has expired. I have ordered the CD from MS but it shows as backordered. I'm not sure how long it take to receive and I couldn't find any option to download from MS web site. Does anyone know if there is a download available? I'm in a bind as we are using some of the RS reports and cannot currently access them. Thanks in advance, Neal... Tag: Top n dynamic sql Tag: 5710
  - 13
    - mailto: hyperlink How do we put a mailto hyperlink in the report. I used an expression in 'Jump to URL' as ="mailto:"+Fields!email.value and it gives me error that it is an invalid URI: host name could not be parsed. Any suggestions. VR Tag: Top n dynamic sql Tag: 5704
  - 14
    - Create a modified version of an existing rendering extension Is there any documentation or sample code to point me in the right direction on how to modify an existing rendering extension? I need to add some browser checking to the existing JavaScript that is generated for the toolbar. I was hoping to modify the existing HTML 4.0 rendering to include some more browser checking to replace some of the specific IE JavaScript properties. Any help would be greatly appreciated. Thanks, Tag: Top n dynamic sql Tag: 5690
  - 15
    - Installing Reporting Services We are somewhat confused about the best installation configuration for Reporting Services. Should it be installed on its own IIS Server. Can we intall it to work by combining a current (non-IIS) SQL Server 2000 server and another (non SQL Svr) IIS Server? Should we add IIS to a current SQL Server 2000 and add Reporting Services to that. Of course we would prefer not incurring an additional SQL Server license if that is possible. Thanks for any help. Would be interested in what others are doing. Tag: Top n dynamic sql Tag: 5689
  - 16
    - Matrix Zero Values My Matrix presently shows results as follows. column 1 column 2 row 1 23 row 2 34 34 How would I make the default null value to display as zero. Eg. Row 1, Column 1 would have a value of 0 Tag: Top n dynamic sql Tag: 5686
  - 17
    - SSRS VS 2005 & desktop reporting I think reporting services is a great product and would like to be using it right now but unfortunately, what I need it for is for desktop applcations. I would like to use the product but avoid using it with a web server. My understanding is that in Visual Studio 2005 the ability to create reports using SSRS, without a web server, will be provided. I heard this some time back but have actually received confirmation of the fact. Does anyone know, can anyone tell me, if this is true? Thank You Tag: Top n dynamic sql Tag: 5683
  - 18
    - Transaction with a SubReport Hi, I have an MSRS report connected to SQL Server as the data source. In this report there is a main report and a subreport inside it. Both the main and subreport are procedure based reports. On execution of the main report, it creates a temporary table and stores data in it to be used by the subreport. Problem is that before the subreport uses this table, the table does not exist anymore. SubReport never runs. I have a feeling that somehow the transaction gets rollbacked and the table vanishes. I tried setting the option "Use Single Transaction" for the data source but it did not work. What could be the problem here ? Please help with this. Thanks Tag: Top n dynamic sql Tag: 5681
  - 19
    - Table within list Hi. I whant to use a table inside the list. The table must ganerate rows depend of count of only one filed returned by stored procedure. Is it possible? And What group expressions I must use ? Thanks. Tag: Top n dynamic sql Tag: 5677
  - 20
    - newline in format string Can I insert a newline character within a reporting services format string? I guess \n doesn't work since it is interpreted as a VisualBasic format string...? Is there an alternative? Thanks, Michael Carr Tag: Top n dynamic sql Tag: 5674
  - 21
    - CreateReport() method under ASP.NET CreateReport throws an error saying that user IUSR_XXXXX doesn't have permisssions to run this method. So, 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX user 2) Assigned ReportserverSysadmin role for the new group. 3) Also set db_owner permissions for the IUSR_XXXXX user in ReportService related databases on my local instance of MS SQL. No results. Still can't call method CreateReport(). Any ideas ? Thanks Paul PS. BTW this method works fine from *.rss script that is running under local Admin account. Tag: Top n dynamic sql Tag: 5670
  - 22
    - Subscription Email Problem Our local setup doesn't have the users Email address as their login. For example, my Email address is user@site.net, but my login is xxx1234. Unless I give users the authority to manage all subscriptions, reporting services does not allow them to change the "TO" block on their own subscriptions. It defaults to their login which results in undeliverable mail. Is there anyway that this can be changed so that an individual subscriber can modify this block ? Or is there any other way around this without setting up mail aliases on the main mail server? Tag: Top n dynamic sql Tag: 5667
  - 23
    - formatting I have a textbox on a report containing a number I want formatted in scientific notation. When I bring up the properties of the textbox, there is a formatting option. I select number and am given a choice of 1.234123e+003. This works great, but I really don't want to show that many number in the format. I would rather have the number something sensible, say 1.23e+03. It looks like the custom format option might give the ability to format the number this way, but I can't find any examples on how to use it. Any ideas? Thanks. Tag: Top n dynamic sql Tag: 5665
  - 24
    - Running a report to populate a cell Hello, I need to run several reports using the information in couple of cells of a table as input parameters, and eventually create a report combining the result from sub queries into one report. In other words: ColA ColB ColC ColD 9898 001 145 8789 000 454 I would like to run a query for every row using ColA and ColB as input parameter and populate ColD accordingly Is this possible in Reporting Services? Tag: Top n dynamic sql Tag: 5662
  - 25
    - showing % in Pie Chart I have a Pie chart which shows different sections. Is it possible to indicate the % figures in front of the sections? Thanks Tag: Top n dynamic sql Tag: 5654
- Next
  - 1
    - not generating reports automatically Hello, I want the report server to not start generating a report automatically, yet I want all report parameters to have a default value. Anyone having a solution? Thanks. Bjorn. Tag: Top n dynamic sql Tag: 5653
  - 2
    - Parameters Bar Hello, I would like to expand the size of parameters bar, is it possible with SP1? I have too many parameters to deal with and I don't want users to scroll through. Thanks. Regards, Cem Tag: Top n dynamic sql Tag: 5652
  - 3
    - Preview Problem!! I've set the pagesize to 11in, 8.5in and the body width to 10.5 to compensate for the margins. the preview views in landscape but when i try to export to pdf i get an "index out of range error." If I change the pagesize to 11in, 15in it works ok unless i drill down before the export, then i get the same error again. Tag: Top n dynamic sql Tag: 5647
  - 4
    - Enterprise license for Forms authentication is a too-expensive - please discuss Hi, We are developing a web-based reporting solution with Reporting Services, replacing Crystal Reports by integrating RS in with our existing web-application. We need to buy the Enterprise license(s) to enable us to do this, because only the Enterprise license comes with the custom authentication API that allows us to do ASP.NET Forms authentication and authorization. For us, this seems on the face of it to be an extremely expensive option. If the Enterprise Edition came with a security framework for the web out of the box, ready to go, then I would agree with the huge extra cost - but the fact is that it is only an API - you still have to code your own custom authentication components, and go through the (very) painful process of integrating them with RS (the one existing MSDN example for developing custom Forms authentication components is minimal to say the least, not well documented, and very tricky to configure). In our view we are being forced into buying an expensive product that far exceeds our needs in the short term, all because we want to enable Forms authentication to access reports on the web! For my two-pennies worth, I would like to suggest that Microsoft might consider re-adjusting the licensing requirements for RS to include the custom authentication API with the Standard Edition of SQL Server 2000. Does anyone agree with my view? Chris Lewis Tag: Top n dynamic sql Tag: 5646
  - 5
    - Formatting Problem in PDF after installing SP1 Hi Guys, I find a problem when displaying "Report Parameter Values" in the Page Header when there is no data present (not found by the query) in Detail Section. In Page header section the labels and Textboxes overlap each other, and when there is Data in the Detail section, Page Header elements look fine.. Did anyone else come across this problem. Regards Raj CHidipudi Tag: Top n dynamic sql Tag: 5642
  - 6
    - Catch Exception in Report viewer I'm displaying report in my webpage. I display it through report viewer's property. rptViewer.ServerUrl=http://www.myname.com/ReportServer // The Name of the Report rptViewer.ReportPath="/ReportName"; Now I want to catch exception if host name not found or Report server is not accessible or Invalid file name.. Which type of exception should i use and how to catch them ? I tried with System.Exception class but its enable to catch exception. Tag: Top n dynamic sql Tag: 5641
  - 7
    - Host not found Exception in Reports I'm displaying report in my webpage. I display it through report viewer's property. rptViewer.ServerUrl=http://www.myname.com/ReportServer // The Name of the Report rptViewer.ReportPath="/ReportName"; Now I want to catch exception if host name not found or Report server is not accessible or Invalid file name.. Which type of exception should i use and how to catch them ? I tried with System.Exception class but its enable to catch exception. Tag: Top n dynamic sql Tag: 5640
  - 8
    - Installing Reporting Services on Server without VS .NET Hi there, I have a problem I have struggling with for ages and still can't get it to work. I have a server with Win2k Server OS, Sql Server 2k Standard and .NET SDK installed on it. I need to be able to install reporting services on this server so that it can be used as the central repository for our reports developed on our development boxes. The development boxes are Win2k, .NET 2003 installed. How can I get it so that Reporting Services can be installed on the server as the central repository for all reports done on our development boxes so that when reports are deployed they deploy to the server and not the developments boxes, my current problem. I have noticed that there is meant to be a Reports and Reportserver virtual directory created in IIS, this is not been done on the server but is been done on the development boxes. Clearly to run our reports from our development boxes is not the solution and they need to run off of the server. Please can someone help? Tag: Top n dynamic sql Tag: 5639
  - 9
    - =?iso-8859-1?Q?Can=B4t_expand_a_hierarchy?= Hi, I have a report created in VS .Net 2003.=20 The hierarchy in the time dimension constist of the=20 fields Year, Quarter and Month . I can expand the=20 hierarchy in the preview. However, in the Reporting Services Browser i can=B4t expand=20 the hierarchy. Can anybody help me ? I use Windows Xp SP1 RS Developer Edition VS .Net 2003 =20 Tag: Top n dynamic sql Tag: 5638
  - 10
    - Re: Calling Webservice Hi Scott, Thanks for the input, but this user has been made a member of all of the roles defined within Reporting services. i.e "Browser", "Publisher","My Reports", "Content Manager". I've tried all combinations of these. No joy. The user has to be a member of the "Administrators Group" on the machine itself (it appears?). Scott Allen wrote: > Hi Amy: > > Reporting services uses roles based authorization, and the default > setup only places the local administrator into a role. > > While RSAdminUser might have rights to access all the files and > folders in the reporting services installation, you still have to put > the user into a "role". Roles are how RS determines who can browse a > folder, who can view a report, who can manage a data source etc. > > From your reports home page you can go to Site Settings -> Configure > site wide security (link is at the bottom). Perhaps you should define > a new role for RSAdminUser and grant just enough authorization for the > user to get the things done you need. > > Hope this helps, > > -- > Scott > http://www.OdeToCode.com > > On 3 Aug 2004 05:04:48 -0700, amydudley@webmail.co.za (Amy) wrote: > > >Hi, > > > >I have set the Reporting WebServices WebService Directory Security in > >IIS to Windows Authentication. The authentication setting in the > >config file is set to "Windows" with Impersonation set to "true". > > > >I created an account called "RSAdminUser" with which to call the > >webservice. > >When calling the "ListReportsUsingDataSource" method, after setting > >the credentials to this "RSAdminUser", I get the following error: > > > >"System.Web.Services.Protocols.SoapException: The permissions granted > >to user 'SERVER\RSAdminUser' are insufficient for performing this > >operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: > >The permissions granted to user 'SERVER\RSAdminUser' are insufficient > >for performing this operation. at > >Microsoft.ReportingServices.Library.RSService.ListReportsUsingDataSource(String > >path) at Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataSource(String > >DataSource, CatalogItem[]& Reports) --- End of inner exception stack > >trace --- at Microsoft.ReportingServices.WebServer.ReportingService.ListReportsUsingDataSource(String > >DataSource, CatalogItem[]& Reports)" > > > >I have methodically given this user permissions to all of the relevant > >folders and files that I can think of, but the only thing that makes > >this work is making "RSAdminUser" a member of the "Administrators" > >group. Is it possible that only members of the "Administrators" group > >are allowed to execute this method? > > > >Is there an alternative solution? What permissions does this account > >need to execute this method? > > > >Thanks in advance, > > > >Amy Tag: Top n dynamic sql Tag: 5636
  - 11
    - Installing to Server Hi there, I am trying to install reporting services on our server at work. It is a Win2k server OS, with SS2k on it. It does not have VS .NET installed. Is it possible for me to set up the server so that it is the central repository for all our reports and then develop and design the reports from my development box, which does have VS .NET installed? When I install SSRS on my development box it creates the Reports and ReportServer Virtual Directories on IIS but for the server it does not do this. Is there a way of moving these folders to the server from my development box or some way of getting this to work? I feel like I am banging my head against a brick wall at the moment, getting nowhere fast. Please any help would be great. Tag: Top n dynamic sql Tag: 5635
  - 12
    - SP1 Problems w/ Matrix Report I have a number of Matrix reports that all run fine on my server that is not patched with repoorting service SP1. However, when I run these reports on a server with SP1 loaded, I get the error message "An unexpected error occured in Report Processing" when I click on a tag to expand a hidden item. If I remove all the tags that open hidden fields and make all visible, the report runs. Is there a fix for this problem posted somewhere!! Tag: Top n dynamic sql Tag: 5630
  - 13
    - Is Forms Authentication available on Standard I have been looking at the forms authentication sample that creates a custom login page. After looking at the licencing am I right in saying that this can only be implemented using SQL server enterprise edition as standard edition does not have the security extension API. If this is the case is there any way to custom authenticate a user when using URL calls that is not windows Authentication? Tag: Top n dynamic sql Tag: 5620
  - 14
    - Report Deployment Hi, Two Things: 1a) I was wondering if there is the odd issue with redeploying a report in that some changes do not seem to be propagated. For instance, In one case I set default parameter values for a report - this would cause the report to automatically execute when browsing to it - I did not want this behaviour so I removed the default values and redeployed the report. The defaults were still there when refreshing the browser window - (even with closing and reopening the browser the paramter values have not been removed). 1b) As an aside, can you turn this behaviour off so the report does not run automatically if all parameters are preset? 2) Consequently, to ensure the report definition gets fully updated, I remove the report and redeploy. A side-effect of this is all the subscriptions are removed - and rightly so. However, the datasources for the subscription remain. Is there any reason why this is? thanks regards Matt Tag: Top n dynamic sql Tag: 5604
  - 15
    - Find Windows/SQL login used by RS What is the 'supported' way to find out which Windows/SQL login has been configured for RS to use when it connects to the report server database? RSconfig.exe doesn't seem to have a read-only option. Linchi Tag: Top n dynamic sql Tag: 5602
  - 16
    - Sybase & parameters Hello, Has anyone here used Reporting Services with Sybase ASE, through OLEBD??? I'm having trouble passing parameters values to the report, it says that the "given type name is unrecognized", when I pass a string parameter. Can anyone here help me about this, at least tell me if this tool fits on Sybase. Thanks Tag: Top n dynamic sql Tag: 5601
  - 17
    - Report Manager Config Error Hi; I just installed RS and it seemed to go ok. But when I try to access the Report Manager at localhost\reports, I get the following error: Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: The XML file c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not be loaded. Attempted to access an unloaded AppDomain. Source Error: [No relevant source lines] Source File: c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 0 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573 I've tried to run the rsconfig utility several times, but nothing has helped so far. Thanks for helping! Tag: Top n dynamic sql Tag: 5597
  - 18
    - rs:ParameterLanguage URL access parameter We tried setting rs:ParameterLanguage=en-US in the URL so international users dates would stay in the MM/DD/YYYY format but it isn't working. We have SP1 installed. Has anyone used this parameter successfully and if so do you have any suggestions??? Please help, our customers in the UK would like to be able to view their reports. Thanks! Tag: Top n dynamic sql Tag: 5595
  - 19
    - Changing Page Orientation for Sub Reports We have a "Master" report that contains several sub-reports. Some of these sub-reports we need to print in landscape orientation. We have been unable to figure out how to set the page orientation for sub-reports. We also looked to see if we could create "sections" (like MS Word) where we could configure page breaks and page orientation. Can anyone point us in the right direction? Thanks, Chris Tag: Top n dynamic sql Tag: 5584
  - 20
    - in-memory cache help Can you tell me more about Reporting Services' use of the in-memory cache? I am pretty sure I have an issue where a report export pdf is coming from in-memory cache and I need to go back and generate a new one. I have monitored the 'Total Memory Cache Hits' in Perfomance Monitor and I see that when I export the pdf, I increase the number of hits. I have only been able to clear it by restarting IIS. Any advice will be appreciated. Thanks. Tag: Top n dynamic sql Tag: 5580
  - 21
    - Bug report RS with SP1 Microsoft gang, I have the following query. if I use @Shipping instead of @CustomerShipTo as a parameter name, at the preview stage, I receive @StartDate not defined error. SELECT ProductType,Product, SUM(TotalCases) as TotalCases, UnitofMeasure, DatePart(yyyy, DDate) as YDate, DateName(mm,DDate) as MDate FROM fn_CreateBlankSalesCases(@StartDate,@EndDate,@Broker,@Customer,@CustomerShip To) GROUP BY ProductType,Product,UnitofMeasure,DDate Regards, Cem Tag: Top n dynamic sql Tag: 5579
  - 22
    - Architecture resources for robust output generation systems. ENVIRONMENT: Win2K3 Server Windows Forms and ASP.NET clients SQL Server 2000 Greetings, Looking for any good MS links (or resources) concerning design patterns and architecture for design of robust output generation systems utilizing SQL Reporting services, ideally discussing the following: > Multiple output rendering (PDF, Excel, XSL, etc.) > Ad-hoc reporting capability (client-side) > Report (output) management (server-side) including >> monitoring >> print queue management >> scheduling >> etc. > Report distribution > Scalable design patterns for high throughput report generation. > Printer hardware suggestions, etc. Thanks in advance. Bert Nieves Software Consultant bert@nanocube.net Tag: Top n dynamic sql Tag: 5573
  - 23
    - Administrator with No Report Manager Privileges I am logged on as a user with administrative privileges to my machine, to the machine housing the report server database, and to the the web server, yet when I go to Report Manager, I do not have access to the Home folder, only one lower folder, and no Site Settings for anything. How do I add the necessary privileges if I'm already the administrator? Tag: Top n dynamic sql Tag: 5567
  - 24
    - Blank Parameters Hi, i would like to know how i can let a user have the option to enter in 1 or 2 parameters. EG. select * from customer where ContractSigned = @Parm1 and ContractReceived = @Parm2 i would like the user to have the option to enter in either the signed date, received date or even both. I have tryed using the "Allow blank value" option with no luck Thanks, Sundeep Tag: Top n dynamic sql Tag: 5563
  - 25
    - Date Formats and local IE settings We have reports available on the web that take begin and end dates in US format (i.e. 08/02/2004 for August 2, 2004). When our international customers try to render the report the dates get converted to the date setting they have on their local IE, so the date then looks like 02/08/2004 for August 2, 2004. The report then pulls back data for February 8, 2004. Does anyone know of a work around for this? Tag: Top n dynamic sql Tag: 5556

I would like to use a top n query as the source for my
report where n is a parameter. Can I use the sql embedded
in the report for this or do I have to use a stored
procedure?

In general, can I use dynamic sql for my report?

TIA,
Dave

Top

Re: Top n dynamic sql by Ravi

Ravi
Thu Aug 05 18:32:03 CDT 2004

Use a query expression as follows: ="select top " &
Parameters!Report_Parameter_0.Value & " * From titles"

--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave Foderick" <spam@islove.com> wrote in message
news:105801c47b3d$b0b797e0$a401280a@phx.gbl...
> I would like to use a top n query as the source for my
> report where n is a parameter. Can I use the sql embedded
> in the report for this or do I have to use a stored
> procedure?
>
> In general, can I use dynamic sql for my report?
>
> TIA,
> Dave

Top