Search results for query: *

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

Got it. So I would put Sheet1.QueryTable(1).Refresh in that event. Silly question. If I want a few queries to update different cells, would I add them within the same vba module? And do the subsequent queries become QueryTable(2).. (3) etc.?

Thanks guys! One other quesion. I want the values to be refreshed when the user opens the spreadsheet. I've seen mention on the net about putting code in the workbook_open event to accomplish this. Would I just put a "ActiveSheet(or whatever my sheet name is).QueryTables(1).Refresh" in that event?

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

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

I could have swore that I tried the very same modification you suggested before my last post and it didn't work. This time it works. [blush] Again, thank you.

Now that I've tinkered a bit more I have one other question based on the logic above. I am creating both a total both at the group footer and report footer. I did as you described above for the group footer and it works great. To also get a report total I modified the formula in the group footer...

That worked! Thanks for your helpful speedy response. Bjorn

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