floundering in half an inch of water - tweak an mdx recordset to show only those dates that actually have values. apologies for this basic question, my MDX book hasn't arrived in mail yet.
i have the following query which defines the dataset used for a report parameter. The MDX was autogenerated when I specified a parameter for my main dataaset.. This is the auto generated MDX:
WITH
MEMBER [Measures].[ParameterCaption] AS '[Time].[Year - Quarter - Month - Date].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue] AS '[Time].[Year - Quarter - Month - Date].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[ParameterLevel] AS '[Time].[Year - Quarter - Month - Date].CURRENTMEMBER.LEVEL.ORDINAL'
SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,
[Time].[Year - Quarter - Month - Date].[Date]. ALLMEMBERS ON ROWS FROM [Itdev1 Hk]
Now, I'd liek to tweak it so that only those dates which actually have turnover data are shown. My turnover field is called [MEASURES].[TURNOVER].
how do I layer that in
i've tried SELECT non empty {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel], [Measures].[TURNOVER - WM INTERDAY]} ON COLUMNS , and SELECT non empty {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel], nonEmpty([Measures].[TURNOVER - WM INTERDAY])} ON COLUMNS ,
but in both cases I get ALL dates, most with null turnover values. I also tried using Filter() adn a where clause. Tag: how do i save a file from the report viewer control
Problem with role-based security Two things to check:
1. Run Profiler for AS and make sure that the connection open from RS indeed authenticates as this user
2. Check whether this user is member of Administrators NT group on the machine - if so security doesn't apply to him by default
3. Check response from DISCOVER_CATALOGS while connected as this user and see the content of ROLES column. If it has * in it - it is a bad sign. Tag: how do i save a file from the report viewer control
DROP DATABASE problem I'm having a bit of trouble reproducing this...
Assuming SQL Server 2k 8.00.760 Dev Ed, and assuming 'Loading' is the same as your 'Restoring' state...
If I restore a db with norecovery option, it's in Loading state. When I do a DROP DATABASE on that db, the files are deleted also.... as they should
It seems to be working ok from this end...
/Kenneth Tag: how do i save a file from the report viewer control
how to make fast forwad only cursor updatable In the msdn SQL server document( http://msdn2.microsoft.com/en-us/library/aa172573(SQL.80).aspx ), it states:
Transact-SQL cursors can specify the FAST_FORWARD clause on DECLARE CURSOR. This opens an optimized forward-only, read-only cursor.
But in the following section 'Implicit Conversion of Fast Forward-only Cursors', it states:
If a fast forward-only cursor is not read-only, it is converted to a dynamic cursor. Now I am confused: is it possible to make a fast forward-only cursor 'not read-only'(updatable)
A fast forward-only cursor by definition is read-only. Am I wrong
Thanks,
Baihao Yuan Tag: how do i save a file from the report viewer control
Incremental process based on Action Code LarryETL wrote:
I will be receiving an incremental file that will contain Ħ°IĦħ inserts, Ħ°UĦħ updates, and Ħ°DĦħ deletes as an action code that I will load into a transform table. If I conditionally split the action code I will lose the fifo order and the data in the transform sequence could be applied out of order causing an error. If I use 3 separate data flows I can apply incremental doing the inserts first, then the updates and then the deletes. I think this would work but I would have to read the transform table three times.
I am looking for some feedback on what is the best most efficient way to handle what I am trying to accomplish
Thanks
Larry
Why is there a necessity to load into a table first With SSIS you don't have to do that.
Having said that, once the data is ina table you don't need to use data-flows at all - which is what Jay suggested. If you DO want to use data-flows then the use of raw files will negate the needto read the table three ties.
In my opinion, none of these solutions will achieve FIFO processing though. Of course its up to you whether that matters or not.
-Jamie Tag: how do i save a file from the report viewer control
Trouble with temp tables I wrote a stored procedure that does the following. Selects records into a temp table. If no records are in temp table after select I execute another stored procedure, drop the temp table and reselect records into the temp table. I'm getting the following error and I don't think I should since I am dropping the temp table before creating it again. Msg 2714, Level 16, State 1, Procedure sp_Alerts_GetFeedSubscriptions, Line 30 There is already an object named '#FeedSubscriptions' in the database. When trying to execute the following sql USE [ProblemTracker] GO /****** Object: StoredProcedure [dbo].[sp_Alerts_GetFeedSubscriptions] Script Date: 04/19/2007 14:54:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[sp_Alerts_GetFeedSubscriptions] -- Add the parameters for the stored procedure here @NBID char(7) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here IF Object_ID('tempdb..#FeedSubscriptions') IS NOT NULL DROP TABLE #FeedSubscriptions SELECT a.UID AS FeedUID INTO #FeedSubscriptions FROM Alerts_Feeds a, Alerts_UserFeeds b, Alerts_User c WHERE a.UID = b.AssociatedFeedUID AND b.AssociatedUserUID = c.UID AND c.NBID = @NBID DECLARE @FeedSubscriptionsCount int SET @FeedSubscriptionsCount = (SELECT COUNT(*) FROM #FeedSubscriptions) IF (@FeedSubscriptionsCount = 0) BEGIN EXEC sp_Alerts_AddUserNew @NBID = @NBID DROP TABLE #FeedSubscriptions SELECT a.UID AS FeedUID INTO #FeedSubscriptions FROM Alerts_Feeds a, Alerts_UserFeeds b, Alerts_User c WHERE a.UID = b.AssociatedFeedUID AND b.AssociatedUserUID = c.UID AND c.NBID = @NBID SET @FeedSubscriptionsCount = (SELECT COUNT(*) FROM #FeedSubscriptions) END IF (@FeedSubscriptionsCount <> 0) BEGIN SELECT * FROM #FeedSubscriptions END END Tag: how do i save a file from the report viewer control
RUNNING A DTS PACKET FROM WITHIN TSQL Here is my problem: I don't have permissions to the 'master' db, thusly I don't have permissions to 'xp_cmdshell'. However, I need to output several small tables that I have created from one large table into individual text files.
Now, from the documentation I have read this is easily possible with the use of dts packets. However, my knowledge of dts packets is non-existent. So, I have created a dts packet that will take the data from a table and export it to a text file.
Here is what I need to know how to do: I would like all the small tables to go to their individual text files based on the file name I provide from within tsql. I would also like this to be done with the use of local tables (i.e. #tablename).
I am trying to alleviate human interface and the resulting errors from the sql statements we have now. We have an elaborate db system with tables and permissions all over the place, and thusly I want this done and removed with the use of local tables. Is this something that anyone could assist me with Tag: how do i save a file from the report viewer control
Error After installing SQL SERVER 2005 SP2 I was wanting to use one of the samples called stock which is a notification sample and while i was reading the instrutions from the book, it did not match the managment studio for instance after i clicked on properties on a login there should have been a database access table on the right panel but it came up with user view, by then i thought i had an older version so i tried to update it to sp2 (x64 version the others came up with an hotfix error not being a win 32 app during extracting). after i installed it along with the new updates for documentation and samples it was no longer able to connect to my sql server instance that i had been using and this error comes up
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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider) i have gone to configuration manager and enabled named pipes as well as going to surface area config and enabled tcp/ip and named pipes but that has not resolve the area
Desperately need to get this problem resolve so if anyone can tell me how to fix i thank you in advance Tag: how do i save a file from the report viewer control
Different behavior between DTExecUI and Scheduled Job Try to create a SQL Server agent proxy. Then grant the user login which will execute the package to the proxy. After that, try to the execute the package again. Tag: how do i save a file from the report viewer control
Merge Replication - SQL Server 2005, Windows Vista and MSVisual Studio 2005 Hello everybody!
I hope that someone could help me.
I have a problem when i start sincronyzing with the emulator of MSVS2005 to SQL2005 in Windows Vista. I have the same program in the emulator, but sincronyzing with windows XP Pro and no problem...
I configure the connection to use the IUSR.
The source code that i use:
repl.InternetUrl = @"http://laptop/SQLMobileIIS/sqlcesa30.dll" ;
repl.Publisher = @"laptop" ;
repl.PublisherDatabase = @"database" ;
repl.PublisherSecurityMode = SecurityType .NTAuthentication;
repl.Publication = @"Pubdatabase" ;
repl.Subscriber = @"SQLMobile" ;
repl.SubscriberConnectionString = @"Data Source='" + nomeFicheiroBD + "';Password='3409'" ;
The error that returns is:
"Failure to connect to SQLServer with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect"
Does anybody knows what i can do
HELP I NEED SOMEBODY TO HELP!
Thanks! Tag: how do i save a file from the report viewer control
Update/Insert Date field, which did not import from Access ok.. I now have the data I need in my database but in a seperate table and got the data in the same data types etc.
The Two tables;
AssetTbl (AssetID, SerialNum .... DateAcq ....)
TempDateAcq (AssetID, DateAcq)
So what I want to do in is; For each AssetID in TempDateAcq I want to update the matching (AssetID) record in AssetTbl with the DateAcq, which is currently NULL.
I suspect I could do this with a stored procedure I've tried searching the Books Online with limited results, and some google searching, but yet to find something that explains Procedures in a way that I understand what I need to do.... it also appears not to have been covered in the book I have on hand.
Perhaps I should also ask for a good reference book for new-comers to SQL; I plan on checking out the book stores this weekend. Tag: how do i save a file from the report viewer control
Need Help: For Cube data in Multi Languages. Hi
I've got the solution in dimension editor in transalations we can do Attribute Data Transalation by clicking ellipsis.Thanks again.
But I've read out regarding Analysis Services Instance for Multi Languages - If you know about please tell me. Or in other words I would like to say any method so that all data in Cube should display in any lenguage based on lenguage selection, but we are not maitaing any manual mapping columns.
Thanks Again. Tag: how do i save a file from the report viewer control
How to display?? Hi,
I have the following stored procedure
CREATE PROCEDURE dbo.test( @number varchar(128) output )
as select @number = gw_instance from fix_lvts..fix_exec_reports where gw_instance like '%PORTWARE%' return 0
Then I go in and execute it like this:
declare @number varchar(128) exec dbo.test @number output select @number
I get the following result:
T_PORTWARE_GBL
(Only one row returns).
However when I execute the sql statement below:
select gw_instance from fix_lvts..fix_exec_reports where gw_instance like '%PORTWARE%'
which is the same one as in the stored procedure except the variable declaration it reurns me the following:
gw_instance T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL T_PORTWARE_GBL
(99028 rows of data)
Why is this hapenning
Can anyone help me
Thanks and Regards, Sudip Tag: how do i save a file from the report viewer control
Remote connection to database on same PC? I believe that user instances are disabled for use with full-text search so I set the User Instance to False. The following connection string both fail:
Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SGExpress.mdf";Integrated Security=True;Connect Timeout=30;User Instance=False
Data Source=.\MSSQLSERVER;AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SGExpress.mdf";Integrated Security=True;Connect Timeout=30;User Instance=False
I installed VB and SQL Express using my administrative user account logged on locally to the PC. I'm am not being logged into any domain server but only to the local PC.
DeBug Tag: how do i save a file from the report viewer control
Updating the variable inside the dataflow Is it possible to update the value of a user defined variable within the DataFLow in SSIS. I am aware you can update a variable using a script task in the Control Flow, but how about the DataFlow
Thanks for any help in advance. Tag: how do i save a file from the report viewer control
A Simple Problem. But.... How about updating the table, using the OUTPUT clause to return what you've changed, like: UPDATE thetable SET islocked = 1 OUTPUT DELETED.* WHERE islocked = 0 AND ... --other criteria goes here This way, you'll get the locked rows, and the next user won't be able to. If you want to mark who locked it, then perhaps use a different type for islocked. Hope this helps. Rob Tag: how do i save a file from the report viewer control
Generates Msg 107, Level 16, State 2, Line 2 - column prefix does not exist (Oh yes it does.. anyone got a solution ?) hi All,
Following code generates error 107 (SQL Server 2000, SP3a):
SELECT
*
FROM
dbo . AssessmentItemHierarchy Parent
INNER JOIN dbo . RaterCategory
INNER JOIN dbo . RaterType
ON RaterCategory . ID = RaterType . RaterCategoryID
INNER JOIN dbo . AssessmentRater
ON AssessmentRater . RaterTypeID = RaterType . ID
INNER JOIN dbo . AssessmentItem
ON AssessmentItem . ID = Parent . ChildItemID
INNER JOIN dbo . Assessment
ON AssessmentItem . AssessmentID = Assessment . ID
INNER JOIN dbo . AssessmentResponse
ON AssessmentResponse . AssessmentItemID = AssessmentItem . ID
ON AssessmentResponse . AssessmentRaterID = AssessmentRater . ID
INNER JOIN dbo . ImageInstance
ON ImageInstance . ID = RaterType . ImageInstanceID
INNER JOIN dbo . AssessmentItem ParentGUID
ON Parent . ParentItemID = ParentGUID . ID
Error on Run:
Msg 107, Level 16, State 2, Line 2
The column prefix 'Parent' does not match with a table name or alias name used in the query.
The only work-around I have found is a rewrite of order:
SELECT
*
FROM
AssessmentItemHierarchy Parent
INNER JOIN RaterCategory
INNER JOIN RaterType
INNER JOIN AssessmentRater
INNER JOIN AssessmentItem
INNER JOIN Assessment ON AssessmentItem . AssessmentID = Assessment . ID
INNER JOIN AssessmentResponse ON AssessmentItem . ID = AssessmentResponse . AssessmentItemID
ON AssessmentRater . ID = AssessmentResponse . AssessmentRaterID
ON RaterType . ID = AssessmentRater . RaterTypeID
ON RaterCategory . ID = RaterType . RaterCategoryID
INNER JOIN ImageInstance
ON RaterType . ImageInstanceID = ImageInstance . ID
ON Parent . ChildItemID = AssessmentItem . ID
INNER JOIN AssessmentItem ParentGUID ON Parent . ParentItemID = ParentGUID . ID
Not very pretty... anyone know why I'm getting this error message with the first version of my query Tag: how do i save a file from the report viewer control
Dimension Design Question Ahh, ok. This sounds like a many-to-many relationship: keep the dimension designed in my previous reply but only build a single attribute on it based on the key, and then hide the whole dimension. Then create a dimension containing the single attribute that you want to see, off the following table:
M2MDimKey
M2MDimName
0
Balance
1
Attribution
2
Both
Then create an measure group from a fact table containing the following values:
DimKey
M2MDimKey
0
0
1
1
2
2
2
0
2
1
Put in regular relationships between the two new dimensions and this measure group, and last of all you'll be able to give the new dimension based on M2MDimKey/M2MDimName a many-to-many relationship to your main measure group. Now you should get the behaviour you want: selecting the Balance member will give you the aggregated values for all rows where Balance=1, but the Both member will only give you the value for Balance=1 and Attribution=1, and your All Member values will also show correct values.
Chris Tag: how do i save a file from the report viewer control
formula in a query Use the CASE structure to control operations where a zero divisor may be present.
CASE
WHEN isnull( b, 0 ) <> 0 THEN a/b
ELSE NULL
END Tag: how do i save a file from the report viewer control
Database Mirroring & Replication Considerations Hi all,
Can a publisher be mirrored What are the implications, issues, gotchas Transactional, Merge or Transactional w/ Updating Subscribers is what I'm considering.
Bottom line is I would like to use mirroring, but only one mirror will not suffice.
Thank you in advance.
Ray Nichols Tag: how do i save a file from the report viewer control
Reading XML file Hi Shlomi,
There are a couple of pieces missing here .
1. Let's talk about style #1 of access first.
Your code has:
Dim configFilePath As String ="c:\temp\Reports.config"
... is this what you tested in the development and deploy environments There is a good chance that the report-executing identity can't "see" c:\temp.
IAC... I realize that, in development, ReportFolder is going to be blank and that's why you're doing this, but I don't think that you are going to be able to use ReportFolder exactly the way you may think... I'm guessing what you've planned because you haven't said exactly... so read on... try a different experiment.
First, upload your file to the server. Then try doing a test similar to this, where you've placed an expression similar to the following in your layout :
=Code.TestFile( Globals!ReportServerUrl ,Globals!ReportFolder)
Here's the code for one version of function -- use whatever variations of expressions you prefer in your tests:
Code Snippet
Public Function TestFile(tsURL As String, tsFolder AS String) AS String
If System.IO.File.Exists(tsFolder & "/my.config") Then Return tsFolder & "/my.config exists." ' this represents what you said you plan to do ElseIf System.IO.File.Exists(tsURL & tsFolder & "/my.config") Then Return tsURL & tsFolder & "/my.config exists." 'this probably won't work either
' ElseIf ... whatever variations you want to try. End If Return tsURL & tsFolder &"/my.config not found."
End Function
... it's really not going to work, because the report "folder" doesn't exist. What you've done by uploading your file is put a resource into a database repository, and you'll have to fetch it out the same way.
IOW you may have to build the configFile expression to be loaded into the XML document something like the following example in your function (I'm probably going to get it slightly wrong):
Code Snippet
configFile = tsURL & " " & tsFolder & "/ MYCONFIGFILE &rs:Command=GetResourceContents"
Xml.Load(configFile)
Notice I wrote " MYCONFIGFILE ", not " my.config ", the name of the file you uploaded. In this example, MYCONFIGFILE is the *name* I gave the file when I uploaded to the server. This is required, and it is this token you probably have to use to get the file out again.
Does this make sense With this in mind, here's why I said I didn't think you needed custom code in my first response.
2. Method #2 of loading would be into a dataset as a datasource within the report. You can actually do this, with a proper URL, and specifying that URL as the connection string for the dataset. You may have to put a little additional work into it, by changing your config XML structure to be easier to be consumed as a dataset -- or you may be fine just doing the XPATH query stuff in this case. If you want to pursue this, let me know and I will explain further -- I do this. Typically, however, it's useful for a file containing real data, not to supply parameters. Now that I see what you're doing I'm not sure there would be any point.
3. There is probably a better way to do what you're doing, without any upload to the server at all. I'm guessing that you want to "share" this configuration information between your app and the report, right (If I'm wrong, it isn't going to invalidate the basic recommendations I'm going to make, as you'll see.)
So... Why not just supply the values to the report by passing them, as hidden parameters If you want to pass everything and make it generic, you can even pass the full contents of the config file as a string from your app. The report will load the XML from the string, instead of from a file, and pull out the values as needed in exactly the same way.
Let's try this method as an experiment. Put an expression such as the following in your report:
= Code.ReadConfiguration(Parameters!test.value,"MapPath")
Now create a parameter for the report, with the name test and of type String and place your full configuration document contents in that variable as a default value.
Now just change one line in your function
Code Snippet
' from Xml.Load(configFile)
' to:
Xml.LoadXml(configFile)
... now it will work great, and you won't have to worry about your ability to reference the file, where it exists, etc.
One of the great advantages of doing things this way, and passing the information directly from your app, is that there is no configuration step for the server, nothing to upload. But if you're not taking this approach (providing a config file) to share information between your app and your reports... you can still do it.
In this scenario you don't have to send the XML as a parameter from the app, and there isn't any real reason to. You can still use this schema (or any other XML schema -- there's no real advantage to using the config schema, unless you're in love with it <g>) to supply the config information. Specify the parameter value by dumping the XML document contents into the hidden parameter default value when configuring the report for a server, as we did in our test. It's not much different from the step you would have to take when you uploaded the config file to the server.
One more thing: I would also suggest you change the way you are calling this function so that you load up one Xml document object at the beginning of the report into a public reference so that you don't have to keep re-loading it every time you want to pull out a key.
HTH,
>L< Tag: how do i save a file from the report viewer control
What are new in SQL Server 2008 Analysis Services release? Hi, all here,
Just noticed SQL Server 2008 is coming out next year. Anyone here have any ideas what are significant new product features in SQL Server 2008 Analysis Services compared to SQL Server 2005 Analysis Services
Would be very interesting to know that.
Thanks.
With best regards,
Yours sincerely, Tag: how do i save a file from the report viewer control
stored procedure help I'm thinking the initial post wanted "years" as something like
(datediff( day,HireDate, getdate() ) / 365) as Years
(using integer truncation from the division to get rid of fractional parts),
and something like
((datediff( day,HireDate, getdate() ) % 365) / 30) as Months
(using modulo to eliminate the number of years),
and something like
((datediff( day,HireDate, getdate() ) % 365) % 30) as Days
Unfortunately these are all approximations.
I suspect that the initial post would expect someone hired on 2000/02/28, and with a "current date" of 2007/03/01 to have 7 years, 0 months, and 1 day of service; on 2008/03/01 that would be 8 years, 0 months, and 2 days of service, because of the leap year; on 2008/03/29 that would be 8 years, 1 month, and 1 day of service.
That's my guess, anyway.
So it seems like any algorithm must be based on "day number" and "month number" and "year number". Tag: how do i save a file from the report viewer control
New to MDX. How to use "links" between dimensions In that case, could you describe the attribute structure of the Customer and Project dimensions, and how they're linked - presumably, this follows a standard pattern for Performance Point-generated cubes Also, are any links configured in the cube between them, such as via Referenced or Many-to-Many relationships Tag: how do i save a file from the report viewer control
Looping scripts I have an application that manages the booking of rooms in several different buildings, and am trying to build an SSIS package to build a table containing records showing the total number of hours per day that each building is being used. Because two bookings in the same building can take place at the same time or overlap with each other, it's not a straightforward sum of the hours per booking.
I've written a VBA script that loops through booking records comparing their start and end times, building a total value for each day, and then writing the building id, date and total hours to a table. My problem is that I'm not sure how to do this
in SSIS. The script component operates on row by row basis so doesn't seem to allow looping through records, and the aggregate component doesn't allow scripts.
I'm still pretty new to SSIS so may be missing something obvious, but if anyone has help to offer it would be greatly appreciated.
Thanks,
Tim Tag: how do i save a file from the report viewer control
SQL_2005_Express-"Help file not found" err...? Hei everybody,
Can someone explain why I get this err. msg. on SQL express The installation went OK, no err, but when I press "Help" in SQL I get this message!
Thank you!
Stefan Tag: how do i save a file from the report viewer control
Why doesn't the Execute Package Task support parameters? Cho Yeung - msft wrote:
I believe the original team who designed the task was thinking about using parent variable config to achieve this. Any other configuration types (XML, SQL Server, etc) can potentially be used for the same purpose. Is there any specific situation where the information cannot be passed using the package configuration
Please feel free to open an issue to request the new fucntionality. It will be great if you can give some examples where the "/SET" functionality is really needed and very painful if using package configuration.
Thanks
Cho,
Thanks for the reply.
I'm sure there are many scenarios where it would be advantageous for the call ed package not have to know anything about the call ing package and those are scenarios that are not supported by Parent Package Configurations. When you are using Parent Package Configurations the called package makes some assumptions about what is in the calling package. Another way os saying the same thing is that the use of Parent Package Configurations places a restriction on what has to bein the calling package.
For example, I have a package that executes a backup of a SQL Server database. The package assumes that the name of the server and the name of the database will be passed to it and this package could be called from many many different packages. If parent Package Configurations are not used then there is no restriction on the calling package, they can be structured however they like.
I understand that the calling package would have to know something about the called package but I don't see that as a problem. Allowing what we're talking about here means that a package becomes a reusable piece of functionality which can be called from ANYWHERE and it doesn't have to know anything about the thing that calls it.
Does that sound like a scenariothat might warrant this getting changed
EWisdahl, if I raise a Connect submission for this will you be able to contribute a scenario
-Jamie Tag: how do i save a file from the report viewer control
Using IN as filter Here's a link which may help you. Take a look towards the bottom (last paragraph and the following code snippet)...
http://blogs.devhorizon.com/blogs/reza_on_blogging/archive/category/1008.aspx
It looks like you may have to modify the RDL file to be able to do this.
Jarret Tag: how do i save a file from the report viewer control
I don't believe ... This works if you are using Procedure for data retrival and Query parameters to fill the combo box.
If you are using Query Parameters to fill the combobox, then add 'All' as a parameter using UNION function to let user know that you are selecting everything. In the stored procedure ignore the parameter if the user is passing 'All' as a parameter and select everything.
Hope this helps. Tag: how do i save a file from the report viewer control