Parameter not refreshing default data selection

Here is the senerio:

Parameter 1: Company - multi-value

Parameter 2: Employee - multi-value

Available values: Query - Dataset: EmpList

Default values: Query - Dataset: EmpList

Parameter 2 is dependant on Parameter 1.

When a Company is selected, it does update the list of employees in parameter 2. But what it isn't doing is updating my default values.

I select Company A. It populates the Employee list with all of Company A's employees and marks them all as selected (check in the checkbox) and the "Select All" checkbox is also checked.

I then decide I want to include Company B. It populates the Employee list with all of Company B's employees but it does NOT select the employee's from Company B. It is like it ignored the default values query.

I would also think that if "Select All" is checked all new values coming in would be checked.

Is there a way around this problem?

I need to know if this is a bug or if there is something I can do to fix this.

Parameter Available Values

If I have a paramter that has query based available values, how do I get it to use a connection string specified in another paramter to do the query?

The scenario is that I have one set of reports that pull from a number of databases that have identical schemas and each serve a different customer. i need to be able to somehow populate the valid values with the right data from the appropriate database at runtime.

Nevermind, I found it.

I just had to populate an array of ParameterValues with just the connection string and then do a call to GetReportParameters, that made sure that the other parameters had the data that they needed.

Parallelism - Standard vs Enterprise Edition

We were told by a Microsoft representative that Intraquery Parallelism is
available only in the Enterprise Edition of SQL 2005. Can anyone confirm deny
that and support with documentation?
Standard fits our needs all other features, but I don't want to lose
Intraquery Parallelism.
TerryIntraquery parallelism is available in all editions which supports > 1 processor. There are only
certain type of operations going over several processors that only EE can do. See
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:0081E754-B590-43F2-B571-06526EF3C270@.microsoft.com...
> We were told by a Microsoft representative that Intraquery Parallelism is
> available only in the Enterprise Edition of SQL 2005. Can anyone confirm deny
> that and support with documentation?
> Standard fits our needs all other features, but I don't want to lose
> Intraquery Parallelism.
> Terry

Paging - Sql Server CE

Since Row_Number() is not available to SQL Server 2005 CE, are there any other alternatives for paging when querying the database?

Thanks.

In the next version of SQL CE, the TOP statement will be avaiable, and allow you to make your own paging solution, by combining TOP with a WHERE clause.|||So for the time being right now should I retrieve all data from the database and implement paging within the data access layer code? For example query and get 100 objects from the database but only return objects 30-40 to the application?|||You can use the ado bookmark

Page number information available in report body

Hi Group,
How can I get the page number while in report body ? I need to show/hide
some controls, depending on the page number.
Any solution is welcome !
Thank you,
CataOn Apr 10, 3:46 pm, "Catalin Magher" <cmag...@.era-environmental.com>
wrote:
> Hi Group,
> How can I get the page number while in report body ? I need to show/hide
> some controls, depending on the page number.
> Any solution is welcome !
> Thank you,
> Cata
Normally, to use Globals!PageNumber, you have to be in the Page Header/
Footer. That said, this link might provide you a work around:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/2eee17d147fb5603/dda039e65c969ce2?lnk=st&q=get+page+number+in+report+body+reporting+services&rnum=1#dda039e65c969ce2
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||This is an older post, but I tried to find a solution in the forum and
found many with the same unanswered question.
This is how I worked the problem. What you are doing is having the
Report call the global function and pass to a string and then you are
calling the function return str and inserting into the textbox!
Add the following code to the Report properties (main menu
REPORT>Report Properities > Code )
Public Function PageNumber()
Dim str as String
str = me.Report.Globals!PageNumber.ToString()
Return str
End Function
Public Function TotalPages()
Dim str as String
str = me.Report.Globals!TotalPages.ToString()
Return str
End Function
Now add the following function calls to empty textboxes
=Code.PageNumber
=Code.TotalPages

Page Number

I haven't been able to find anything on this. I need to reset the page number when printing invoices. This is something that is available in Crystal Reports. Does Anyone know how this can be accomplished. ex. customer # 1 will have 5 pages so on each page you would see page 1 of 5 , 2 of 5 etc, when customer changes it would start over.

hi,

report can be grouped by customer number and page number can be reset on new group. plz refer to the site below.

http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx

|||I have tried this post but can not get it to work. I was also told by Microsoft that this wasn't supported. Ask if it might in future and person I was working with couldn't find anything in database.