Solved

formatting report

Posted on 2004-08-16
4
136 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
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

685 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