Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. frankyberry

    Drawing Lines on Report.

    OK. So this may be the most boring topic going on TT right now but I had to ask.... I'm using CR 8.0. I'm trying to draw Vertical lines to make a grid. My lines are "meeting up" with the exterior box but the top part of the vertical line is extending oh so slightly past the box. I am aware of...
  2. frankyberry

    Cursor Intro.

    I'm using Oracle 9i. I'm creating a Db procedure that will retrieve data and I'm planning on using a cursor to loop through the returned data to insert into a table. The only problem is that I'm a newbie to Cursors...my Db expertise is low. So what I am asking is how to go about defining a...
  3. frankyberry

    Add text to calculated field.

    Using Excel 2002. I have a simple formula which adds up multiple columns .. =SUM(A1:A84) but is there a way to add a text string to the end result? so my result would read something like "895 minutes" (without the quotes)? Thanks
  4. frankyberry

    question about Running Totals

    Using CR v8.0. On the main report I have a database field GROSS_QTY that contains a value. This main report also contains a subreport. I would like to link this subreport to a running total variable off this GROSS_QTY value. I also will group off this variable in the subreport i.e if GROSS_QTY...
  5. frankyberry

    Strange issue with formula

    I originally posted this in the wrong forum...Sorry. using CR 8. When I use the below formula, it appears that the formula returns a null, so I'm using the IsNull() to trap it. If I comment lines 4 & 5, I return "N/A". If I don't it continues to return a null... any ideas...
  6. frankyberry

    Strange Issue with Formula

    using CR 8. When I use the below formula, it appears that the formula returns a null, so I'm using the IsNull() to trap it. If I comment lines 4 & 5, I return "N/A". If I don't it continues to return a null... any ideas?? whilereadingrecords; StringVar x; StringVar Array Places...
  7. frankyberry

    Issue with printing data horizontally.

    I'm using CR v8.0.1. I've been able to get data to display horizontally but not exactly to my liking. When printing vertically, the data looks like this: Set #1 Member(s): Notes: Tim Mark Chris Set #2 Member(s): Notes: 2 Sue Travis The...
  8. frankyberry

    Can a Gridview control do this?

    I'm sitting here trying to decide if I should code the following in a table with a While statement or somehow use a DataGrid control. Here is what I'd like to display: TeamName1 TeamName2 TeamName3 member1a member2a member3a member1b member2b member3b member1c member2c...
  9. frankyberry

    Best way to share a database.

    I've been working on a database and recently, I've had to travel and wanted to work on this database away from the original computer location. What is the easiest way for me to work on this same database without actually connecting to the original computer via VNC or something... Is it...
  10. frankyberry

    Proper database table naming convention

    I was curious if there is a proper naming convention used when creating database tables? Thanks.
  11. frankyberry

    how to insert data based off combo box selections.

    I am a newbie to Access and I'm using access '07. I have form that is driven off this table. tbl_salespeople ID(autonumber) Name(text) April(number) May(number) June(number) July(number) The form has a listbox containing all Names and a listbox containing all 4 months(April-July). I also have...
  12. frankyberry

    Report Design Limitations Question

    I am using ver. 8.0.1 There is a report with a sub-report. This sub-report contains a Fake Header, 1st Group Header, to create a sub-report header that repeats over many pages. Also, this sub-report contains a Grouping on a database field, 2nd Group Header. There is also a Details section that...
  13. frankyberry

    How to suppress details section if no data.

    We are using CR v8.0.1. We have a report which contains multiple subreports. In the one subreport, I have 2 group headers. Header 1 contains a formula which allows me to print the heading of this subreport on multiple pages, if the subreport span multiple pages. Header 2 is grouped on a database...

Part and Inventory Search

Back
Top