Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Create report from form data

I want to create a report based on a form data....this form takes user input in text fields and does some calculations based on a module...i cant just export data using the export option as it output the field names as labels which the user has to edit

most of the fields in the form are not based on a query and are not part of a table

how can i take the existing data entered in the form and output it to a report?
0
samipk
Asked:
samipk
  • 4
  • 3
1 Solution
 
tbsgadiCommented:
Hi samipk,

You can put expressions in the textboxes of the report like = [Forms]![frmMain]![Text1]


Good Luck!

Gary
0
 
samipkAuthor Commented:
i have tried creating a text field on the report and setting its value to

=[Forms]![columecalc]![TotalVolume]

but it just shows #Name and doesnt work
0
 
tbsgadiCommented:
Is the form open before you open the report?
Is columecalc spelt correctly?
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
samipkAuthor Commented:
yes i have created a button inside form and after all the values are entered i press that button to open report and yes the field is spelt correctly
0
 
samipkAuthor Commented:
yes you were right the field was spelt incorrectly the solution works
0
 
tbsgadiCommented:
columecalc is the name of the form & TotalVolume is the name of the Textbox on the form?
If so can you post a screenshot of the report design
0
 
tbsgadiCommented:
I posted that before I got your comment
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now