Report Writer #21

Hi,

I have a question regarding report writer we want to create a report for a 
form created with dexterity this form has radio buttons and we want to do the 
same in the report, show which radio button is selected. The question is when 
we created the radio button field and want to insert it to a table so I can 
use the radio button in the report the insert button is greyed out.
Do you have anything to help solve this or a better idea on how to make this 
report with radio buttons on it.
thank you very much


0
Saad (30)
10/31/2009 11:37:01 AM
greatplains 29623 articles. 6 followers. Follow

3 Replies
439 Views

Similar Articles

[PageSpeed] 26

------=_NextPart_0001_A423ACD0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hi Saad

Why don't you look at the RW_Token Report writer function.  This is a great way to convert a DLL or Radio group to a textual 
representation.

This blog article as more info:

http://blogs.msdn.com/developingfordynamicsgp/archive/2008/09/01/using-the-built-in-report-writer-functions.aspx

David

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics

mailto:David dot Musgrave at microsoft dot com
http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.  

------=_NextPart_0001_A423ACD0
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit

{\rtf1\ansi\ansicpg1252\deff0\deflang3081{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Hi Saad
\par 
\par Why don't you look at the RW_Token Report writer function.  This is a great way to convert a DLL or Radio group to a textual representation.
\par 
\par This blog article as more info:
\par 
\par http://blogs.msdn.com/developingfordynamicsgp/archive/2008/09/01/using-the-built-in-report-writer-functions.aspx
\par 
\par David
\par 
\par David Musgrave [MSFT]
\par Escalation Engineer - Microsoft Dynamics GP
\par Microsoft Dynamics Support - Asia Pacific
\par 
\par Microsoft Dynamics (formerly Microsoft Business Solutions)
\par http://www.microsoft.com/Dynamics
\par 
\par mailto:David dot Musgrave at microsoft dot com
\par http://blogs.msdn.com/DevelopingForDynamicsGP
\par 
\par Any views contained within are my personal views and not necessarily Microsoft policy.
\par This posting is provided "AS IS" with no warranties, and confers no rights.  
\par 
\par }
------=_NextPart_0001_A423ACD0--

0
dmusgrav7144 (312)
11/2/2009 3:25:19 AM
The value of a radio button will tell you which one is selected. Typically 
the first button has a value of 0, the second is 1, the third is 2, etc.  The 
value of the field indicates which radio button has been selected. Use a 
calculated field in Report Writer to change the values into words.

"Saad" wrote:

> Hi,
> 
> I have a question regarding report writer we want to create a report for a 
> form created with dexterity this form has radio buttons and we want to do the 
> same in the report, show which radio button is selected. The question is when 
> we created the radio button field and want to insert it to a table so I can 
> use the radio button in the report the insert button is greyed out.
> Do you have anything to help solve this or a better idea on how to make this 
> report with radio buttons on it.
> thank you very much
> 
> 
0
LeslieVail (702)
11/2/2009 12:58:02 PM
Thank you

"Leslie Vail" wrote:

> The value of a radio button will tell you which one is selected. Typically 
> the first button has a value of 0, the second is 1, the third is 2, etc.  The 
> value of the field indicates which radio button has been selected. Use a 
> calculated field in Report Writer to change the values into words.
> 
> "Saad" wrote:
> 
> > Hi,
> > 
> > I have a question regarding report writer we want to create a report for a 
> > form created with dexterity this form has radio buttons and we want to do the 
> > same in the report, show which radio button is selected. The question is when 
> > we created the radio button field and want to insert it to a table so I can 
> > use the radio button in the report the insert button is greyed out.
> > Do you have anything to help solve this or a better idea on how to make this 
> > report with radio buttons on it.
> > thank you very much
> > 
> > 
0
Saad (30)
11/2/2009 1:08:01 PM
Reply:

Similar Artilces:

invoices selected for payment report
is there a way to create a report of invoices that are due for payment. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=c45b1991-84e1-4ff0-b559-60091ec32b15&dg=microsoft...

variable column names in a report
i have an application where the user can enter self selected column names which then in turn are added to a table... application works fine. however, when it comes to reporting, how do i go about adding those self entered columns in a report? any help would be appreciated Do you actually need this in a report or can the results be pushed to Excel for printing? -- Duane Hookom MS Access MVP Help me support UCP http://www.access.hookom.net/UCP/Default.htm "k2sarah" <k2sarah@discussions.microsoft.com> wrote in message news:C56B6FD1-2F5B-45D5-8760-A61E3CA41495@microsoft.c...

Date format #21
I can't see how to format the date in the UK manner, i.e. 6/12/09, rather than in the US manner 12/6/09. Can anyone help? Excel 2000. Rob Graham Select the range to format Format|Cells|Number tab Choose date and look to see if the day, month year is in the order you like. If it is, you can use that. If it's not, choose Custom and type: dd/mm/yyyy (or what you like) If the values don't change, then your dates aren't really dates. They're plain old text that look like dates. Select your range (one column at a time) data|text to columns Fixed width remove any lines t...

Sales Report filtered by time, Z Report filtered by date
Does anyone have any Z summary reports that can be filtered by day, week, etc Also does anyone have a sales summary report that can be filtered by date and time. (Our liquor store is open untill 1 AM and I can't get the broken out sales over the "two day" period once sales has started on the next day? Thank you so much in advance. There is a combined Z report on the Jean Holland web site (I believe) that does exactly what you want it to do. In regards to (sales) reports by date and time: I asked the same question a week or so ago in this NG but didn't get any soluti...

Reporting an Average
How do I average the field “Minutes” from the query “qryUrban” and display the average in a report? I would like to find the (mean) average, but I have no experience with the AVG function. Thanks -- Message posted via http://www.accessmonster.com pushrodengine via AccessMonster.com wrote: >How do I average the field �Minutes� from the query �qryUrban� and display >the average in a report? > >I would like to find the (mean) average, but I have no experience with the >AVG function. Without seeing your query, if the query is the report's record source and if the Minute...

Excel reporting incorrect user in "file in use by"
We are currently experiencing a issue that that some of our users (some of which are laptop users that use the offline files feature) try to open for example an Excel file and it will be reported as being currently in use by a named user. So far no problem. However this user does not have the file open and if we go to check the open files on the server the file will in fact be open by a different user to the one reported in the excel popup window. Is there a way I can ensure that at least the correct user is reported to having the file open? I'm sure this must be somewhere int h...

Event ID 3009 A non-delivery report with a status code of 5.1.0 appears randomly.
Exchange 2003 mail enabled Public Folder randomly don't receive e-mail from external sender, when it happens sender receives error : --------------------------------------------- Final-Recipient: rfc822;xxx@xxx.com Action: failed Status: 5.1.0 --------------------------------------------- Sometimes all work ok. Error in Application log : --------------------------------------------- Event Type: Error Event Source: MSExchangeTransport Event Category: (8) Event ID: 3009 Date: 2005.12.21 Time: 11:43:32 User: N/A Computer: MailServerName Description: The description for Event ID ( 3009 ...

Reporting Services Lists & CRM
Has anybody tried aligning column headings located outside and above of a Reporting Services' list to their respective fields within the list? Everything lines up fine in Visual Studio's preview of the report. But, when published to CRM, the fields within the list are slightly shifted to the right or left of their intended position below the headings. The accumulative shift can be substantial. I've tried just about everything, including the use of fixed-width fonts. Nothing works, except placing the column headings within the same list... which has the obvious and undesirable ef...

Crystal Reports formula to Access
Any suggestions on how to use this formula in Access? if not(IsNull({MASTER.JMT_DATE})) then "Post Judgment"else if (IsNull({MASTER.JMT_DATE})) and not(IsNull({MASTER.SUIT_DATE})) then "Post Suit, Pre Judgment"else if (IsNull({MASTER.SUIT_DATE})) and (IsNull({MASTER.JMT_DATE})) then "Pre Suit" Here is a guess -- IIF([MASTER].[JMT_DATE] Is Not Null, "Post Judgment", IIF([MASTER].[JMT_DATE] Is Null AND [MASTER].[SUIT_DATE] Is Not Null, "Post Suit, Pre Judgment", IIF([MASTER.SUIT_DATE] Is Null AND [MASTER].[JMT_DATE] Is Null, "...

Lebans Report to PDF
I am using the Report to PDF utility on Lebans website. Great utility, except that I found the font embeding does not work. I reported this in this news group a few months ago and was told by Mr. Leban that it would be updated some time this month.Do any of you use this utility? Do you know if there are update available? I notice that the web site says version 2.753, March 06 is avaialable but the download link on the page indicates version 2.751. Any info would be appreciated.Doug ...

SBS 2008 : Daily Report "Detailed Network Report" Delayed
Hello, We have migrated 3 clients from SBS 2003 to SBS 2008 without any problem everything work great but we have only one problem : We receive every day @ 6AM "Detailed Network Report" from every servers. We receive "Detailed Network Report" From SBS 2003 between 6AM to 6:05AM so with 2003 Servers it's work perfectly. The problem is with SBS 2008 : We receive Report between 6:00AM to 9:00AM and we don't know why ... Settings are configured to send e- mail @ 6AM.... Anybody has the same problem or can help us ? Thanks for your help Have a nice ...

Access 2007 Report
I'm struggling with a report. I have 5 different .mdb files to pull data from to make 1 report. I linked the tables, and tried to create a report but the report only allows 1 record control source. That leaves out the date from 4 tables. Basically, my report will have 1 customer listed with customer ID, name, location. Below that will be the product purchased. All 5 mdb files have duplicate customers, but different products. The Report ought to look like: DFW123 ABC Company 123 Anywhere Street Dallas, Texas 76210 Snack food 500 units Soft Drink 300 units Ice Cream 150 unit...

Setting Up Report
I am having a difficult time figuring this one out! I have a query that is pulling the fields that I need in a report. The fields are: BA Complexity Code NumberOfWorkDaysToCode/Key ES MCK 7 ES LCK 1 ES HCK 7 ES HCK 7 I need my report to look something like this: Number of Days To Code/Key HCK LCK MCK 1 Day 1 2...

Text field designed same on Graphical report as on Text report
Would like Text fields to be designed the same when printed on a Graphical report versus when printed on a Text report. For example, on a Text report they grow as needed depending on the size of the note. On a Graphical report, you need to make the text field as big as your largest note. Then when you print the Graphical report for a smaller note, there is a lot of unused white space on the report. ...

How to compute Over short amount that shows in the z report
Hello, can anyone tell me how the over short amount in the z report is calculated? I am looking for the exact tables and its fieldnames for this computation. -- Thanks in advance, HNLuhar Hello HNLuhar....I copied and pasted this from the batch list report.....it reads the batch table to calculate "over/short"- hope this helps..... PaidOut + Dropped + LayawayClosed + PaidOnAccount + CustomerDepositRedeemed + ClosingTotal) - (OpeningTotal + Sales + Returns + Tax + Shipping + LayawayPaid + PaidToAccount + CustomerDepositMade + DebitSurcharge + CashBackSurcharge "HNLuhar...

Renaming forms tables and reports
Is choosing "save as" and making a copy and removing the original the only way to rename a report, table, or form? I started with the Issues template but I want to change the names of the objects. I can right click and rename the shortcuts in the navigator window, but the name doesn't change and the references are still under the old name. I do not want my shortcut to be a different name than the reference name because then there will be confusion for database maintenance. I've also tried renaming the objects in their properties window, but I couldn't find a na...

Creating a Report using two queries
I have created a chart report (bar chart) using one query. How can I create another single chart showing the results of both queries. One will show the bars of first query data and the other will show bars of the data from second query together in a single chart report. Any suggestions? -- FL This depends on how/if the two queries are related. I would expect the "X" axis values might be related. If so, join the two queries into a single query and graph the new query. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www...

Report using Fields with the same name from different tables
Hello all - I created a db with no knowledge of naming convention. Now I am attempting to write some reports pulling data from tables with the same field names. Apparently Access doesn't like this....I attempted to change the names in the BE but when I relink the FE it is prompting for parameters. What is the best way to proceed? Thanks - Lee -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/201005/1 TheLee via AccessMonster.com wrote: >I created a db with no knowledge of naming convention. Now I am attempting to &...

I need help formating a template for finanical reporting
...

SMARTLIST REPORTS
i can't modify smartlist reports is there a way to modify reports from smartlist. can i modify smartlist reports in version 9 or in the succeeding versions(ex. 10-11) -- Jeremy Ayaay Technical Specialist STRC Jher, If you are talking about creating you own smartlist reports, you can use Smartlist Builder. This will allow you to create your own smartlist, as well as use SQL Views to pull into Smartlists. If this is not what you are looking for, can you please explain a little more about which reports you want to modify in Smartlist. "Jher" wrote: > i can't mod...

Report list options
I have created a table and associated form in which one field, a field where a type of property is recorded, eg house, flat, industrial etc, has a number of options available via a drop down menu. From this table/form I have created a report. However, the report does not include whichever option has been selected in the Type field of the form. Can anybody advise me as to why this is and how it can be resolved? Any replies greatly appreciated. Clive Schless ...

Quote for Customer Report Problem
I create a printable quote form using Crystal Reports base don Michael Yourshaw's method (send GUID to aspx page and redirect to the report). But I have a problem. When I press the 'open quote in Crystal' button on the quote form, I have to enter my username and password again to be able to see the report. How can I solve this? Thx! ...

Displaying stored jpgs as pictures in a report
hello, MS ACCESS 2003 on XP PRO I've never stored jpgs in a table before, but now I apparently need to. I figured out (i think) how to store a jpg in a table using OLE OBJECT data type. But when I try to make a report of that ttable, the picture displays as a box with the file name displayed as text. How can I get the image to display on the report? Thank you, -- BlueWolverine MSE - Mech. Eng. Go BLUE! Try using an UNbound object frame and inserting the jpg in it. -- Milton Purdy ACCESS State of Arkansas "BlueWolverine" wrote: > hel...

Progress Report
I am trying to develop a Progress Report that has several work items listed. For example: Line Element % of Job % This Period %Cumulative ----------------------------------------------------------------------------------- 1 Demo 10% 8% 8% 2 Grading 50% 25% 25% 3 Construct 40% 1% 1% I would like to have the % Cumulative calculated from the previous value plus t...

How to remove row gaps in report ?
Helo, I have problem in report !!!! I think it can be resolve by NZ Or Nul Expression but I don't know how? Problem is_ On report in Detail sec I have 6 rows of controls which refers to tables. But some time I don't have record in some of the fields. When I print report there are gaps btween row which is not acceptable. So how can I remove this gap when there is no record ? Andy Karl Is there any other way like Using Chr(13) & Chr(10)? Cuz I read about this in this Discussion group But I don't understood it !!!! Thanks "KARL DEWEY" wrote: > You can stac...