Jump To Report Without Running It Automatically

SQL Server Reporting Services

Index ‹ SQL Server
- Archive
  - Windows Live
  - VB
  - SQL Server
  - VS Express
  - VS 2008
  - Architecture
  - Visual Studio
  - VC++
  - Visual C#
  - Game
  - Smart Device
  - SharePoint
  - ISV
  - Windows Forms
  - VFP
  - IE
  - Dotnet
  - Windows Vista
  - Office

- Previous
  - 1
    - OLTP Database Design help for bank's customer table Hello,friends 1) CustomerID 2) FirstName 3) MiddleName 4) SurName 5) Title 6) Marital Status 7) Education 8) Occupation 9) Annual Income 10) Line of Business 11) DOB 12) Father Name 13) Mother Name 14) SpouseName 15) Gender 16) Email 17) MainTel 18) Home Tel 19) Passport Number 20)---------------------- 21)- - - - - - - - - - - 100)------------------- Above mentioned list is a snapshot of our customer master table ,which contain approximately 100 attributes related to a customer. We are designing an application for banking sector (but NOT Core banking solution),for which we may need to capture variable number of addresses for bank's customer,i.e more then three types of addresses Fixed,Temporary and Communication addresses(which is generally the case with all banks). A single address includes address1/address2/city/country/state/pincode fields. In context of OLTP database, We have option to put multiple addresses in child table but that involves various joins at the time of data retrival and slow down the query. As another option we can can create redundent addresses columns(address1/address2/city/country/state/pincode) in master table that will accumulate addresses if demand for more then three type addresses arises(although there is reasonable numer of extra addresses is expected, i.e 10) Database is expected to serve the records of 25 million(approx) bank's customer,so does someone can suggest me how to maintan the balance between two approches. Tag: Jump To Report Without Running It Automatically
  - 2
    - Need drillthrough for just one month--but cube goes back two years BIGuy--we never found a solution. Tag: Jump To Report Without Running It Automatically
  - 3
    - Data Mining Client for Excel Is it at all possible to use this tool without any connection to SQL Server (mine data in Excel Worksheets only) Or is it required to connect to SQL Server From reading the documentation, one minute I get the feeling this is possible, then the next section I get a feeling it's not. Can anyone help Thanks. Tag: Jump To Report Without Running It Automatically
  - 4
    - microsoft decision tree algorithm Thank you for your answer, Jamie. but my question is how to split the continous INPUT attribute (The target variable is assumed automatically to be continuous in the case of regression tree). Tag: Jump To Report Without Running It Automatically
  - 5
    - DBCC SQLPERF WaitStates / OLEDB OK ... how many of you run dbcc SQLPERF(waitstats) to display analyze SQL Server 2000 resource utilization How about sp_waitstats This is a very useful stored procedure that takes the sqlperf output and aggregates it over common wait types. If you've had to work on a sick SQL Server box, I've found this pretty useful to help pinpoint bottlenecks. While there's plenty written about the various wait types, there seems to a shortage of stuff written about acceptable or expected values! I am experiencing some performance problems with some procedures running on the EE of SQL 2000 w/SP3 on a server with 12 GB of RAM & 8 CPUs. Since no major locking issues stood out, I ventured to see what types of waits were occurring. Using both dbcc SQLPERF(waitstats) and sp_waitstats I found 98% of the waits where the OLEDB type. First I've never seen a single wait type be responsible for such a large %. For this type of wait, SQL Server is waiting for a OLE DB provider to service its request. High transactions or slow connection speeds in a distributed env are a big cause of these. This can be caused by slow authentication, outdate MDAC or incorrect DB Providers. (OK, I have to admit I haven't seen this type of wait before) Has anyone else encountered this type of wait I've seen various I/O Latch waits in the past but this is the first time I've seen OLEDB. If you've seen this, what were the steps taken to remedy this situation Thanks, JoeT Tag: Jump To Report Without Running It Automatically
  - 6
    - Sql 2005 Management Studio I have the same requirement. If you found a solution, can you please post it Thanks, Tony Tag: Jump To Report Without Running It Automatically
  - 7
    - DTS Package problem? I have set up a couple of DTS local packages to run ActiveX scripts creating XML files and copying them to our webserver (on the same domain). I can run them OK manually via the 'Execute' package command in the drop down list when I right click on them and also get the 'Package successfully run' message back on running them, but when I schedule them to run overnight I find the SQL Server Agent reports them as 'failed' . What am I doing wrong Tag: Jump To Report Without Running It Automatically
  - 8
    - SQL mail using external mail server Hello We are using SQL Server 2000 SP4 Standard Edition and would like to use the e-mail function to monitor certain alerts. However, an e-mail server (SMTP server) is not installed on that box, but on a different IP address within the network. I have set up the e-mail operator, enabled e-mail in SQL Agent and set the Mail Configuration in Support Services. However, on testing I get the following error : Error 18030: xp_test_mapi_profile : Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client. As I cannot install Outlook on this server, I am now stuck. Has anyone a suggestion how I can overcome this issue Thanks, Marcel Tag: Jump To Report Without Running It Automatically
  - 9
    - Synchronization fails I think Support code 80070008 has something to do with memory on the device. Go to Start => Settings => Memory and kill any un-needed processes. Then try to Sync again. SC Tag: Jump To Report Without Running It Automatically
  - 10
    - Help on global variable for insert statement If I am understanding you correctly, it appears that you wish to load textbox values into the table depending upon the status of other textbox values. Your use of the IF...ELSEIF structure may work just fine for your intentions. Something like this might work. IF Textbox1.Text = '' Then IF Textbox2.Text = '' Then oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" + Textbox3.Text + "', '" + Textbox6.Text + "', '" + Textbox9.Text + "')" ELSE oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" Textbox2.Text + "', '" + Textbox5.Text + "', '" + Textbox8.Text + "')" END IF ELSE oCustomTask1.SQLStatement = oCustomTask1.SQLStatement & "Values ('" + Textbox1.Text + "', '" + Textbox4.Text + "', '" + Textbox7.Text + "')" END IF Tag: Jump To Report Without Running It Automatically
  - 11
    - Network share/Multi user deployment Can a SQL Server 2005 Compact Edition database file be deployed on a file share and be accessed by multiple (5-10) concurrent users This is a current scenario being implemented at several sites using MS Access databases. Each client would have the SQLce engine installed on it and would only access the database via a managed C# application. Tag: Jump To Report Without Running It Automatically
  - 12
    - Cannot connect to SQL Server DB Engine...Instance Contains SQL Express in Name Ekrem Thank you for that information. I have more details to help pinpoint the problem. I have the enterprise version which I installed. (I installed the developer's version on a different machine and had access to all services locally). I uninstalled and reinstalled. When IK view services, I see SQL EXPRESS service running, not SQLSERVER. SO I can connect locally to a SQL Express instance, however, I cannot connect to the DB server, to which I have full permissions. The first message I receive had a reference to the pipes, so I enabled pipes on the DB server. I went to connect to it again, and cannot see it in my list of browsed servers. UGH ! Tag: Jump To Report Without Running It Automatically
  - 13
    - continuous attribute & Complexity_Penalty I am having one question about discretization of continous attributes values. How does it work I need this information for my thesis. I have a continous attribut, namely SKS, with range 0-20. When I use Microsoft Decision Tree algorithm, this attribut split in SKS <= 18 and SKS > 18. I want to know how does it find 18 as a number to split not the other. One question again about Microsoft Decision Tree algorithm, about Complexity_Penalty parameter. How does it affect the algorithm For example, if I set this value=0.1 what does it mean and how does it correspond with growth tree Thanks a lot before for your kindness to answer my questions.. :-) Tag: Jump To Report Without Running It Automatically
  - 14
    - Deploying subscriptions on different server Hi, I have three environments which are exactly the same. A dev, prod and backup server. Everyone has its own installation of SQL. What is the best practice to re-use the subscriptions for the other environments I know I could restore the test database but I would prefer not. Thanks in advance for any input. Best regards, Jam Tag: Jump To Report Without Running It Automatically
  - 15
    - MDX Query performance issue Yes - what I tried to say in the previous message, that there doesn't seem to be a solution to your performance problem. NON_EMPTY_BEHAVIOR improves performance of queries similar to yours, but unfortunatelly, it cannot be applied in your case. Tag: Jump To Report Without Running It Automatically
  - 16
    - DFT - Howto last execute a storedprocedure donRiccardo wrote: Well I'm only collecting, Taskname, InsertedRows, UpdatedRows and DeletedRows, and not actually the execution time, then it would be more correct to have it after the DFT. But the main reason was to NOT needing an EST after every DFT, keeping a more cleaner ControlFlow /Richard I don't get it, but to each his own. The control flow is still the proper place, in my opinion, for what it's worth. The PostExecute() method seems a bit silly to me because it's hidden from view and perhaps easy to overlook when maintaining the package. Tag: Jump To Report Without Running It Automatically
- Next
  - 1
    - Can I Upload a URL or Shortcut to the SSRS Home Page? I have a simple WSS 2.0 SharePoint site for my SSRS deployment which I would like to link my users to from the SSRS home page. Is it possible to add a link or shortcut to my SSRS home page without embedding it inside of a document or report Tag: Jump To Report Without Running It Automatically
  - 2
    - Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later. As mentioned above in the posts, change the log on account from local system account to a specified account, even if its the same account that you are signed on to the server. Worked like a charm for me.. thanks guys... Tag: Jump To Report Without Running It Automatically
  - 3
    - Capture date and timestamp of a file? The script would be your FTP session. It would replace your FTP task. Tag: Jump To Report Without Running It Automatically
  - 4
    - SCOPE_IDENTITY() hi what is difference between thos two's SCOPE_IDENTITY() and @@IDENTITY thanx Tag: Jump To Report Without Running It Automatically
  - 5
    - How to dynamically process a Model in a Web App mr jamie... this link seems to be dead please send in the link again Tag: Jump To Report Without Running It Automatically
  - 6
    - SUM and Iif statements Jarrett, (iBB) is just an alias I use here. What you provided does get me past intellisense, but what I need to accomplish is not reflected in that statement. See my reply to Shyam for details. Thanks! Tag: Jump To Report Without Running It Automatically
  - 7
    - Windows CE 6.0 and SQL Server Compact I do not know, I don't work for Microsoft. But version 3.5 is currently in beta, and will be released when Visual Studio 2008 is released, beginning of next year Tag: Jump To Report Without Running It Automatically
  - 8
    - Logging Differences: Dtexec vs (Dtexecui or Visual Studio) Having a problem where I can't get "OnPostExecute" or "OnPostValidate" logging lines to appear in outputted log file when using dtexec. These lines do appear however when running through the gui interfaces (Visual Studio or Dtexecui) with the same package being run. Is this because there is a difference in logging between the two or what else could be causing this. I read that Dtexecui just runs/calls Dtexec but this does not seem to be the case as I have tested this scenario with the same package and get the different looging outputs. Even used the command line text from Dtexecui and ran with Dtexec but still different results. Thanks in advance Paul Tag: Jump To Report Without Running It Automatically
  - 9
    - connecting through C# When I look at the connection string it's: Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\ProcBuilder.mdf;Integrated Security=True;User Instance=True This works fine on my machine, but when I try to run it on another computer it tells me: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections." It should not be trying to connect remotely, it's a local DB. Do I have to install SQL Express on the machine I'm installing this on for it to work Tag: Jump To Report Without Running It Automatically
  - 10
    - Remote Access to SQLServer 2005 It seems like you have not configured for remote connection though u said u did. Refer : http://support.microsoft.com/kb/914277 http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx Madhu Tag: Jump To Report Without Running It Automatically
  - 11
    - 2000 to 2005 SQL Statement Order By Issue Thank you guys, I had to do a massive change on my application using "select" statements rather than using the view name. I assume views do not output the order by due to execution cost. that is the only reasonable conclusion i could think of. Thanks Again T.A. Tag: Jump To Report Without Running It Automatically
  - 12
    - SQL 2008 on Win 2008: No process is on the other end of the pipe It really should have been noted in the release notes. Tag: Jump To Report Without Running It Automatically
  - 13
    - Factors affecting effort estimate for SSIS package Hi, I need to estimate the effort required in writing some SSIS packages. Could anyone provide some pointers to the various factors (E.g. number of tables, source, etc.) which influence the effort estimate for SSIS packages Thanks in advance. Regards, B@ns Tag: Jump To Report Without Running It Automatically
  - 14
    - SSRS 2005 Failure sending email: The server rejected the sender address I have subscription by email problem on the following configuration: Windows XP prof. SQL Server 2005 Enterprise Configured Database Mail with remote SMTP server to send email successfully Configured SSRS to use remote SMTP server Edited the Rsreportserver.config file as following (by the instructions from MSDN) <Configuration> <RSEmailDPConfiguration> <SMTPServer> smtp.broadband.rogers.com </SMTPServer> <SMTPServerPort> 25 </SMTPServerPort> <SMTPAccountName></SMTPAccountName> <SMTPConnectionTimeout></SMTPConnectionTimeout> <SMTPServerPickupDirectory></SMTPServerPickupDirectory> <SMTPUseSSL></SMTPUseSSL> <SendUsing> 2 </SendUsing> <SMTPAuthenticate> 0 </SMTPAuthenticate> <From> My email Address </From> <EmbeddedRenderFormats> <RenderingExtension>MHTML</RenderingExtension> </EmbeddedRenderFormats> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats> <ExcludedRenderFormats> <RenderingExtension>HTMLOWC</RenderingExtension> <RenderingExtension>NULL</RenderingExtension> <RenderingExtension>RGDI</RenderingExtension> </ExcludedRenderFormats> <SendEmailToUserAlias>True</SendEmailToUserAlias> <DefaultHostName></DefaultHostName> <PermittedHosts></PermittedHosts> </RSEmailDPConfiguration> </Configuration> I scheduled my subscription and tested it. I didn't receive any mail from the setting email address, but got an error message in ReportServerService log file as following. Error sending mail, CDO error -2147220978, will not resend Error sending email. System.Runtime.InteropServices.COMException (0x8004020E): The server rejected the sender address. The server response was: 530 authentication required - for help go to http://help.yahoo.com/help/us/mail/pop/pop-11.html I did a little search, but couldn't find any solution for it. Is anybody successfully to get the Reporting Services subscription by email function working through MS SQL Server Management Studio or if you have a solution for this issue, would you mind to share the experience with me. I will be very appreciated. Tag: Jump To Report Without Running It Automatically
  - 15
    - Split datetime records with 5 minute intervals Thanx very much for the replies. I was ill for a week so I couldn't post my thank you's any earlier, but the post helped me very well. Greetings, Patrick Tag: Jump To Report Without Running It Automatically
  - 16
    - Move first record from a flat file to another Hi, i have simple requirement...but dont know how to proceed. I need to move the first record from a flat file (file1) to another flat file(file2) using SSIS, file1 will have many records but i just need the first one alone to be moved. Any pointers on this would be of much help. Thanks, raj Tag: Jump To Report Without Running It Automatically

SQL Servant

I need to be able to click a hyperlink in one report to open a linked report, but without automatically running the linked report.

Scenario.

I have a report showing customer details and on this page there is a link to a price enquiry report. This price enquiry report has two parameters: customer code and product code.

When I click the price enquiry hyperlink in the customer details report I can only attach a value to the customer code parameter. The product code parameter is not known at this stage and would have to be provided by the user after the price enquiry report is opened (but not run). The customer code parameter should already be filled (carried in the link).

When I click the link at the moment I get the error "The 'product' parameter is missing a value".

Any advice much appreciated.

Thanks,

SQLServant

Top

Re: Jump To Report Without Running It Automatically

tee_user5

Sometime ago, I made a post about this. It was stated that it's by design and that all parameter values must be passed to the report.

I believe using the hyperlink feature might work though you'd have to manually append all parameter names and values that you -do- want to pass (reportname&param=val&param2=val2).

Top