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 derfloh 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. Hubajube

    SQL Server server collation vs database collation

    Hmm. These are both good ideas. After I try them out (probably next week), I'll post the results here. Thanks Clay!
  2. Hubajube

    SQK Server table definition

    Here's one to show the tables & colums: SELECT dbo.sysobjects.name AS TableName, dbo.syscolumns.name AS ColName, dbo.syscolumns.colid AS ColOrder, dbo.systypes.name, dbo.syscolumns.length, dbo.syscolumns.prec, dbo.syscolumns.isnullable FROM dbo.sysobjects INNER JOIN...
  3. Hubajube

    SQK Server table definition

    Here's one to show the tables & colums: SELECT dbo.sysobjects.name AS TableName, dbo.syscolumns.name AS ColName, dbo.syscolumns.colid AS ColOrder, dbo.systypes.name, dbo.syscolumns.length, dbo.syscolumns.prec, dbo.syscolumns.isnullable FROM dbo.sysobjects INNER JOIN...
  4. Hubajube

    Hi all, I have a table (Table1)

    Will the cnt field always be integers increasing like that with no numbers skipping? Will Type always be 5 or 6? If not, what other values might they have?
  5. Hubajube

    SQL Server server collation vs database collation

    I am installing a database on a server with case-sensitive collation. Our database was installed on that server with case-insensitive collation. To install the objects, I have a script that runs oSQL commands. Some of the scripts require case insensitivity. (For example, a UDF uses the...
  6. Hubajube

    Subreports and data sources

    Here's a piece of code in VB that retrieves a subreport: With oRpt 'get the subreport reference For Each oSec In .Sections For Each oRptObj In oSec.ReportObjects If oRptObj.Kind = crSubreportObject Then Set oSubRptObj = oRptObj...
  7. Hubajube

    "Proceeding to fix up report!" When? Why?

    OK, I have a RPT up in the designer that's using a SQL Server stored proc as a data source. The SP has 4 parameters. I choose Verify Database, enter the parameters, and this message comes up: "The database file availability_list_215;1 has changed. Proceeding to fix up the report!&quot...
  8. Hubajube

    displaying stored proc parms in reports

    Well, this one seems to have stumped everyone, but I figured it out on my own. This bug will only occur if the stored procedure name does not match the alias name. For my report, the SP name was P_Util. If I go to Database\Set Alias on the designer menu and click Set Alias, I see a dialog...
  9. Hubajube

    displaying stored proc parms in reports

    Oh yeah, more info. If I run this in the report designer, filling in the parameter values in the dialog that pops up, the values do show up. Strange. So if I fill in 1/1/2000 for the @start_dt parameter, then when I run the report in report designer, I get a 1/1/2000 displayed for the...
  10. Hubajube

    displaying stored proc parms in reports

    I'm using the Crystal OCX to generate a report that's getting its data from a SQL Server stored proc with parameters. I'm connecting to the db via ODBC. I'm using the StoredProcParam property array to pass the SP parameters and that's working fine. I'd like to display these parameters on the...
  11. Hubajube

    Cross tab --> Excel Bug?

    I have a report that uses a Cross Tab with a date column. I have customized the Group Name by using a formula to display mm/dd. It looks fine in the preview, but when I export to Excel I get gibberish, stuff like this: Xh% fh% mh% {h% ‚h% h% I don't see this bug reported on Crystal. Anyone...
  12. Hubajube

    8.5 vs 8.0: report format

    Great! Thanks for the input.
  13. Hubajube

    8.5 vs 8.0: report format

    I have Crystal Reports 8.5.0.217 installed on my computer now. I'm starting a new project where they use CR8.0. Since CR8.5 has no "Save as Crystal Reports 8.0" option, am I correct in assuming that reports saved in 8.5 are fully compatible with CR8.0?
  14. Hubajube

    Summary/Grouping question

    Make a formula that is equal to 0 if Previous(datefld) = datefld and is equal to the daily average otherwise. You want the sum of this new formula field.
  15. Hubajube

    Calculating & Grouping all Friday Dates from now to Year-end

    Hmm, I'd try to take care of this in the database. In SQL Server I'd use a table-valued function to link to instead of creating an actual table like you mentioned. A list of Fridays until the end of the year is small, so it should never take long to generate.
  16. Hubajube

    I have 2 or 3 reports written in ve

    I think using File\Print\Export then choosing Report Definition will help.
  17. Hubajube

    Does the Use Indexes Or Server for

    Does the Use Indexes Or Server for Speed option do anything when your data source is a MS SQL server stored procedure?
  18. Hubajube

    using acitve data in a subreport

    I came across a little glitch and found a solution. I thought I'd pass it along. I have a report that uses active data with embedded subreports that also use active data. The active data definition (TTX) files are kept in the same directory as the RPT files. Everything was fine when we...
  19. Hubajube

    print duplicate records only

    Can you add views to your database?
  20. Hubajube

    Group within a group

    Assuming that the managers are in your Employee table too, you should go to the Visual Linking Expert and then in the Tables\Add Tables dialog, add the Employee table again. It will give you a warning, and yes you do want to add another alias to the table. It will be aliased as Employee_1...

Part and Inventory Search

Back
Top