Report not applying selected parameter
I have created an rdl file in vs2005 that has a string parameter that is
pulling from a dataset. when I preview the report I select the parameter
from the dropdown list and click View Report yet the report does not filter
based on the selected parameter. What am I missing?
Can you post your query?
MVP SQL Server Reporting Services
"ahmed" <email@example.com> wrote in message
> I have created an rdl file in vs2005 that has a string parameter that is
> pu...I need to compare 3 numbers and find the one in the middle
I have three numbers in a single row and would like to identify the middle
number enter that number in another cell.
1st # 2nd # 3rd # result
628 678 720 678
655 625 700 655
748 720 725 725
is there a function in excel that can do this?
VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3383
View this thread: http://www.excelforum.com/showthread.php?threadid=56811
fasteddie wrote.....Find Duplicate names and delate
I have a small doubt could you clarify that???
That is I find duplicate name but I want to delete one name only, if I
filter DUPLICATE….. both names are showing…
1. Select the range of data including the header. You need to have headers
for these columns
2. From menu Data>Filter>Advanced Filter>Copy to another location
3. In 'copy to' specify the target cell and check 'Unique records only'
4. Click OK will give you the unique list
"Find Duplicate names and delate" wrote:
> Dear experts,
> I have a small ...Form help #2
We are in the process of creating a computer with a kiosk type software
that guests need to sign into.
There will be a form that they need to complete. We need to be able to
make it so that the guest can search for the name of the person he is
visiting and then the form will be emailed to that specific person.
Is there a way to make a form that works with our exchange server so it
searches for a name and then automatically sets the form to email to
...Finding a Median
I'm trying to write a query that will return a median for various
values taken from a previous query. I've seen some suggestions in my
searching, but I haven't been able to get them working. They are also
all from before 2003 and refer to Access 97 and 2000.
Has any functionality been added to 2003 for this? Or is there a non-
code-based way to do it? I've seen it suggested to write a code to
open the query, sort it, find the total number of records, divide it
in half, then seek out the middle record using that value. I'm still
very green when it comes to code, though...Find a Value the first Time It Occurs
I have a row of values that shows the total cumulative number of sales of
items by month. Occasionally, there may be no sales in a month for an item
so the cumulative value would stay the same for more than one month. I want
to select a number in the row the first time it occurs and not select it if
What are you wanting to do with the info?
To return position (column number) of number 1234 within row 2:
A formula that signals it's the first occurence:
This could be used in a helper row, or as a conditional format f...Find/Replace in RichEdit 2.0
I'm using Windows ME and I've switched from RichEdit 1.0 to 2.0 for my
CRichEditDoc/View application so that I can use the ITextDocument
interface and can do things such as suspend/resume the Redo buffer.
Problem is, now the Find/Replace dialogs don't seem to do anything. If
I revert back to RichEdit 1.0 they do!
What's going on?
firstname.lastname@example.org (Adrian Gibbons) wrote in message news:<email@example.com>...
> I'm using Windows ME and I've switched from RichEdit 1.0 to 2.0 for my
> CRichEditDoc/View application...test premier contact
je m'appelle sophie et j'aimerais discuter avec vous et mieux vous conna�tre
a bient�t j'esp�re .
inga.savant-aleina <firstname.lastname@example.org> wrote:
> je m'appelle sophie et j'aimerais discuter avec vous et mieux vous
> conna�tre .
> a bient�t j'esp�re .
Ou-est votre question s�r Outlook?
...Find (but not find)
My program takes a name from sheet3 goes to sheet1 to Find the name.
If it cannot find name, how do you do an If/End to Exit Do while or
find out if name has been founf? I have "On Error Resume Next" in
Thanks again for all your help
As ALWAYS, post your code for comments & suggestions.
Microsoft MVP Excel
"Gordon" <email@example.com> wrote in message
> My program takes a name from sheet3 goes to sheet1 to Find the na...Contacts, Bloody Contacts
I would like to create a contact record for each of our locations and have
that record show up in the GAL. I would also like the email address that I
supply for the contact record to resolve back to a distribution group that
would include the manager and perhaps the store admin for that location.
Problem. If I create a contact record with an Exchange email address, I
cannot also create the distribution group, as there would be two of the same
email addresses in Exchange. If I don't create an Exchange email address
for the contact, the contact record does not show up in t...Linking Contacts in Outlook 2007
I just converted from Outlook 2003 to Outlook 2007. In Outlook 2003 at the
bottom left of the address card was a field in which you could link the open
contact to other contacts in your address book. That field does not appear in
the address card in Outlook 2007. Can someone help me figure out how to make
that field appear? Thank you.
That option is here:
Tools > Options > Preferences > Contact Options... > Show Contact Linking on
"JMD01519" <JMD01519@discussions.microsoft.com> wrote in message
news:BACF9C2B-6FAC-48F4-B...Selecting and applying the correct forumla
How do I get Excel to apply a certain formula (held in a central table)
based on particular values in the same row? I don't want the actual result
of the formula whilst it's in the central table, as this will be different
when pasted into each row.
Example, (where Col D is the place I want the formula from the central table
to be applied to):
[Row 1] = A1+B1 (Apply this if column C equals the word "Rule 1")
[Row 2] = A1-B1 (Apply this if column C equals the word "Rule 2")
Col A Col B Col C Col D
1 1 Rule 1 2...Win Live Mail Contacts
Where does Live Mail keep the folder with all contacts in it! My Live Mail
folder in Programs Files has a Contacts folder, but nothing in it!
In XP, C:\Documents and Settings\username\Local Settings\Application
Data\Microsoft\Windows Live Contacts
There will be one folder for the default (not signed in to Live) contacts
and 2 folders for each Live ID.
The contacts are now stored in a edb database file.
" Larry Ralph" <firstname.lastname@example.org> wrote in message
> Where does ...Opening a form with cursor in a control filed
I have a form with a subform as reference. I only do data entry in 3 fields.
I have set the tab control for field 1, 2 and 3, but when I click on add new
record the cursor goes to the subform and and cannot tab out to the first
field of the main form. I would like to set this up that on got focus the
cursor is on the selected field and then tabs or move on enter to the next
selected field in the tab order.
The tab order in the main for is resetting to zero.
Message posted via AccessMonster.com
...Finding an event
I am developing an app that uses a single worksheet to enter data. When user double clicks a button, a new window (in same workbook)
opens with a new sheet. My problem is that excel does not seem to have any events for close of window if there are multiple windows
in a workbook.
Can someone help
That triggers the Workbook_WindowActivate event, you can use that.
"Peter Ostermann" wrote in message
I am developing an app that uses a single worksheet to enter data. When user
double clicks a button...How do I load Outlook if I didn't select it when I loaded Outlook
I put office on my laptop but (among other programs like Power Point) I
didn't select it when I was loading it up (didnt think I would ever use
it).... well.... now I have a Blackberry and need Outlook so I can sync
Control Panel | Add/Remove Programs | Microsoft Office | Add or Remove
Ben M. Schorr, OneNote-MVP
Roland Schorr & Tower
Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.htm
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies h...Outlook 2003 HTML Reply Selection Spell Check Bug
I received an email in Outlook. The email was in HTML format. I
started a reply to the message. I then selected only part of the
reply text and hit F7 to check the spelling of the selection (selected
text only). A message box pops up stating "Finished checking the
selection. Do you want to check the rest of the item?" There were
obvious misspelled words that simply were not checked. If I say Yes
to "check the rest of the item" the misspelled words are found as
would be expected. If the reply is only one word (not likely
normally) and you select it and check spelling...Find value in a column and insert rows above
The set up looks like this:
ColU ColV ColW ColX
Y N N N
Y N N N
N Y N N
N N Y N
N N Y N
N N Y N
N N Y N
N N Y Y
Columns will always be U through X and will always be sorted in this order.
I need to find the first Y in each column and insert 2 rows above that row.
On the blank row above the first Y, I need to highlight in yellow and put
title in the first cell, such as New, Old, Existing, Deleted.
Any help would be greatly appreciated.
Thanks for your time,
If desired, send your file to my address below. I will only look if:
1. You send a copy of this ...cannot find database
I have an excel spreadsheet that is supposed to update a access db.
Whenever I try to save the .xls I get an error stating cannot find db.
Even when I open the db with access, I get the error and the db opens
anyway?????? This only happens on 2 out of 20 pc's and I cannot figure
...Where is the graphics selection pointer in excel 2007?
I used to be able to click on the graphics selection tool in office 97 on the
left end of the drawing toolbar then click and drag over multiple graphics to
select them all. Then I could group them etc. What do i do now?
It's to be found in -
Insert tab - Illustrations - Shapes - select a shape and insert into w/s
and immediately the new drawing tools format tab opens up
Please hit "Yes" if this post was helpful.
> I used to be able to click on the graphics selection tool in office 97 on the
...Protected Forms & Tab Key
How do I create a form that allows users to use the tab key to move from one
unprotected cell to the next, vs. having to use the mouse to click? Seems
simple, but I can't find the info in MS Help. Thank you.
See the info here at Bob Phillips' site.
There is another method which involves VBA Worksheet event code. If
interested in that, post back.
Gord Dibben Excel MVP
On Thu, 23 Dec 2004 18:11:01 -0800, "virgobiker"
>How do I create a form that allows users to u...Sum if Condition is Equal in Range Date and find column
I want to make a sum if Range is a week number and if style is Equal to
CONC-92 or CONC-45
Week# 49 Week# 50
CONC-92= 27 CONC-92= 30
CONC-45= 27 CONC-45= 30
Datas are in a pivot table and...
Pivot table looks like this:
Date CONC-92 CONC-45 CONC-92 CONC-45
12/7 5 5 10 10
12/8 2 2 10 10
12/9 5 5 10 10
12/10 5 5 10 10
...Trapping a NO FIND after a find
I use the code below to store a row number to a variable after a find.
I would like to trap a NO FIND if the find is unsuccessfull
Any ideas. FSt1 provided the code below
dim rn as string
dim rng as range
dim therow as long
rn = inputbox("enter something to find")
if rn <> "" then
Set rng = nothing
Set rng = range("A1:IV65536").Find(what:=rn, _
...How do I find the out of office reply?
My out of office reply is missing from tools. How can I retrieve it?
Out of Office reply <Out of Office email@example.com> wrote:
> My out of office reply is missing from tools. How can I retrieve it?
Unless you are using an Exchange server, you will not have the Out of Office
Assistant. See this: http://www.slipstick.com/rules/autoreply.htm
...Execute Form Script During Import
I have an Onsave event that I want to fire during lead import. The Onsave
populates a custom territory field based on the Zip. The trouble is that I
want to assign the record automatically through a workflow.based on the
territory, but I can't because the admin would have to open and save every
record in the import set to get the territory populated.
you want, you'll need to move the logic into a workflow or a plug-in and have
it execute at the server side.
Visit my blog: http:/...