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
Solved

formatting report

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we 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 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…

840 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