newbie report question

Hi everyone,

I have a report that is based on a parameterised query that user inputs when 
generating the report

I would like this report to include the actual parameters' values

Thank you,

5/22/2007 12:32:07 PM
access 16762 articles. 3 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 59

You can add a textbox to your report, and set the control source to =
repeat *exactly* the parameter prompts.  For example if your query has =
[Enter City], then put a textbox on the report with
=3D[Enter City]
in it.  You can embellish with additional text like
=3D"Summary for " & [Enter City]

Joan Wild
Microsoft Access MVP
"Samuel" <> wrote in message =
> Hi everyone,
> I have a report that is based on a parameterised query that user =
inputs when=20
> generating the report
> I would like this report to include the actual parameters' values
> Thank you,
> Samuel=20
5/22/2007 1:02:42 PM
Create a field on your report which has the control source the same as your 
parameter:  e.g.

=[Forms]![myForm]![myParameter1]  from a form;
Give it a name that does not match any other fields returned from your 
report control source query, e.g. searchParameter1.
You can do as many of these as there are parameters, and even concatenate 
them for a better report design.

Or if you are prompting for the parameter from the query
=[Enter First Parameter] (i.e. exactly as it appears in the query)


"Samuel" <> wrote in message 
> Hi everyone,
> I have a report that is based on a parameterised query that user inputs 
> when generating the report
> I would like this report to include the actual parameters' values
> Thank you,
> Samuel

5/22/2007 1:10:12 PM

Similar Artilces:

reports that print after the stock count
Hello: To the best of my knowledge, the only report that automatically prints at the end of a stock count is the exceptions report. A client claimed that, during last month's stock count, a "quantity report" of some sort automatically printed. They conducted a stock count this month and were surprised not to see this "quantity report" automatically print. I don't think that there is a such thing as a "quantity report" printed after a stock count. Is there? I advised the client to print the Historical Stock Status Report, since this other report...

If any cell in a range is blank question
Hello. I have two sheets in a workbook. One is a Summary sheet, and the next is titled "Bldg 5". What I am trying to make sure is that the range A1:K20 on the Bldg 5 sheet has had data entered to them (ie, they are not blank). The question that corresponds to Summary sheet A1 is "Has the data for Bldg 5 been updated?" If ANY blank in Bldg 5's range A1: K20, then put a "NO" in Summary A1's cell. If ALL of the Bldg 5 range had data in it, then put a "YES" in Summary A1. I also need A1 to update as data is entered into the Bldg 5 range (a...

sales return not in Stock Status report
Can someone explain the reason why a transaction entered through Sales Return in SOP as On Hand not included in the Inventory Stock Status Report? Is there any chance to add it in there? -- SmokyDuck ...

Is Crystal Report ver: supported?
Please tell me: Do reports made in CR Professional ver: supported by RMS v2.0? hi Asad, the Last version support is Crystal 8.5 also not worked with 9,10 or 11. "Asad" wrote: > Please tell me: Do reports made in CR Professional ver: supported > by RMS v2.0? Well, I've checked it myself. Crystal Report11 doesnt work with RMs v2.0. Haven't checked ver 9, 10. "Akber Alwani" wrote: > hi Asad, the Last version support is Crystal 8.5 also not worked with 9,10 or > 11. > > > > "Asad" wrote: > > ...

Can't Get CRM 3.0 Reports To Work
In the readme file that comes with server installation in the early access program it mentions under Known Issues: ************************************************ Microsoft CRM Server Privileges Required for Installing Microsoft CRM and Using an Existing Microsoft SQL Server Reporting Services Server The user installing Microsoft CRM and connecting to an existing Microsoft SQL 2000 Server Reporting Services Server must have as a minimum the Content Manager Role privileges at the Root Folder Level, and System Administrator privileges at the Site Wide Setting Level. ***********************...

pswd question
On XP pro sp3, if I start->run and type control userpasswords2 then hit enter I get a UserAccts window, I then click the Advanced Tab, I then go down to the center of the window to the AdvancedUserManagement heading and then look to the right and click the Advanced button, I get another window called LocalUsersAndGroups, if I then click Users->MyAcctName I finally get a window that called MyAcctName Properties, if I look down to the center I see a check box (that is checked) beside a heading that says, "password never expires". I go to ControlPanel(ClassicV...

Pivot Table question #4
Hi I have spreadsheets that take data via a pivot table from an OLAP cube that is held on a terminal server. The spreadsheets hold figures entered by me and figures obtain from the pivot table. I want to enable the automatic update on the pivot table but the pivot table is sorted by a project number obtained from the OLAP cube. My problem is if a new project is added to the OLAP cube then it is automatically selected from the drop down list. I want to be able to turn this off so that it only selects the project I have previously chosed. For example if I have selected the filter nu...

Remote Server Question
Right customer wants to acces his win2k8 server remotely. IT is using a generic printer from the server. At the office the printer is on a network. Terminal Services are being used to access the server remotely. What needs to be done to get said printer working? -- Member - Liberal International This is Ici God, Queen and country! Never Satan President Republic! Beware AntiChrist rising! UK Time for a Common Sense change vote Liberal Democrat / Alliance Whether "at the o...

x-y Line Graph question
I have a line graph. X is dates and Y is numeric data. I am plotting 12/1/2005 through 1/30/2006. The problems is my series does not start at the "left most" point of 12/1/2005, it is shifted slightly. And the line does not end at the "right most" point of 1/30/2006. Any ideas will be appreciated. thanks! XL has two distinct chart types even though they look similar, the XY Scatter chart and the Line chart. There is no XY Line graph. I believe you have a Line graph. Double-click the x-axis and from the Scale tab uncheck the 'Value (Y) axis crosses betwe...

report format portrait and lanscape
Is it possible to have one command to change report between portait or lanscape? If not, probably the best solution will be 2 reports. Your information is great appreciated, Your report is probably designed in portrait. This means it is designed to print 8-1/2" - the left and right margins wide. If you change the printout to landscape it is still going to print less than 8-1/2" wide on the left side of the paper leaving more than 3-1/2" blank on the roght side of the paper. To fill the paper you would have to write code to reposition and stretch out each con...

AD Computer object question
Hello, I have computer object within Active Directory for a specific server. Due to an issue, the link between the two has been broken. Is there any way to recreate the link without delete the AD object and join back the server into the domain? Thanks for your help, It's a really urgent matter, please help Dark Hello darkbol, Which kind of machine is it, Domain controller or member server or workstation? What is the exact error message? Did something happened before or is it just out of the blue? Best regards Meinolf Weber Disclaimer: This posting is pro...

Creating a Report using Tables (that have no relationships)
Im looking to create an invoice report that uses data from three different tables that are created dynamically by a query. The data for these will change but I would like to simply pull the data from these tables to create a report. The tables have the following information: 1. Company Info (name, address) 2. Customer Info (address, name, etc) 3. Customer Order (products, price, other info) 4. Invoice Info (ID, GST #, etc) I realize I could have created a table with relationships but the data above is dynamic as there are 4 different companies and based upon user inp...

Sales Pipeline report
I know you used to be able to view the sales pipeline report by product, but I don't seem to have that option available in the "group by" ddl. Am I missing something? HELP! Viewing the sales pipeline by product is an important requirement. I haven't used this report, but it should be relatively easy to build your own SQL view for the report to group the output by product (clone the existing report and modify the where clause). Thanks for the reply. According to the help files, this group by option should be available. I opened the report in Visual Studio, and low-and-...

GP Extender Tables Question (GP9)
I have created an Extender window with 3 Fields (let’s just say price 1, price 2, price 3). I can see where it got created in table EXT40100, field User_Defined_Prompts_1 etc and I can also see where the data is stored in EXT00103. What I don’t see is where the prompts from EXT40100 are in its own rows so that you can link them to EXT00103 for reporting purposes. I know I can hard code the flags to their proper values in Crystal or set up my own custom table to do it but I would have thought that Extender will have a table like that. Am I just not seeing it? -- Pieter The prompts ...

Change order of fields in a report to a custom arrangement
In a report, I want to list sections in a certain way that is not alphabetical or numerical. Is there a way to do this? Curerntly, it is alphabetical as below: **Staff Section** Chief of Staff Command Counsel G1 G2 G3 Public Affairs Special Staff ** I would like for the fields to be organized as below: ***Staff Section*** G1 G2 G3 Chief of Staff Command Counsel Special Staff Public Affairs Thanks! Glen Try going to Sorting and Grouping. It is one of your buttons on the command bar. You should be able to set it anyway you wish. -- Milton Purdy ACCES...

Question on Formats...
This ought to be quite simple to answer. Is it possible to format the contents of a combobox? On sheet1 I have text in cells A1 to A8 e.g A1 = John, A2 = Steve, A3 = Claire etc. I have a combobox on a chart that displays those names when I click the down arrow. The default is lower case, black lettering. Can I make the names appear in bold and green for example? I have tried modifying the original names but that makes no difference. If I right click the combobox and select <Format Control> I cannot see a way to format my data entries. Maybe you can't do it. And I want to ...

Hello, I created a line column chart on 2 axis. I have four data sets. The first 3 should go on the primary Y axis as columns and the 4th should go on the secondary Y axis as a line. However, Excel wants to automatically put both the 3rd and 4th data sets on the secondary axis as lines. I cannot find any command to change the 3rd data set to go onto the primary axis as a column. Any suggestions would be most appreciated! -Patty On Tue, 11 Nov 2003 13:27:33 -0800, Patty = <> wrote: > Hello, > > I created a line column chart on 2 ...

[more of a 'c' question really] Converting doubles to strings without getting scientific notation
Hello hello.. I'm using _gcvt in a dialog to display a double, but when it gets small the string appears in scientific notation ie 0.02 become 2e-02 Is there another conversion routine I can use to prevent this? I have a not terribly scientific customer who would prefer a straight forward decimal display. Thanks "Zardoz" <thing@thing.thing> wrote in message > Hello hello.. > > > I'm using _gcvt in a dialog to display a double, but when it gets > small the string appears in scientific notation ...

CRM v3.0 Questions
Hello, Is the fuctionality to unshare multiple records available in v3.0. The 1.2 documentation shows this functionality but it seems to be missing from the actual product. When you re-assign a record in v1.2 the record maintains a share relationship with the prior owner. Does v3.0 function the same way. Are there any tricks (other than using SCRIBE) when importing new records to link multiple contacts to a single lead. Has any new flexibilty been added to the Microsoft record importer. Thanks, Ron In 3.0 if you go to the settings > Organization Settings > System Settings th...

OL 2003; Question about two default attachments in HTMLMessage Format
This is a multi-part message in MIME format. ------=_NextPart_000_000F_01C51E85.7F26CCA0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0010_01C51E85.7F26CCA0" ------=_NextPart_001_0010_01C51E85.7F26CCA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Outlook 2003, XPP SP2=20 Hello, When I send an e-mail message in HTML message format, the recipient = (even when I send to myself) also receives two default attachments, = image001.png and image002.png. The first image is a what I would guess a = Microsoft ...

Rounding Up question
Hi, A1 has the ROUNDUP Function referenced to B1: ROUNDUP(B1,0). Example: B1 says: 6.2 A1 will roundup to 7. Perfect! This works 99% of the time. But in a special case B1 says 6.0 - A1 still rounds up to 7. I expanded B1 decimal places and found B1 in this case really says: 6.00044. Hence the reason for A1 rounding to 7. Is there anyway to tell the A1 ROUNDUP function to not round up when the first decimal place says zero? Or to only go out one decimal place when rounding up? Hope I worded my question that it can be understood. Thanx in advance, Amy. Hel...

Question about MFC source code.
Hi, all, I find that there are some redefinitions in afxHH.h. Something looks like this: #define HID_FILE_MRU_FILE1 0x1E110 #define HID_FILE_MRU_FILE1 0x1E111 // aliases: MRU_2 - MRU_16 #define HID_FILE_MRU_FILE1 0x1E112 #define HID_FILE_MRU_FILE1 0x1E113 #define HID_FILE_MRU_FILE1 0x1E114 #define HID_FILE_MRU_FILE1 0x1E115 #define HID_FILE_MRU_FILE1 0x1E116 #define HID_FILE_MRU_FILE1 0x1E117 #define HID_FILE_MRU_FIL...

List of questions
Hi, I have some questions in outlook 2003, can anyone help me? 1-how can i in the appointment type a subject with special format (red, bold..) 2-whent a task is 100% completed, how can be deleted automatically. 3- I need to filter only the available time on a specific day. ex if i have 2 appointments today on a specific time, what i need to see is the available time for other new appointments. 4-If I have a lot of appointments on a specific date that are colored with labels and have a specific show time as (busy,tentative), when i go to print this calendar with the "calendar detai...

Treeview Control Question
Hello, I am using a treeview Control in a form that has a tab control. The treeview control is located on one of the tabs. When the form loads it populates the treeview control(has checkboxes enabled on treeview), bolds certain text based on the SQL table it's pulling from, and then checks any items that were checked last time the record was saved. The problem that I am having is that when I move to another tab and go back to it, all of the bolds and checks are gone. I've tried redoing the query on tab control and page click actions as well as trying to set focus on the treeview ...

Parent Child report #2
Hi there does anyone have a parent child report? To list items by parent? Or by Matrix for that matter? Ivan The Reports Library has these two below: This report displays the Item Quantity List grouped by matrix code. Only matrix items are displayed, and each matrix code is displayed with its corresponding components. (April 26th, 2004) This report displays the Item Quantity List for Parent Child items. Only parent child items are displayed, and each parent code is displayed with its corresponding child ...