Solved

formatting report

Posted on 2004-08-16
4
137 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 20 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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

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…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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…

737 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