pass hidden parameter from one dataset to another

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Install SQL Server 2005 and SP 2 in one step? Hello Sam, well, after reading knowlegde base article 910070, I think it may be possible though, using the "HOTFIXPATCH" switch on the command line. I will give it a try. ;-) Sincerely, Peter Tag: pass hidden parameter from one dataset to another
  - 2
    - SSRS page break I could, but , my group that I'm doing the page break on, is a level 3, and I would like to keep the level 2 totals on the same page. When I do the page break after, my level 2 totals go to the next page, with the detail of the next level 3 group printing below it... And I don't want to print just the level 2 group totals on a separate page. One of my requirements is to render to PDF to be able to print. Normally you need to somehow reconize the "first time through" so that you do not perform the group breaks and generate the blank page. Tag: pass hidden parameter from one dataset to another
  - 3
    - MultiValue Parameter Help >> Shouldn't the above conidition have the effect that no matter how many account numbers there are You might think so, but no <g>. You have to build the SQL, there's no magic here that allows the SQL to automatically understand a collection of values -- which is what the multiselect parameter is. I'll assume that your values for the dropdown list are string-type, because that is the hardest case usually and because you're using SUBSTRING() on your data column... You need to construct your SQL something like this: ="SELECT " & blah blah blah & "WHERE " & blah blah & " AND ( SUBSTRING ( C . CHARTOFACCTSACCOUNTNO , 9 , 3 ) IN ( ' " & JOIN(Parameters!RUs.Value, " ',' " ) & " ' ) " ... the use of red in the expression above is just to make sure you can see the single quotes versus the double quotes. I don't want to add spaces between the characters because those spaces would destroy the syntax we're trying to build. What I'm trying to show you is that you need to end up with a SQL expression that has the delimited strings in an IN clause -- IN ('211','212') -- and that, while annoying when expressed as above, it is possible to do it <s>. This is because the JOIN function will take the various values for each of the parameter values in the collection and concatenate them with a delimiter that, in this case, is three characters long: ',' . We add the outside or "embracing" single quote delimiters for the first and last items in the collection manually. If there is only one item in the dropdown selected, the JOIN doesn't add anything but the one value, and the result is (say) IN ('211') , perfectly valid. If you find it annoying to look at the SQL this way (I do) you can do what I've advised others to do several times in similar situations: just write a query that looks like this: =Code.GetSQL() ... and write a little embedded Function GetSQL() AS String in your report, that returns the query as a string. You'll write a more maintainable version of the parsing code if you don't have to do it all in-line as above. If you need to do any type conversions or iterate through the parameter collection for any other reason, it will be easier. HTH, >L< Tag: pass hidden parameter from one dataset to another
  - 4
    - Time Parameter expression needed Try this. Part of this may need to be modified based on your hour formatting , but.... These expressions are in the visibility property for each detail line: If the conditions are met it returns a "True" to the hidden option. Detail Line 1 has =Parameters!Report_Parameter_0.Value= True Detail Line 2 has =(Parameters!Report_Parameter_0.Value= true and ((weekday(Fields!time_idx.Value)<> 2 and datepart( "h" ,Fields!time_idx.Value) < 6 or datepart( "h" ,Fields!time_idx.Value) > 22) or (weekday(Fields!time_idx.Value) =2 and (datepart( "h" ,Fields!time_idx.Value) > 2 and datepart( "h" ,Fields!time_idx.Value) < 6)))) or Parameters!Report_Parameter_0.Value= false The Parameter is show core hours, Yes or No (evaluates to true or false) I did not do extensive testing, but a quick check indicated that it worked. Tag: pass hidden parameter from one dataset to another
  - 5
    - formula in a query Hi Madhu in the fomula i have for exaple a/b , so if i have cero in b i got a error, but do you think that i can use th e function case in my formula for example a/b + c/b , so the values a and b have not to be ceros.. cheers Tag: pass hidden parameter from one dataset to another
  - 6
    - adding 500 more columns to existing table Dear Friends, what is best and quicker way to add 500 columns to existing table having 145 columns already. Is there any way to avoid manual work of adding columns one by one in design mode or using script. I have a TXT file (comma delimited) that contains all those columns names as a first row,but I am not sure if i can use DTS package to create table design having such sourcre TXT file. Any advice Thanks, Tag: pass hidden parameter from one dataset to another
  - 7
    - how can i get connected to SQL management express using windows authentication Open up SQL Server Configuration Manager and check your SQL Server services. If you want to connect to your SQL Server, then you must ensure that SQL Server service runs. Also, elaborate your question please. Tag: pass hidden parameter from one dataset to another
  - 8
    - Service Pack 2 Failure Had already seen this and it does not apply to our issue. Thanks anyway Tag: pass hidden parameter from one dataset to another
  - 9
    - messages stuck in sys.transmission_queue Are all messages in transmission queue on the same dialog or on different dialogs Are the messages remote or local (if local, is it same instance or same db) Attaching the profiler and monitoring for events in the Broker category shows any activity Is there any route for the messages destination service in the database Do new messages sent end up in the same situation or they get trough fine To trigger an internal 'recycle' of the whole broker 'machinery' you can disable and then enable back the broker (ALTER DATABASE ... SET DISABLE_BROKER / ENABLE_BROKER), but I'd like you to try the profiler first to confirm if there realy isn't any broker activity for those messages. HTH, ~ Remus Tag: pass hidden parameter from one dataset to another
  - 10
    - Calculated Average w/o a dimension specified You might be able to use a combination of generate and/or filter to filter out the dimension in MDX, but given that you don't really know how many dimensions could be stacked on the axis, I can't envisage how it would really work. The other problem with Axis(0) is that it refers to the column axis, if a user flips the query around to put the dimension on the rows you would need to use Axis(1), but there is not easy way to tell what the user is doing. How many dimensions would you want to use with this calculation Would it be feasable to create a calculated measure for each applicable dimension This might also lead to some interesting analysis opportunities. Tag: pass hidden parameter from one dataset to another
  - 11
    - Mirroring problem between pcs in different location (Witness Issue) I guess probably is my firewall setting. Sorry about that and thx for the guide anyway. However, I am facing another problem. As I said, I am able to setup mirroring with witness in LAN but there's an error when I set up with witness in WAN. I am using the same method (certificates) to implement mirroring anyway. There's several scenarios that I have tried on it. Server A (Principal) : 111.222.333.444:5022 Server B (Mirror) : 444.555.666.777:5022 Server C (Witness) : 777.888.999.000:5022 --------------------------------------------------------------------------------------------------- Scenario 1 (Mirroring without Witness) - It works fine to me and mirroring is working. Scenario 2(Mirroring with Witness) - It shows that I was unable to connect to the C for witness. Here's the following error message : Msg 1456, Level 16, State 3, Line 1 The ALTER DATABASE command could not be sent to the remote server instance 'TCP://777.888.999.000:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again. The error log shows in principal server are : 2006-12-08 10:10:12.06 spid24s Database mirroring is active with database 'abc' as the principal copy. This is an informational message only. No user action is required. 2006-12-08 10:10:12.20 spid52 Error: 1456, Severity: 16, State: 3. 2006-12-08 10:10:12.20 spid52 The ALTER DATABASE command could not be sent to the remote server instance 'TCP:// 777.888.999.000 :5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again. 2006-12-08 10:12:00.00 spid27s Error: 1474, Severity: 16, State: 1. 2006-12-08 10:12:00.00 spid27s Database mirroring connection error 4 'An error occurred while receiving data: '64(The specified network name is no longer available.)'.' for 'TCP:// 777.888.999.000 :5022'. Scenario 3 (Mirroring without Witness) - I used server C to act as Mirror right now and mirroring with A. As a result It works fine to me. -------------------------------------------------------------------------------------- There's no firewall settings for all the location, ports are ok (tested using telnet), already enabled local and remote connections for all the servers, all servers log on as 'Local System'. I was wondering why I'm able to set it up in LAN but can't in WAN. Is it still need some settings for the witness Besides that, I did try set host file and set 'Full Control' on the machine key but getting the same result as well. Hope can get some assistance and I do really need help on it urgently. Thx in advance. PS: If possible, I prefer a discussion through msn messenger and I online always. Here's my email : tsuyoshi_lim82@hotmail.com Tag: pass hidden parameter from one dataset to another
  - 12
    - Schedule SQL Express BAckup using SQL DMO Because SQL Express doesn't include the SQL Server Agent the jobs you are creating can't be executed. You'd be best served to use Windows Scheduler to run the programs performing your backups. Tag: pass hidden parameter from one dataset to another
  - 13
    - Jump to URL Thanks for the reply rakam, Where do I write and store reportviewer.aspx Sorry for being illiterate here. Thanks Tag: pass hidden parameter from one dataset to another
  - 14
    - Migrating Data from MySQL I don't mean to sound like a total dummy but I sort of understand what is being said and there is some really good round about information but, it just isn't getting me there. I have a table right now for example that I exported in CSV format from MySQL that has 6 columns and 203 rows. If I create this same table in SQL2005 Express, how do I bring that data into my SQL 2005 database. Admittedly my experience level with SQL and Scripting is not quite beginner but I wouldn't consider myself intermediate either. Could you dumb it down for me a little Tag: pass hidden parameter from one dataset to another
  - 15
    - Cross Domain Windows Endpoint Authentication? Hi Remus Thank you for the response. So the forwarder simply forwards the message and credentials between initiator and target, correct The fact that the forwarder can connect to either does not resolve the matter Thanx Tag: pass hidden parameter from one dataset to another
  - 16
    - Periodic "SQL Server Assertion" error . , . - - . . Tag: pass hidden parameter from one dataset to another
- Next
  - 1
    - Activation Failure Date 5/30/2007 9:36:02 AM Log Database Mail (Database Mail Log) Log ID 516 Last Modified 5/30/2007 9:36:02 AM Last Modified By sa Message Activation failure. I hope this helps. Thank you. Tag: pass hidden parameter from one dataset to another
  - 2
    - How To Connect Remote Server's DataBase from another's Server's QueryWindow If the servers are part of a replicated topology you will have to set the server option for data access to true, is sp_serveroption 'ServerIWishToQuery','Data Access','True' and then select * from ServerIWishToQuery.Database.dbo.TableName Tag: pass hidden parameter from one dataset to another
  - 3
    - SSIS Yes. AS400 Table character set is defined as 937. Tag: pass hidden parameter from one dataset to another
  - 4
    - Help - Can't get Compact Edition to work with CE.NET 4.2 ! Hi ErikEJ, Thanks for the mail. Unfortunately it didn't solve the problem. Here is what I did: 1. Hard Reset the Device 2. Installed the CF 2.0 SP1 3. Installed the SQL Server 2005 HotFix Cabs (see Note below) obtained from Microsoft: - sqlce30.wce4.armv4i - sqlce30.repl.wce4.armv4i - sqlce30.dev.enu.wce4.armv4i 4. Confirmed that the following SQL Files were in the \Windows Folder: sqlceca30.dll, sqlcecompact30.dll, sqlceer30EN.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll 5. Confirmed that my sample app references the SQLServerCe Dll: C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Device\Mobile\v3.0\System.Data.SqlServerCe.dll Version: 3.0.3600.0 Note : I e-mailed Microsoft re: KB article 924811 as the it seemed a bit misleading. My question was "Is SQL Server 2005 Compact Edition support on CE.NET 4.2". The first e-mail was response was "The current KB article applies to SQL Server 2005 Mobile Edition. It is being updated to reflect the correct information. SQL Server Compact Edition bits are not yet publicly available for Win CE .NET 4.2 devices. However, you may contact MS Tech support with details on your device spec (cpu type) and they can submit a request for you." Shortly after I got a second different response: " Yes, we support SQL Server Compact Edition for CE.Net 4.2. Currently it is released as a hot fix, you need to contact PSS to get the drop locations. As you mentioned the KB article title is very misleading. Actually the KB article is to fix the support for Win CE 4.2. We will change the title of the KB article." Anyone got any ideas on this one Tag: pass hidden parameter from one dataset to another
  - 5
    - What solutions make returning from a disaster easier? I didn't know about peer-to-peer replication. I started researching it in BOL and it looks pretty good, right up to the point where it said: Use of identity columns is not recommended. In some of our databases, we not only use identity columns, but we use them as foreign keys in other tables, so the workarounds don't seem to help. Nonetheless, in some of our other database (where we don't use identity columns), this looks like a feasible option. So, now I'm up to database mirroring. I'm going to give that a try.... Tag: pass hidden parameter from one dataset to another
  - 6
    - Error while importing Text file using Import Export Wizard dear sir thank for ur replay about what u say Import/Export wizard offers you the chance to save your package i didnt know how to do it is it in the Import/Export wizard then in column maping click in Edit SQL ... also when u say then open it up and look at the metadata of the pipeline i didnt under stand it ..... sorry but after long investegation i found the following i instal SQL2000 and SQL2005 and i create table inside each of them with the same spacifecation as follows all the colums with data type: varchar and length: 8000 for both tabels. i fined somthing very strange - when i use the Import/Export wizard of SQL2000 i can import the Text file to the table in SQL2000 and to the table in SQL2005 - when i use the Import/Export wizard of SQL2005 i can't import the same Text file to the table in SQL2000 and also can't import it to the table in SQL2005 - when i check the length of the value in the FRDNAME column in row 9 in the text file i found it 53 and when i reduce the length less than 50 for that value i found that the Import/Export wizard of SQL2005 works for both table in SQL2000 and to the table in SQL2005 Even both table have length for all colums as 8000 also i change this length to 100, 500, 1000 and other value but the same result !!!!!!!! Tag: pass hidden parameter from one dataset to another
  - 7
    - Read the transaction log (ldf) file. My first post ever :) Thanks for the reply. I know there exist som applications that can read log files, like Lumigent Log Explorer. But it would be nice with an freeware version Tag: pass hidden parameter from one dataset to another
  - 8
    - SSIS Connection Manager passwords I downloaded Service Pack 1 for Visual Studio 2005, Version 8.0.50727.762 (SP.050727-7600), but I still get this error message. I tried the SA username and password for the connections in connection manager, but even after I checked the save password box and close the connection and reopen, it gives me the following error message: "Test connection failed because of an error in intializing provider. Login failed for user 'sa'." Tag: pass hidden parameter from one dataset to another
  - 9
    - How to drill down on fields Hi Jens , Thanks for did that and am able to see the data .. Tag: pass hidden parameter from one dataset to another
  - 10
    - System.Data.SqlServerCE.dll reference causes error ... What happens if you remove this reference again - does it go back to working properly Have you added a reference to the correct version of system.data.sqlserverce.dll (see this post across at www.sqlserverce.org ) as this might be a cause - although it normally manifests itself as a build error rather than a runtime issue. Tag: pass hidden parameter from one dataset to another
  - 11
    - Deploying reports to MOSS 2007 The TargetDataSource Folder is http://vpc001/ReportingServices/DataSources, the TargetReportFolder is http://vpc001/ReportingServices/Reports and the TargetServerURL is http://vpc001/ReportingServices. I can see all of these locations. When I try to deploy I get the Reporting Services Login window with the Server set to http://vpc001/ReportingServices . Thanks for your interest in helping me understand what is going on here. Regards, Michael Tag: pass hidden parameter from one dataset to another
  - 12
    - How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005 Triple-check your spelling and the scope your variables are defined in. I got the error just this morning and it was a spelling problem. Tag: pass hidden parameter from one dataset to another
  - 13
    - Help with expression to display a per-week daterange value! Thanks for the help, it worked well. I had to add SUM(Fields!Rejections.Value) and SUM(Fields!Amount) to add the rejections and amounts up for each line per week, but in all, it did work! I bet you assumed I knew that, but I didn't, but I did figure it out. Now my issue is how do I make it so it shows all the weeks Refer to my goal example above. I was able to replicate Jarret's results, but I'd like it to show the missing weeks of 2,3,5,6 with 0 values. Keep in mind there are no data that falls into these weeks, I just want to display the weeks and show 0 as values for both rejections and amounts. What do i need to put into the expression to place so-called "dummy" weeks on the report Tag: pass hidden parameter from one dataset to another
  - 14
    - Trigger programming SQL 2005 vs SQL 2000 First, I would carefully examine and ask WHY a CURSOR is being used in a TRIGGER. In almost all situations, the use of a CURSOR in a TRIGGER is a very bad idea. It increases the lenght of the TRANSACTION, holding locks longer than necessary, increasing the chance of blocking behavior. Almost always, a CURSOR in a TRIGGER is the result of not understanding how to process SET based data. My recommendation: Post the entire TRIGGER code and the TABLE DDL. Folks here will help you determine if there is a more efficient method to accomplish the task. You will get excellent assistance to make your database operate more efficiently. Tag: pass hidden parameter from one dataset to another
  - 15
    - Problems with Roles and sp_helpRoleMember This is a windows authenticated user. Based on previous posts in this forum, I've already looked at those 2 tables (principals and rolemembers). Indeed, the guy's principal ID never is added to the rolemembers table when I check off the role for that guy's login or use sp_addrole. Either I don't have permissions (which I do - Admin) or something is overriding this guy's role configuration. And why would he only see 1 from sp_helprolemembers and I see 20 Please help me make some sense on what's happening... (thanks for your reply Buck) Tag: pass hidden parameter from one dataset to another
  - 16
    - Join Using a substring function I already have a SQL script (SP) that works fine, however what I am trying to achieve is get rid of this SP/view concept and replace with SSIS packages/tasks/transformations. Thanks for helping. Tag: pass hidden parameter from one dataset to another

forwheeler

I have 2 datasets in my report and I want to pass a field from the 1st dataset as a parameter to the 2nd dataset.

How can I do this

I tried to set the report parameter from a query using the 1st dataset but the parameter is always equal to the first record in the recordset-it never changes per row.

Top

Re: pass hidden parameter from one dataset to another

forwheeler

I used a subreport and passed it a parameter based on each row to get this to work.

Top