Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 142
  • Last Modified:

formatting report

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
leenapedenekar
Asked:
leenapedenekar
  • 2
1 Solution
 
leenapedenekarAuthor Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
 
leenapedenekarAuthor Commented:
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

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now