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!

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

Recent content by Scrabble

  1. Scrabble

    Changing table or view

    Thanks
  2. Scrabble

    Changing table or view

    I have a report that grabs from four views. We are now adding a new row/field to these views. My question is if there is any way that I can just use the report I have and somehow get the new fields added withoug redoing the whole report. Crystal ver. 8.0
  3. Scrabble

    SQL select statement

    Thanks, that worked.
  4. Scrabble

    SQL select statement

    I have this query. Select 1 "Topbottomflag" a."row" ...... How can Get the 1 "TopbottomFlag" to stay in the SQL statement. After i edit the Show Sql and run the report the 1 "Topbottomflag" disappears. Is there any way that I can get this to stay...
  5. Scrabble

    Combining Groups conditionly

    I have a slight problem. I have a report which is structured the following way with two groups. First group we will call Provider ID, second group will be called Seller ID. Before each Seller ID there is a header, which is my problem. When run it is structured in this way (Note: Numbers and...
  6. Scrabble

    VarChar field that is 1000 characters in DB

    Have some reports. they all work but I've never ven tried our last report because it uses a field that is 1000 characters long(the data in it may not be that long). Before Crystal came along we used delphi to strip the text field of the unneeded parts. At the end we would come up with a...
  7. Scrabble

    Cell width in Excel export

    First, what export dll are you using. I know there are two versions of the excel export. One has one check box the other has 4 or 5 checkboxs/options. You want that second one. Second what are you exporting it too. Excel 7 extended is what you need. Then you can make the columns almost as...
  8. Scrabble

    Export muli-Columns to MS-Office Excel or Word

    Are you exporting the excel in extended format? Also do you have the correct excel export dll? The good version has 5 options to select.
  9. Scrabble

    Subreports with parameters from main report.

    Are there suppose to be no parameters prompt when running from the VB application? If so then this should work. Report.EnableParameterPrompting = False that is what we do.
  10. Scrabble

    Need more room for my fields (Lanscape).How can you get landscape?

    Page setup or printer. Two of my reports use landscape. Its under the File menu I do know.
  11. Scrabble

    Using variables from a report in a subreport

    If you mean passing a variable from main to subreport, I would try making them shared variables. in basic mode Main Shared x as number //stuff formula=x Sub Shared x as number // divide formula = ?? I know it works if you share the value from the sub to the main report because that is what...
See more

Part and Inventory Search

Back
Top