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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Page header info wrong when exported
Hi all, I'm having an issue with an old report that is being run with CR7. The report prints wrong information in the page header when the report is exported to RTF. The report works fine when printed or displayed to the screen. The page header displays a "department" field in the page header...- bjornagin
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Excel SQL VBA always inserts colum
Hi. I'm new to VBA so bear with me. I'm trying to write VBA that updates a specific cell in Excel with data that I've queried from SQL Server. So far I have the following.. Sub Test1() Dim qt As QueryTable sqlstring = "Select ValueX From Data1 Where blah='blah'" connstring = "My ODBC...- bjornagin
- Thread
- Replies: 7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Field alias in Where statement
This should be a simple question. I'm trying a query like: SELECT Distinct Left(AuditNum, 4) AS Blah FROM Audit where Blah = 'Fred' When I attempt to execute the query I get prompted for a parameter value "Blah". Can't I use a field alias in my where clause? Thanks- bjornagin
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Running total on multi-expression formula
I'm having a bit of a problem with Crystal Reports 7. I have a multi expression formula similar to the following: @Formula1 ========= numberVar uvSchd :=0 ; if({@uv01}>0) then uvSchd := {@uv01} ; if({@uv02}>0) then uvSchd := uvSchd + {@uv02} ; uvSchd*15/60 The formulas that get...- bjornagin
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
