user of parameters in Named Query with report model

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
    - Subsciptions for SSRS using SSAS data reports I am trying to setup and test whether data-driven subscriptions will work with SSRS reports that use MD data from SSAS. When I create a data source in Visual Studio all choices in the credentials tab get greyed out as soon as I switch from Sql Server Client to SSAS provider. Consequantly, I can't create subscriptions for the reports using this data source (get a message about not having any "stored credentials"). Is there any way to use data-driven subscriptions with SSAS reports? If yes, how can I set them up? If not, is this a temporary limitation? Thanks, Koni. Tag: user of parameters in Named Query with report model Tag: 47507
  - 2
    - Parm query request It would be a bit easier to allow query string option right next to "From Query" in Report parms so that you would not have go and create a DataSet first. -- William Stacey [MVP] Tag: user of parameters in Named Query with report model Tag: 47503
  - 3
    - Scan a report document into SSRS and use as a template? Hi all. So, I have an extremely busy/complicated form that has hundreds of fields and incarnations on each page/report. What I'd like to do is scan the forms in and then use that scanned image as a template in SSRS...Just assign data to the fields..... I know Crystal does this..and filemaker pro... I can't find anything on SSRS showing it supports this..... Anyone? Thanks, Steve. Tag: user of parameters in Named Query with report model Tag: 47500
  - 4
    - Cannot select Provider in Data Source Wizard Connection Manager I think I either have an option set wrong or installed something wrong. When I try to create a New Data Source in Data Model project, the dropdown box for Provider is disabled and so SQLclient Data Provider is all I can do. I would like to add a connection to an ODBC data source, which I should be able to do. Any suggestions on what I can change to enable me to select the Provider? Tag: user of parameters in Named Query with report model Tag: 47497
  - 5
    - Formatting issues with Subreports I have a report with a couple of subreports within it. The formatting looks fine on the page, but when you print it, it screws up all the margins. Is there a way to fix this? Tag: user of parameters in Named Query with report model Tag: 47491
  - 6
    - Returning data from a class into a report parameter Hi, I need to return a list of possable options for the user to select in a parameter. I can write the class no problem, but i dont know what the correct way is return the data into the report, then add the values to a drop down parameter. I could return the list as an array, but how do i then remove the parts of the array in the report and add them into the parameter list? Thanks Tag: user of parameters in Named Query with report model Tag: 47489
  - 7
    - SSIS and SSRS integration Hi I'm trying to set up a Reporting Services report which consumes data from a SSIS package. I have a really simple package which just one data flow task. This task "transfers" a few records from an OLEDB connection to a DataReader Destination. When I try to consume these data in the Report Designer, Visual Studio gives me this errormessage: "An error occurred while reading data from the query result set. The SSIS IDataReader is past the end of the result set." I click OK and the error keeps coming back (infinite loop), so I have to terminate VS2005 "the hard way", of course losing all my changes :-( Possibly related: when I try to execute the dtsx package (directly in SSIS designer), the package does not fail, but it doesn't succeed either - the "building blocks" stay yellow, and don't become green. What am I doing wrong? I followed the instructions from BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/a5e88a03-b703-400a-87f5-3cdaa8440028.htm thanks in advance for any feedback ! Nico Tag: user of parameters in Named Query with report model Tag: 47488
  - 8
    - Reports Deploy. Hi, I have my report test environment in a LAN and the production environment in another LAN in another country. The production environment doesn't have Visual Studio. I want to know if there's another way to deploy reports in Report Server without to use the Visual Studio. Or, can I to deploy from my machine with Visual Studio to Report Server in another LAN?? Thanks in advance. Tag: user of parameters in Named Query with report model Tag: 47484
  - 9
    - Folder has disappeared We have a folder which has disappeared in Reporting Services. When I try to add a new folder with the same name, I get an error stating that a folder with that name already exist. I think something is out of whack in the backend database. Anyone know the easy fix for this? -- Thanks, Danny Bader Tag: user of parameters in Named Query with report model Tag: 47479
  - 10
    - User account properties issue after domain account change Hi, We have the following issue with MSRS 2000. We have a user domain\jchapell. His domain account has changed to domain\jchapel (single L) His has Content Manager rights on all reports in one specific folder. However, since the change of his account he cannot manage report properties. He is getting "Insufficient rights" error. He can manage everything else, but "Properties" of the report. We noticed that the username in the database was not changed - possible bug, so we updated the users table to reflect his new user_account - domain\jchapel For some reason it is still not validating him correctly when he wants to view "Properties" of the report. Any ideas? Thank you Tag: user of parameters in Named Query with report model Tag: 47476
  - 11
    - Reporting Services SharePoint Web Parts Download Hi All, In reading the article, "Using Reporting Services SharePoint Web Parts..." article (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx), it mentiones downloading the web part cab file from the SharePoint Products and Technologies Web Component Directory at http://www.microsoft.com/sharepoint/downloads/components/default.asp . I can't seem to find this download? Any suggestions where it is located? Thanks, wg Tag: user of parameters in Named Query with report model Tag: 47475
  - 12
    - Setup could not initialize the report server After a successful re-install of Reporting Services I get the message: Setup could not initialize the report server. You must manually initialize the report server before using it for the first time. For more information, see the Reporting Services setup documentation I then run this: Rsactivate â??c "c:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.configâ?? and receive this message Either the WMI provider or the path to the local config file must be specified. Any help would be greatly appreoceiated :) Tag: user of parameters in Named Query with report model Tag: 47474
  - 13
    - C:\WINDOWS\TEMP\xxxxxxxx.dll error in RS Wanted to share a fix for C:\WINDOWS\TEMP\xxxxxxxx.dll error in RS Hi Simon, I was able to fix a similar problem with the same exact symptoms (C:\WINDOWS\TEMP\xxxxxxxx.dll error whenever any link in Report Manager was clicked on. Additionally, RDL's could not be uploaded to RS from Report Designer). In IIS Manager, stop and restart the app pool that Report Server uses. By default, 'Report Server' gets created under the 'DefaultAppPool' - so look there first and you'll likely see it. So right click on 'DefaultAppPool' and select stop, then start again. Hopefully this works. In my environment, this corrected the problem. There are settings in the Report Server app pool for worker processes and for security (like the account used) that may need to be adjusted to fix the problem long term if you continue to re-experience the error. HTH Matt Arabas www.reportarchitex.com ------------------------------------------------------------------------------------------ Simon Gold Sep 5 2005, 7:52 pm show options Newsgroups: microsoft.public.sqlserver.reportingsvcs From: "Simon Gold" <SimonG...@discussions.microsoft.com> - Find messages by this author Date: Mon, 5 Sep 2005 17:52:45 -0700 Local: Mon, Sep 5 2005 7:52 pm Subject: dll not found error. Reply to Author | Forward | Print | Individual Message | Show original | Report Abuse My reporting services are having a strange problem. It works for a few hours and stops giving me "Could not find file "C:\WINDOWS\TEMP\gyk5fpma.dll" error. The name of the dll is different every time but always a bunch of senseless numbers and letters. If i restart the IIS service from COntrol Panel, it starts to work again, but quites in 3 - 4 hours . Sometimes faster, sometimes slower. Any ideas why it happens? I am fighting it for a quite a while. Thanks, Simon Gold Tag: user of parameters in Named Query with report model Tag: 47472
  - 14
    - Sharepoint Reports Pack Looking for anyone that is using or has knowledge regarding the Reportings Services Report Pack for Sharepoint... it involves so many different processes it's hard to determine where to post for help. I have been somewhat successful implementing the Sharepoint Report Pack on a development enviroment however the DEP log ends in an failed error that I know I caused but need to understand if it can be corrected. Data extraction failed at 1/13/2006 8:34:36 AM... Details: System.Data.SqlClient.SqlException Invalid object name 'dbSPSReporting.dbo.tblProcessAudit'. There are some records inserted in the tblProcessAudit regarding successful steps the last being 'usp_Insert_FactSiteStorage - Insert Rows FactSiteStorage' - Is that the last step? When running the db creation scripts I renamed the dbSPSReporting to devSPSReporting and all references in the stored procedures etc. I'm afraid there is something hard coded in the DEP that I either need to change or go back and re-install the databases. The DEP runs with the same 'WARNING: Unable to access the the folders for the site "C9" at the URL http:...' that I've seen posted but evidently those are just to be ignored. Is there a way to remove them? Any suggestion or pointers to additional help (other than the deployment guide which I have scoured) would be greatly appreciated! AB Tag: user of parameters in Named Query with report model Tag: 47471
  - 15
    - Is it possible for columns to use all available space in the screen Hi, Is it possible for the actual report columns to utilize all available space on the screen, i.e, is it possible to dinamically set the width of th columns in a report. thanks, Matthias Tag: user of parameters in Named Query with report model Tag: 47468
  - 16
    - Stand alone reporting services? Trying to deal with infrastructure policy issues and had a thought about placing reporting serives on our web server. That is 2005 Reporting Services. Our SQL server is 2000 and policy prevents us from moving up to 2005 SQL Can SQL Reporting Services be deployed to a box without SQL and does the 2005 Reporting services require sp 1 on 2003 server? Tag: user of parameters in Named Query with report model Tag: 47466
  - 17
    - Subscription Schedule shows 1/1/0001 When i try to edit a previously created schedule the Only choice available to me is "Set Schedule" and "On a custom schedule" the text below reads At 12:00 AM on 1/1/0001. When pressing the Set Schedule button I get the following error, pasted below. Also this is happening in the Microsoft SQL server Management Studio, and the Schedule was create in the studio. It has happened before and is now happening all the time. Help? TITLE: Microsoft SQL Server Management Studio ------------------------------ Value of '1/1/0001 12:00:00 AM' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'. Parameter name: Value (System.Windows.Forms) and: at System.Windows.Forms.DateTimePicker.set_Value(DateTime value) at Microsoft.SqlServer.Management.UI.RSUserInterface.ScheduleDefinitionCtl.LoadScheduleDef(ScheduleDefinition def) at Microsoft.SqlServer.Management.UI.RSUserInterface.ScheduleDefinitionCtl.set_ScheduleDefinition(ScheduleDefinition value) at Microsoft.SqlServer.Management.UI.RSUserInterface.CustomScheduleDialog.set_ScheduleDefinition(ScheduleDefinition value) at Microsoft.SqlServer.Management.UI.RSUserInterface.SubscriptionTriggerControl.btnScheduleSelector_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Tag: user of parameters in Named Query with report model Tag: 47465
  - 18
    - Dynamic databinding with Report Viewer in ASP.NET 2.0 How do I use my own custom data in xml in a local report viewer in ASP.NET 2? I have tried to convert the xml to a dataset - but I cannot find any way to use it to the report. I'm trying something like this: // Convert xml to dataset dataset = new DataSet(); System.IO.StringReader sr = new System.IO.StringReader(string_with_some_xml); dataset.ReadXml(sr); // Create report using ReportViewer Microsoft.Reporting.WebForms.ReportDataSource rds = new Microsoft.Reporting.WebForms.ReportDataSource("AddressList", dataset); ReportViewer1.LocalReport.DataSources.Add(rds); But in the report designer... how do I connect to the dynamic dataset? Any help and/or examples would be much appreciated. Nikolaj Tag: user of parameters in Named Query with report model Tag: 47461
  - 19
    - SQL server 2005 - Business Intelligence Development Studio - Excel Driver problem Hello, I want to create a report model using the new Business Intelligence Development Studio which comes with SQL Server 2005. I have successfully created a data source and data view in BI dev studio and can right-click on the view & 'Explore Data' which works fine. When I come to creating the Report Model with the 'Report Model Wizard', I get the following error when clicking 'Run' to complete the wizard: ERROR [42000] [Microsoft][ODBC Excel Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE' My datasource is a system DSN using the Excel Driver (version 4.00.6304.00) which ships with Windows XP. I have a named data range in the spreadsheet which I then select in for the data view in BI dev studio. To show that the driver is working with other apps, I've written a simple ASP page which uses ADODB to call the same system DSN and output the results of the data-range. This too works fine. Why am I getting an error on generating the model? Is there any fix for it or alternatively a work-around? My set-up: Windows XP SP2 with all latest hotfixes from WindowsUpdate SQL Server 2000 SQL Server 2005 Reporting Services & BI Dev Studio .NET framework 2 Many thanks, Kieran Tag: user of parameters in Named Query with report model Tag: 47459
  - 20
    - How to send a report by email Hello! I'm trying to send reports by email. So, I create subscription in the report manager with a correct email adress for the destination. The planification is everyday at 8h00. But nothing append. I never receive a report. I don't know what's happend. Can you help me . Thanks Regards Arnaud Mailly Tag: user of parameters in Named Query with report model Tag: 47454
  - 21
    - RSClientPrint on Terminal Server clients? How can we install the RSClientPrint on Terminal Server clients. The users have no install rights, and this needs to be done centrally. From what little information I've found, you can install it manuall, but how can it be done on a Terminal Server? All help appreciated!!! Kaisa M. Lindahl Tag: user of parameters in Named Query with report model Tag: 47453
  - 22
    - Multi-Select Value dropdown "Select All" Problem Hi, I hava report (RDL) which is having a parameter called Plan Owner, i want the facality of "Select All" in the dropdown, this i can achive through setting the parameter as Multi-Value. But the problem is if the user select "select all" from dropdown, i uses the IN claues, i want to avoid the use of IN clause if the "select all" is selected in Multi-value dropdown. How can i programatically write the dataset to avoid "select all"? What is the internal value of "select all" which it added automatically in the multi-value parameter dropdown. I can provide more info if needed. Regards, Sumit Tag: user of parameters in Named Query with report model Tag: 47452
  - 23
    - Help with Report... Hello experts.. I have a report which has a single group. This group contains a header, details and the footer. The group header is repeated on each page and the page break is inserted after the group footer. Thus after every group a new page is created. The number of rows that are contained within the details section is dynamic depending on how many records that the group has at execution time, also if a row within details contains a zero balance this row is hidden. When the number of row within a group extends past a single page it will carry on to the next page... and page header repeats...and then the footer will be displayed.. This is where I am having an issue: If the total number of rows of the details section is just contained within a single page for some reason the footer line will appear on the next page. When this occurs this second page will for some reason not display the header (because the page break is added to the group, so as it is after the footer it believes it is still on the same page) I want the header to be repeated on every page irrespective of there being details. What is the best method for achieving this? Bing Tag: user of parameters in Named Query with report model Tag: 47450
  - 24
    - Multivalued Parameters in Data Processing Extension This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C61827.366556C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am writing a Data Processing Extension(DPE) to retrieve data from a = custom datasource following the article at = http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/RSPROG= /htm/rsp_prog_extend_dataproc_5c2q.asp But the article and the example does not talk about supporting = multivalued parameters. Also when i used the DPE for multivalued = parameters, it gave me an error saying "Multivalued Parameters" not = supported.=20 Is there any specific interface to be implemented for supporting = multivalued parameters. I have already implemented IDataParameter and = IDataParameterCollection. Is there any specific function to be = implemented within any of these to classes to support Multivalued = parameters. Thanks for the help, Sumit Pilankar ------=_NextPart_000_0019_01C61827.366556C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I am writing a Data Processing = Extension(DPE) to=20 retrieve data from a custom datasource following the article at = </FONT><A=20 href=3D"http://msdn.microsoft.com/library/default.asp?url=3D/library/en-u= s/RSPROG/htm/rsp_prog_extend_dataproc_5c2q.asp"><FONT=20 face=3DArial=20 size=3D2>http://msdn.microsoft.com/library/default.asp?url=3D/library/en-= us/RSPROG/htm/rsp_prog_extend_dataproc_5c2q.asp</FONT></A></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>But the article and the example does = not talk about=20 supporting multivalued parameters. Also when i used the DPE for = multivalued=20 parameters, it gave me an error saying "<STRONG>Multivalued = Parameters</STRONG>"=20 not supported. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Is there any specific interface to be = implemented=20 for supporting multivalued parameters. I have already implemented=20 <STRONG>IDataParameter</STRONG> and <STRONG>IDataParameterCollection.=20 </STRONG>Is there any specific function to be implemented within any of = these to=20 classes to support Multivalued parameters.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks for the help,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Sumit = Pilankar</FONT></DIV></BODY></HTML> ------=_NextPart_000_0019_01C61827.366556C0-- Tag: user of parameters in Named Query with report model Tag: 47449
  - 25
    - Passing Multivalued Parameters through URL interface Hi, We are trying to generate report by passing parameter values through url In our report, we have a multivalued parameter named "ABC", having values say, val1, val2 and val3. When try to generate the report with parameter ABC having values as val1 and val2 using the url mentioned below, we find that the values are not selected and report is not rendered. http://<machinename>/ReportServer/Pages/ReportViewer.aspx?<reportpath>0&rs:Command=Render&parameter=val1,val2 This is working fine for singlevalued parameters. Thanks in advanced, Sumit Pilankar Tag: user of parameters in Named Query with report model Tag: 47448
- Next
  - 1
    - SQL 2000 RS -> SQL2005 RS Hi, Hopefully someone can help me answer a few quick questions I have regarding transitioning over to SQL Server 2005. 1) Forms Authentication Extension ---------------------------------------- Is the installation and configuration the same for SQL Server 2005 RS? Does a new extension need to be developed or can I use the existing extension we have written for SQL Server 2000 RS. 2) Delivery Extensions ---------------------------------------- Has the API or configuration of delivery extensions changed in SQL Server 2005 delivery extensions? I have a fax delivery extension I have written and I'd hate to have to go back and rework that code. 3) Web Service Methods ---------------------------------------- Have the web service methods changed in SQL Server 2005? I have report written a report manager/viewer and batch report genarator/scheduler (think point + click subscriptions, its pretty slick ;) ) that relies heavily on the web services exposed in SQL Server 2000 RS and would like to know if I can just point this at a SQL 2005 RS installation or if I am going to have to go back in write a new version for SQL 2005 RS. I just installed SQL Server 2005 today so I am off to read the FAQ and see if I can answer some of my own questions. I find answers before getting any replies I will add the answers to this thread to help others in similar situations. Thanks, Nick Tag: user of parameters in Named Query with report model Tag: 47442
  - 2
    - rotate a text box 270 deg I am trying to rotate text in a text box by 270 deg, I have read I can use tb-rl but when I enter this into the direction Propertie of the textbox I get an invaild Direction error. Any Ides Using VS 2005 & RS2005 Tag: user of parameters in Named Query with report model Tag: 47440
  - 3
    - Failed to access IIS metabase When trying to access http://machinename/Reports I receive the error above. I installed sql reporting services 2005 and sql server 2005 on a local xp pro machine. IIS is running. I can access the http://machinename/IISHelp page just fine. I did the aspnet_regiis -ga that it suggested and stopped and started IIS and still get the same error. Any help of course would be greatly appreciated. I'm trying to convince others here that Reporting Services and SQL 2005 is the way to go for us. Here is the rest of the error: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase. The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/?kbid=267904. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [HostingEnvironmentException: Failed to access IIS metabase.] System.Web.Configuration.MetabaseServerConfig.MapPathCaching(String siteID, VirtualPath path) +3492138 System.Web.Configuration.MetabaseServerConfig.System.Web.Configuration.IConfigMapPath.MapPath(String siteID, VirtualPath vpath) +9 System.Web.Hosting.HostingEnvironment.MapPathActual(VirtualPath virtualPath, Boolean permitNull) +163 System.Web.CachedPathData.GetConfigPathData(String configPath) +382 System.Web.CachedPathData.GetConfigPathData(String configPath) +243 System.Web.CachedPathData.GetApplicationPathData() +68 System.Web.CachedPathData.GetVirtualPathData(VirtualPath virtualPath, Boolean permitPathsOutsideApp) +3385647 System.Web.Configuration.RuntimeConfig.GetLKGRuntimeConfig(VirtualPath path) +189 -- Mike Voissem Lead Software Engineer Donnelley Marketing Tag: user of parameters in Named Query with report model Tag: 47438
  - 4
    - Scheduled Jobs and Credentials Question This is a two part question: 1. I have set up a Execution Account for my scheduled jobs, but when attempting to append a report to the scheduled job I get a "Credentials" error with the data source. The only way I've been able to get around this is to hard code the credentials in the data source property for each of the reports. This won't work for me in the long term. What can I do other than fill in the Execution Account in the RS Configuration Manager? 2. I have a set of tables that require higher levels of security, but the data depends on Scheduled jobs. Do I need to set up the credentials on a report by report basis (for security reasons), or can I set up the Execution Account to kick off the reports and validate permissions through some other means? Any feedback would be highly useful. Thanks Tristian Tag: user of parameters in Named Query with report model Tag: 47437
  - 5
    - List grouping pagination problem I have a simple Master/Detail report with a list for the details. I'm trying to get it to only show a specified number of details on each page. So I added a group to the list with this expression: =System.Math.Ceiling(RowNumber(Nothing)/3) and checked the page break at end. Here's the problem, it only shows the first row on each page. For example on the first page it only shows the first row, on the second page it only shows the fourth row, etc. Anyone know what happened to the other rows? I wanted rows 1-3 on the first page, not just row 1. thanks. Tag: user of parameters in Named Query with report model Tag: 47436
  - 6
    - Appending a Custom SQL where clause in adhoc reporting useing Report Model I am in the process of evaluating SSRS 2005 to replace an home grown reporting tool. In my reporting application all users have access all the tables\fields in the database. In the home grown tool, data security is implemented by the following mechanism. When users run reports, a standard sql where clause is appended to the sql generated by the reproting tool. ( for eg: 'AND sysem_id IN (SELECT System_id FROM Mdu_system where user_id=@userID') I am trying to make use of Report Model so that my users can create adhoc reports based on the report model. In all the adhoc reports created by my users based on a report model is there a way in I can append a standard where clause similar to the one above to every report just before it is run? Does it have an event model, I can hook into? Also Is there any I could pass in a userID (Not NT) tot the reporting tool and use it to replace the parameter in SQL generated? Thanks _GJK Tag: user of parameters in Named Query with report model Tag: 47429
  - 7
    - IE browser closes down when running reports When I click on the link for the report in SQL Reporting Services, the report tries to open up, and then my browser closes down. The report works fine in Visual Studio 2003, and was deployed with no errrors. Any help would be appreciated. Thanks, Ron. Tag: user of parameters in Named Query with report model Tag: 47427
  - 8
    - Start Shared Schedules Programatically I have a bunch of reports that need to be kicked off after a DTS package or some other event happens, how can I do this programatically from DTS or some other dependency scheduler. Example, Job A Job B Job C Reports Generated So, a user kicks off Job A, Job B is then executed by the scheduler and if it succeeds it kicks of Job C, it that suceeds then the Reports tied to a Shared Schedule are all kicked off. Tag: user of parameters in Named Query with report model Tag: 47425
  - 9
    - Pass multi value parameter to another report I have two reports, ReportA and ReportB. In ReportA I have a hyperlinked field that when cliked opens ReportB. ReportB must then be filtered on the values of the multi value parameters selected in ReportA. My question is: How do I pass multi value parameters to another report? Thanks in advance for your help! Tag: user of parameters in Named Query with report model Tag: 47423
  - 10
    - POSTing report parameters We are having an issue POSTing report parameters to reporting services. One of our report parameters can be very long (hundreds or even thousands of characters) and is far to long to pass on a URL. Our solution has been to POST the parameter, which does work, but not quite as we want it to. We only need to provide a single parameter to the reprt as all the others have default values. The report generates and displays results as expected, however the parameter selection and report navigation section is not visible on the report that is rendered. If we POST the parameters, is it possible to get the parameter selection and report navigation sections to show? and, if so, how? The report is being called from a custom app which passes the parameter to the report. This is how we call our report: http://sidev/ReportServer?/tbi/development/Report200_GIS The POST data is: XMLFarmIDs=<TbI>.....</TbI> Tag: user of parameters in Named Query with report model Tag: 47422
  - 11
    - Customize where clause c# (RDL) We have may reports that need to customize the where clause based on parameters entered by the end user. Is there a way to modify the RDL on the fly in order to achieve this? I am using VS2005 and SQLServer 2005. Example: if user selects run report by week ending date the following line needs to be used "and we_dt between ??? and ??? if the user selects the run the report by export date then the line changes to: "and export_dt between ??? and ??? Tag: user of parameters in Named Query with report model Tag: 47420
  - 12
    - Querying complex XML - (XPath does not work) Teo et al - We have been investigating on "specifying the queries" for querying the XML while building the Data Sets in Visual Studio. We would like to share our investigations with the forum. This is applicable to SQL Server 2005 and Visual Studio 2005. Data Source is URL Addressable XML content. Here is the sample XML file. <?xml version="1.0" encoding="utf-8" ?> <NODE_ROOT time="09:50:11" author="Tester"> <User id = "id10" name = "user_10" email = "user_10.msn.com" person_ref = "#id25"/> <User id = "id11" name = "user_11" email = "user_11_msn.com" person_ref = "#id26"/> <User id = "id20" name = "user_20" email = "user_20_msn.com" person_ref = "#id27"/> <Person id = "id25" FirstName = "Joe" LastName = "Doe" DOB = "01/16/1979"/> <Person id = "id26" FirstName = "Jared" LastName ="Kassa" DOB = "01/16/1950"/> <Person id = "id27" FirstName = "Jhon" LastName ="Q" DOB = "01/16/1967"/> </NODE_ROOT> So here is what I have done to select a user node : Node_Root/User - This gives us the User list Node_Root/Person- this gives us the Person list However, it does not seem to be possible to combine the attributes from two different nodes using a common reference. For example, from this XML file, We would like to produce a dataset which has the following fields: Email, DOB, LastName, FirstName However, NODE_ROOT{Person{@FirstName,@LastName},User{@email}} - gives me only the first record but I have three of them. How do we combine them , I tried Node_Root/User union Node_Root/Person - does NOT work Node_Root/User | Node_Root/Person - also does NOT work. I would like to select the Email, DOB, LastName, FirstName fields and should be based on person_Ref. Here are our findings. Please correct us if we are jumping to conclusions. [1] We realized that XPATH expressions in the xml query do not work. Very limited set of XPATH expressions are supported For example, XPATH supports // [ ] expressions. But these are not recognized in the qeury. Also, I am not sure how Teo picked up the syntax (thanks Teo, it helped us to proceed to some extent) of using { } instead of [ ]. See http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/8b9a0464d29d204f/f7daf6328b8c9c8d?q=Jasthi&rnum=4#f7daf6328b8c9c8d for reference [2] Nodes, Nested Nodes, Nodes of the different types in the same XML, Attributes against each node - we can construct the queries in all the cases. [3] The BOL documentation on XML queries is very sketchy. It provides very very simple examples. But in practice, the XML content is very rich and structured. [4] However, if two nodes are related by an attribute, it doesn't seem to be possible (or we couldn't figure out) to construct the data set. To paraphrase the above XML, <person id="#100" name="mike"> <phone id="100" name="nokia" /> <person id="#200" name="tom"> <phone id="200" name="samsung" /> All that we want to produce from this snippet is .. Person Phone --------------------- mike, nokia tom, samsung But we couldn't figure out how. We managed to combine these, but it produced only 1 record. Not two. thanks - jasthi Tag: user of parameters in Named Query with report model Tag: 47418
  - 13
    - Changing data sources? Is it possibly to dynamically specify a DataSource for a report? I want to design a report, and then during rendering specify exactly where to get the data. The various datasources would point to different databases, and possibly different servers, but the table structure is always the same. Thanks! -mdb Tag: user of parameters in Named Query with report model Tag: 47416
  - 14
    - SRS license expired On of my server i had installed SRS Evaluation edition and its expired. I got a license for Standard version. I have some test data in the database. Report service is stopped. S/w details: SQL2000 Std ediition (SP3) SRS Evaluation edition(Microsoft SQL Server Reporting Services Version 8.00.1038.00). Whats the best way to migrate without loosing the data. Note: I was trying to use this article.. http://support.microsoft.com/kb/836064/en-us While trying to back up the symmetric encryption key, getting error message: "reporting server not responding." Any help is appreciated. Tag: user of parameters in Named Query with report model Tag: 47412
  - 15
    - Appending a custom sql where clause Hello, I am in the process of evaluating SSRS 2005 to replace an home grown reporting tool. In my reporting application all users have access all the tables\fields in the database. In the home grown tool, data security is implemented by the following mechanism. When users run reports, a standard sql where clause is appended to the sql generated by the reproting tool. This standard where clause has @userID as the parameter. Now is there a way in SSRS 2005 I can append a standard where clause to every report just before it is run? Does it have an event model, I can hook into? Thanks _Gigi JK Tag: user of parameters in Named Query with report model Tag: 47411
  - 16
    - can't get to report manager My company recently upgraded to CRM 3.0 and i was trying to get to the report manager page in my browser to make custom reports. Unfortunately, whenever i try to go to the report manager page i get the error listed below. Has anyone ever seen this before? Thanks in advance for any help you can give me. Server Error in '/ReportMgr' Application. -------------------------------------------------------------------------------- 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: Assembly microsoft.crm.platform.proxy.dll security permission grant set is incompatible between appdomains. Source Error: Line 15: <add assembly="Microsoft.Crm.ObjectModel, Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> Line 16: <add assembly="Microsoft.Crm.Platform.ComProxy, Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> Line 17: <add assembly="Microsoft.Crm.Platform.Proxy, Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> Line 18: <add assembly="Microsoft.Crm.Platform.Server, Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> Line 19: <add assembly="Microsoft.Crm.Platform.Sdk, Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" /> Source File: c:\inetpub\wwwroot\web.config Line: 17 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 Tag: user of parameters in Named Query with report model Tag: 47409
  - 17
    - Display Percent in Matrix group Is there a way to display the percentage instead of the value for the Group based on the sum of that group? Tag: user of parameters in Named Query with report model Tag: 47408
  - 18
    - Line chart gridline overlaps data line I am using reporting services version 8. There are a couple data lines that will not display because they fall on the Y axis gridline. I have tried changing the look of the line (width, markers, color) and changed the appearance color function to look like (="Blue") instead of (Blue). Any ideas? Thanks Tag: user of parameters in Named Query with report model Tag: 47407
  - 19
    - Browser Independent I'm new to ssrs. Reports seem to only work correctly in IE. The simplest reports dont format correct in firefox or netscape. Are there any options to create reports more cross browser functional? TIA -- Tag: user of parameters in Named Query with report model Tag: 47406
  - 20
    - Getting underlying sql for ad-hoc RS2005 report I've been able to get the underlying sql from the .rdl file for Reporting Services 2000. However, I want to be able to leverage the new Report Builder available with the new Reporting Services 2005. However, the problem is that Reports designed with the ad-hoc Report Builder no longer use embedded sql as the source. I need the actual sql to pass to another application to process the dataset (which I've found to be the best performing method). Given the comments in this article (http://www.devx.com/dbzone/Article/28047?trk=DXRSS_DB, bottom of first page)... "...the ad-hoc report definition includes a semantic query that describes the model entities selected by the user rather than being pre-defined by a developer." "...the Report Server extracts the semantic query and forwards it to the Query Translator. The Query Translator translates the semantic query to a SQL query, using the SQL syntax understood by the underlying data source." Does anyone have any ideas on how I could do the same? Are there any object libraries that Reporting Services 2005 makes available that I could leverage to do this translation? Does anyone know of any other way to achieve this result? I know worse-case secenario I may be able to call the render method, and request the csv, then stream this to my etl application. Regards, Tj Tag: user of parameters in Named Query with report model Tag: 47402
  - 21
    - Dynamic Report, How I want to create a report for different tables. That is, SELECT * FROM <tableName> I can build the query dynamically. How can I create the report dynamically (like a datagrid) where number of the columns vary? Tag: user of parameters in Named Query with report model Tag: 47401
  - 22
    - SQL Server does not exist or access denied When I run reports directly from the SRS they run fine. When I try to access the reports over the internet then I get this message once in a while. If I run the same report from the SRS then I can run it again in the browser on the client. I am running a database server with SQL 2000 SP4 on Windows 2003 Enterprise Server and SRS on a seperate box, Windows 2003 Server. When run on the development machine it works fine. When I run it from the SRS machine the reports work. When I run the reports from a client sometimes they come up with the message above. Go Figure.... Anyway, if anyone can give assistance please do. Thanks. Tag: user of parameters in Named Query with report model Tag: 47399
  - 23
    - Reports not rendering on Internet Application Hi We have developed an asp.net internet app and some of the pages have an RS report contained within a frame. Some of our customers appear to have problems accessing the report content - the only part of the report they can see on the page is the page numbers box from the RS toolbar and a box with a red x (missing image). The rest of the page is ok Its frustrating us as all is well when we view the app oursleves. Any suggestions what could be causing this please? We have confirmed with one problem user that they have the same version of IE and sp as us. Thanks Tag: user of parameters in Named Query with report model Tag: 47398
  - 24
    - separate report name and file name? Howdy, Is there a way to have a report name different than the rdl file name? I'm displaying reports through the SharePoint report explorer and viewer web parts and would like to have descriptive links like "Document Statistics by Site Type with drilldown detail" without having the file "Document Statistics by Site Type with drilldown detail.rdl". I know I can rename the report in Report Manager, but I'll be back to report names based on the file names next time I deploy reports. Can the report name and file name be set separately? TIA! Sean G. Tag: user of parameters in Named Query with report model Tag: 47396
  - 25
    - Subreport performance I've worked with Crystal and Access and now SRS and I have a question regarding subreports in SRS. Take a standard header/details report in which the details are a subreport (in this case we can't put all the records in one Stored Proc. Do the parameter link and it all works fine except when we watch it in profiler it acts like crystal, making individual SP calls to return the data for each detail section. This is where we find performance degrades. Our particular circumstance is that we will have a header with 3-4 detail sections that all share a common parameter with the header and filter to that parameter. Because of this configuration is makes it impossible to return a single dataset with all the relevant data. The header itself will return 500+ records and combined with the 3-4 detail sections could be over (500 x 4) 2000 sp calls. Sloooow. Seems to us that MS Access did the best job at this. Anyone have some other suggestions? Tag: user of parameters in Named Query with report model Tag: 47395

Is it possible to use parameters in Named Queries with Report models for eg:
UserID?
If yes, how can I pass the values to the userID parameter when user create
and run any report in report designer based on the report model? Does anyone
know of any samples\documentaion related to this?

Thanks
_Gigi JK

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200601/1

Top

Re: user of parameters in Named Query with report model by Lev

Lev
Fri Jan 13 22:30:25 CST 2006

That is not possible.

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

"gigijk via SQLMonster.com" <u17581@uwe> wrote in message
news:5a4fb729aae6c@uwe...
> Is it possible to use parameters in Named Queries with Report models for
> eg:
> UserID?
> If yes, how can I pass the values to the userID parameter when user create
> and run any report in report designer based on the report model? Does
> anyone
> know of any samples\documentaion related to this?
>
> Thanks
> _Gigi JK
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200601/1

Top