Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : User Input (ask for variable) to filter for field values?Search Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v7 Forum

 New Topic 
 
 Post Reply 
[1]  
 User Input (ask for variable) to filter for field values? 
 Author   Message 
  NinerLoyal 
  
 Group: Members 
 Posts: 3 
 Joined: 2007-02-02 
 Profile
 Posted : 2007-02-02 06:12:04

I have created a report that tells me all of the items on sales orders for a given date range. What I need to do, however, is I need have my employees have the ability to to filter that by vendor. Any idea how to create a prompt with a pulldown menu that allows users to select the report specific to a vendor?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-02-02 08:14:23
The method for prompted vales is dependant on the front end or programming language you are using and the SQL Statement (which you didn't provide). Try looking at: How do I use prompted date ranges in MS Access?  

  Top 
  NinerLoyal 
  
 Group: Members 
 Posts: 3 
 Joined: 2007-02-02 
 Profile
 Posted : 2007-02-02 09:05:09

I don't understand your answer. I'm just using your QReportFinder program to create a report from my QB data tables. The only "programming" that I have done is to click on the "get records to print" button in the report editor window and then I put in the following in the "filter" box:

Txndate >= Var -> askD_1_Begin_Date .AND. Txndate <= Var -> askD_2_End_Date

Which is basically the code that you guys had out on your tutorial for Expression Building.

What code (or tool) could I use to allow the users of the report that I have created to select a particular vendor? Any ideas would be helpful.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-02-02 09:21:55

Sorry, you have posted this to the wrong product forum. QODBC v7 FREE Helpdesk Support is for QODBC, not QReportBuilder, see: QReportBuilder for QuickBooks .

Note: The QDeveloper Forum only provides installation support for QReportBuider currently.

 

  Top 
  NinerLoyal 
  
 Group: Members 
 Posts: 3 
 Joined: 2007-02-02 
 Profile
 Posted : 2007-02-02 09:43:57

C'mon Tom, I'm getting ready to buy 5 versions of your QReportBuilder for one business and may purchase more copies for a second before the end of the week (I employ over 50 people doing QB advisory and Accounting consultation for businesses in the area)...essentially, I ran across your product for building reports and think that it may be a huge hit with many of my clients...and the best you can do for me is "this isn't the right forum??"

I've noticed that you are also the expert for the QReportBuilder forum. So the way I see it either you don't have the ability/knowledge to answer my question or you don't care about my business. So which is it?

I need some help here...you seem to be the only person on the planet who has the resources to help me answer what is probably a very simple question...IS IT POSSIBLE TO DO A PULL-DOWN MENU IN QREPORTBUILDER THAT ALLOWS PEOPLE TO FILTER REPORTS BY FIELD DATA (SUCH AS VENDOR NAME)?

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-02-02 11:50:20

Sorry, the user interface of QReportBuilder has undergone considerable changes in both design, operation and appearance making it impossible for me to document "how to...s" as I do here in the QDeveloper Forum. FLEXquarters.com LLC have also indicated that QReportBuilder will have it's own help and answer support system that will not be in this forum, so for now I'm only offering limited installation support for feedback purposes. I suggest you contact Mark directly for help on what you are wanting to do.

All QReportBuilder non-installation related support matters require the purchase one of our Support Incidents (charges apply). That support is currently provided by Team members outside of Australia.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to