Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • 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 does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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