Roy mm
Hello.
I have a report with parameter called "parm1", that gets a value of "true" or "false" depanding on another parameter.
When the report is runnig the parm1 value is "false".
How can I protect this parameter from a change by the user
I mean - the user can run the report and then add to the url "¶m1 = true".
Can I do anything against that
I tried marking it as "internal" and I thought that now it can get his value only from inside the report but it didn't worked.
Any ideas
Thanks.
How to protect my parameters
SQL Server Reporting Services
-
- Previous
- 1
- SQL Server Data Migration and Synchronization Since I am migrating the server, my subscribers will not be updating. I have DS3 line in place for the synchronization. In my critical databases, I have transactions of around 114 GB per month on an average. This means 3.8 GB per day. For replicating 10 databases, it would need 38 GB of data transfer per day on DS 3 line. I have heard that DS 3 supports a transfer of 20 GB per hour. Tag: How to protect my parameters
- 2
- Different Font size when browsing and printing a report ? Hi all, Is it possible to setup different font size when a user is browsing or printing a report I have a lot of data to print on a report and i need tu use a font size of 7pt which is fine for printing but when the user is looking at the report on the browser a font size of 7pt is a bit too small and the bold doesn't work. Tia Tag: How to protect my parameters
- 3
- Analysis Services - Step by Step: Errors related to feature availability and configuration I have the same problem. I am also interested in a fix, not the trial version. Could someone please let me know how to change the configuration of the cube. Tag: How to protect my parameters
- 4
- SSIS Job Failed Thanks a lot. It is exactly what I want. Tag: How to protect my parameters
- 5
- Creating a Mobile Application with SQL Server Compact Edition Hello!! I completed that example that I pasted in the subject part and when I try to synchronize my mobile database, the data from the server appear in my pocket pc; but when i refresh the data on my pocket pc they do not show on the server. Can anyone give me a hand thanks Tag: How to protect my parameters
- 6
- Use of a SSIS variable of type ¡°Object¡± inside Script Component and Task Component In a Data Flow, I have the necessity to use a SSIS variable of type ¡°Object¡± inside Script Component and assign to it the content of 'n' variables of string type. On exiting from the script the variable of type object should contain something like in the following lines: AAAAAAAAAAAAAAAAAAAAAAAAAAAAA BBBBBBBBBBBBBBBBBBBBBBBBBBBBB CCCCCCCCCCCCCCCCCCCCCCCCCCCCC DDDDDDDDDDDDDDDDDDDDDDDDDDDDD ¡¡¡¡¡¡¡. ¡¡¡¡¡¡¡. On exiting from the data flow I will use the variable of type Object in a Script Task, by reading each element in a cyclic fashion. Is there anyone who have experienced something like this Could anyone provide any example of that Thanks in advance! Tag: How to protect my parameters
- 7
- How to debug CLR SP using Visual Studio 2005? We know that automatic deplyment is currently broken. How does one debug the stored procedures in this case Thanks, Alexey Tag: How to protect my parameters
- 8
- reporting and monitoring Hey all I am new here and fairly new to SQL server. And yes i have a question, that maybe dumb. My boss wants me to reporting to him the health of the DB each week. So here are a few questions. 1. What really defines the "health" of a DB What elements should I be reporting to him 2. Is there any utilities out there that would be helpful or can SQL provide enough info 3. I am using 2005 standard, so I have the shipped reports in summary page. But is this enough and can I customize them Sorry I am having a hard time even asking the questions cause I am not really sure what to ask. Any help or pointing down t he correct path would be greatly appreciated. Thanks, jason and what about 3rd party utilities such as this>>>> Tag: How to protect my parameters
- 9
- SQL 2005 Query Analyzer Please post your query and the complete error message. Without that information, we can't really help you much. Tag: How to protect my parameters
- 10
- "Can't find PInvoke DLL 'dbnetlib.dll'." every time when I opened the connection from my windows CE4.2 device to sql server I got the error "Can't find PInvoke DLL 'dbnetlib.dll'. My OS is MS CE4.2, I've installed Compact Framework 2.0 and SQL client. It worked fine at OS CE5.0 but not at CE4.2. My application is working correctly, but when I started the connection I received this error. Any idea thanks, Jan Tag: How to protect my parameters
- 11
- Number of reads in Profiler is not the same when running the same SP on different PCs hi Alex, can I suggest that you check the set options for each query to ensure that the values are the same, if not then very likely there are 2 different plans for this query. determine what options are set for each connection and replicate the options setup for the setopts value that works. this can be found in the syscacheobjects table in the master database thanks Tag: How to protect my parameters
- 12
- Problem when exporting data into Excel file from SSIS I have problems when exporting data into Excel file from SSIS. It all works fine with numeric columns but an apostrophe is attached at the beginning of each text cell. I tried using derived columns and data conversions but it didn't work. It seems to me that problem is in 'excel destination' task... I saw many people had this kind of problems too... Is there any solution possible Thanks. Tag: How to protect my parameters
- 13
- adding a new data flow item calendar transformer Try adjusting the regcomponent batch to include a full path enclosed in quotes... "C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\"gacutil.exe /u %1 "C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\"gacutil.exe /i %1.dll copy %1.dll "c:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents" and on the post-build event command line ..\..\regcomponent unpackdecimal (replace unpackdecimal with the appropriate package name) NOTE: I also went through quite a bit of headscratching trying to get the microsoft downloads to work following their readme's. Tag: How to protect my parameters
- 14
- Find and delete reversed key pairs. pawel.krakowiak wrote: If I may ask - why origCity>destCity and not something else. I don't get it. You need to ensure that the operation only deletes one record of each pair (without that condition it would have deleted both records of the pair). The condition arbitrarily selects the records where origCity sorts after destCity to remove. Mark could equally well have used origCity < destCity and removed the other record of the pair. Tag: How to protect my parameters
- 15
- Can I create a database schema from a DataSet and/or .xsd file? I have some questions about creating SQL Server CE databases. Based on my experiments and what I've read on these forums, it looks like there are a couple ways to create a database schema. I can edit the database schema via the Server Explorer in Visual Studio, or use an external program like SQL Server Management Studio and somehow convert those files to .sdf files. I find Visual Studio's built in tools to be cumbersome to use and limited in functionality, and using SSMS seems like a roundabout way of approaching the problem. I understand Microsoft will be releasing better tools with Orcas, but in the meantime, I'm wondering if there are alternative ways to generate database schemas. For instance, I find Visual Studio's DataSet designer fairly easy to use. The DataSet designer generates schema definitions (.xsd files), and an instantiated DataSet can both read and write schema definitions via Read/WriteXMLSchema. Furthermore, DataAdapter's Fill and FillSchema methods can be used to push a schema from a database to a DataSet. So, can I somehow go the other direction and push a schema from a DataSet to a database It seems like all the tools are there... For example, if I create the DataSet schema, could I use a small app to create a new .sdf file, instantiate a DataSet, write the schema from the DataSet to the database, and then save the .sdf file Or given the generated .xsd file, is there any way to create a SQL database from that Thanks in advance for any replies. Tag: How to protect my parameters
- 16
- Can't reinstall sql server 2005 express Hi, 1.) Download Windows Installer CleanUp utility from the link http://support.microsoft.com/kb/290301 and install in the system 2.) Using this uninstall or cleanup the partially installed sql server express 3.) Reboot the system 4.) Try installing sql server express from the setup. Regards..Sagar Tag: How to protect my parameters
- 1
- Next
- 1
- Check to see if file exist on server I found out this was a security issue. Tag: How to protect my parameters
- 2
- error hi i tried this SET DATEFORMAT dmy select top 30000 CMS_Upload_Details_ID,Scheme_Code,DrCr,Case when IsDate(AdditionalField5)=1 Then Convert(datetime, AdditionalField5,103) Else NULL END as 'ValDate',AdditionalField13 'dept_slip',AdditionalField14 'dept_dt',Cheque_No 'Instrm_No',Amount,CONVERT (varchar(11),Instrm_Date,103)Instrm_Date ,AdditionalField21 'Drawer Name' from Tbl_CMS_UploadDetails with(nolock) where Compare_Status='Pending' and ltrim(rtrim(CMS_Upload_Details_ID)) not in (select top 0 ltrim(rtrim(CMS_Upload_Details_ID)) from Tbl_CMS_UploadDetails with(nolock) where Compare_Status = 'Pending ' and Format_ID =83)and Compare_Status='Pending' and Format_ID =83 now getting error Server: Msg 241, Level 16, State 1, Line 2 Syntax error converting datetime from character string. Tag: How to protect my parameters
- 3
- Formating how to format an integer in sql 2005 for ex: 1.09876 i want to format to 1.1 in access i can use : format(field,'0.0') as field1 thanks Tag: How to protect my parameters
- 4
- sql cluster - fulltext error We have a sql server 2000 active/passive cluster running on Windows Server 2003 and within the last 6 months have started getting the following errors which eventually cause the SQL Resource Group to failover. An error occurred in the configuration monitor for instance <SQL Server Fulltext>: 80070005 - Access is denied . SQL is at the latest service pack/hotfixes. (8.00.2187) This cluster has been running fine for the past 3 years with no problems. Nothing has changed on the servers. We've had Symantic Antivirus running on the servers for a long time but the FTDATA folder and the sql data and transaction logs are excluded and nothing has changed on the configuration. We also run Diskeeper 2007 server on these servers but I can't see any problems with this. Once it fails over it will run fine for several days and then the same errors will occur and it fails over again. Any ideas on what might be causing this I can't really find anything on the Microsoft site that matches this error. Note: This has also just started happening on our test cluster which is an identical configuration. Tag: How to protect my parameters
- 5
- MSSQLServerOLAPService Stops MSSQLServerOLAPService Service seems to crash rather sporadically during our nightly ETL with the error of: The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Internal error: An unexpected exception occured. Internal error: An unexpected exception occured.. The time of the error in the event viewer seems to correspond with the step in the ETL that processes our AS 2005 database (Analysis Services Command Task). The job step reports success, and the data is refreshed so I don't understand why it is reporting an error in Event Viewer. The server is x86 with SQL 2005 sp2 installed. Has anyone else run across this Tag: How to protect my parameters
- 6
- How to Add Subscription or Subscribers manually through scripts instead of programming Hello everyone, I am new for SQL SERVER 2005 NS. I have gone through some samples about NS. Most of them add subscriptions and subscribers through vbs or .net application. So I got some questions to ask for your help: 1. I just wonder if there are some ways for me to add subscriptions and subscribers manually through T-SQL scripts instead of programming. Because sometimes, we don't need to ask our users to subscribe our message. 2. Is that possible for NS to send notification by SMTP without adding subscription For example, I have already populated all emails from database, what I need is just to send simple notes to these emails, and at this time, I don't need users to subscribe them. I just need to get NS works as database mail at this point - only send email notification without subscription. I am not sure if this is possible. ( I know with databse mail, this can be done easily, how about with SQL NS, any idea ) Would you please give me some advices I appreciate your help in advance. Best Regards, Tag: How to protect my parameters
- 7
- Retrieving a datetime with a time of midnight (from a typical datetime) Nothing difficult, I just need a way to generate a new datetime column based on the column [PostedDate], datetime. So basically I want to truncate the time. Thanks a lot. Tag: How to protect my parameters
- 8
- Reporting Services Date Format Problem We have just come up against this problem as well. I think it has only started since we installed SQL 2005 SP2, but I cannot be sure. Certainly there have been no complaints for the past 6 months, we installed SP2 last Friday and the complaints started today. Tag: How to protect my parameters
- 9
- Shared SSIS Staging/Dev environment You'll need to execute the packages programatically on the server. You can do that by using SQL Agent (and calling sp_start_job), if you can set up a job on the dev server. Otherwise, you might check out some of the methods described in this article: http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx Tag: How to protect my parameters
- 10
- Control Result of ExecuteScalar The user is calling a Stored Procedure with ExecuteScalar. When the SQL doesn't find a match, I'd like to return the results of a different SQL. For Example: If this doesn't find a match: select amount from Lookup Where application = @app Then I'd like to return: select amount from Lookup Where application = "DEFAULT" My actual situation is more complex than this. The first SQL is in a CASE statement. After my CASE is done, can I check the current ExecuteScalar return value Or someone determine how many records are in the last SQL to execute Also, ExecuteScalar always seems to get the 1st column of the 1st query. Can I have it get the 1st column from the 3rd query Tag: How to protect my parameters
- 11
- Remote Source and Destination Performance Jamie/Phil- thanks for your feedback. It does help and I am confident that the bottleneck has been isolated to a single query for which I can reproduce the timing by running from local Query Analyzer (which repros the effect of having to pull all those records from "Server A"). Having changed all Merge Joins to Lookups (which did help), there is no question that pulling half a million rows (to perform transformation) is really expensive and I guess it makes sense- would you try to do that in a web browser, for instance No way (unless you want to crash it). So, I think the options include limiting the result set or just dealing with the 10 minute +/- duration for the ETL to run. I will also look into source indexes and I will watch Farmers webcast and if anything changes, I will report back. Thanks again for the responses- especially on a weekend! Rick Tag: How to protect my parameters
- 12
- SSRS 2005 & Number of concurrent users Hi, In one CPU installation of SSRS 2005, are there any restriction on number of users accessing the same concurrently Please let me know. Regards, TNR Tag: How to protect my parameters
- 13
- Problem with OPENROWSET The value I'm getting in the sql table is the exponential value of the number,right In this case,are those modifications to the keys still necessary Thanks! Tag: How to protect my parameters
- 14
- TempDB Well, if the drivers blow up, SQL Server don¡¯t boot, but you can¡¯t to create others temporary objects. One good idea is SHRINK the TempDB DBCC SHRINKDATABASE (tempdb, 10) GO And set the recovery to SIMPLE. SQL Server wouldn¡¯t try to recreate on drivers that didn¡¯t work. You can make a job to SHRINK Tempbd each specific time. Tag: How to protect my parameters
- 15
- Dimension Writeback Thomas, Regarding your last question, I don't think the project in BIDS would change based on dimension writeback changes as these types of changes are simply pushed into the dimension table; they don't cause structural changes to the dimension (unless I'm missing something or misunderstand your question and comments). HTH, Dave Fackler Tag: How to protect my parameters
- 16
- Replication: periodic initial snapshot not yet available Both are with sp1 (version 9.00.2047.00). Publisher is 2000 sp3. Yes I'm using transaction replication. I can provide you with any details you want. Tag: How to protect my parameters
- 1
- Previous
Re: How to protect my parameters
BobP - BIM
Actually, if you mark it as internal, and then try to pass it in an URL, you get the error:
The report parameter 'ClientKey' is read-only and cannot be modified. (rsReadOnlyReportParameter)
peace
BobP
Re: How to protect my parameters
Roy mm
well, actually, I don't
I tried it and I can pass the internak parameter a value trough the url with out any error...
Strange...
well, actually, I don't
I tried it and I can pass the internak parameter a value trough the url with out any error...
Strange...