Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

formatting report

Posted on 2004-08-16
4
Medium Priority
?
141 Views
Last Modified: 2010-05-02
i have a table with records like tis
  test limits  mname
  t1 l1         m1
  .  .          m1
  t3 l3         m1
  .  .          M1
  t5 l5         M1
  NOW THIS TESTE
AND MAXIMUM 16 TEST FITS ON ONE PAGE SO IF THERE 4 TESTS THE LOTS OF SPACE IF LEFT BLANK DOWN
  WHILE DATA ENTRY IF THE USER ENTERS DOT THEN THAT MANY LINES WILL APPEAR BUT IT SHLD NOT BEEN SEEN IN THE REPORT IF IT DOT BUT TEST SHLD BE ADJUSTED
 ON THAT PAGE SO LOTS OF BLANK SPACE SHLD NOT BE WASTED
  WITH DOTS  IS FOR LEAVING THE LINES BETWEEN EACH TEST REPORT IS LOOKS SOMETHING LIKE THSI
THE DOTS ARE ENTERED SINCE  I DONT HOW MANY TEST ARE GOING TO BE FOR THE PRODUCT
IF I PUT THE FIELD TEST AND LIMITS IN DETAIL SECTION THE REPORT LOOKS LIKE THIS
  TEST   LIMITS      RESULTS  

  t1         L1
  ---      ----------  ----------
  .     .          

  ---- -----------  -----------
  T3   L3          
  --  ----------  -------------            
NOW THE USER DOES NOT WANT THIS  dots to appear in the report. but space shld beleft so that report looks good
i'm not using crystal report so i want solution which i can use for simple reports
0
Comment
Question by:leenapedenekar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 

Author Comment

by:leenapedenekar
ID: 11817777
I WAS TRYING TO DO THIS WHILE CREATING REPORT
If rpt1.Sections("Section1").Controls("txttest").Value = "." Then
    rpt1.Sections("Section1").Controls("txttest").Value = " "
    rpt1.Sections("Section1").Controls("txtlimits").Value = " "
   
  End If
   
  rpt1.Refresh
  rpt1.Show (1)
i get error property not supported
how to check if the test contains dot
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 60 total points
ID: 11819076
The easiest is to create a view on the table that replaces the "." by " " wherever necessary, and the report can simply be based on the view.

I assume that you are working with Access? If yes, a "view" is named "Query" in Access in case you don't know.

Hope this helps, if you need more help, drop a comment
Cheers
0
 

Author Comment

by:leenapedenekar
ID: 11857985
thanks i created a temp table where in dots were replcaed by blank so it is not showing in the reports any way thanks again
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question