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

    Crosstab average column

    I'm using v2013, latest service pack. I looked at calculated member but I couldn't get it to show just for a grand total. lbass, great idea. I'll fiddle about with a second crosstab - that might just do the trick.
  2. Danster

    Crosstab average column

    I already have a crosstab with the columns and a total at the right (SUM). I just want to add another column AVG. Exactly the same as this old thread thread149-766735. That thread is around 4 years old and possibly using an older version of CR, so I'm wondering if anyone has any brilliant tips...
  3. Danster

    Displaying records in file with null datetime

    If I read your question correctly, you need to display records in the second table where the DATETIME is NULL? In the record selection formula, as BettyJ suggested, put in IsNull({YourDateField}). Crystal will only display records which match the above selection formula.
  4. Danster

    Print full last page, no headers or footers

    Thx, but do you find that Crystal is leaving blank space where the Page Headers (and footers) would print, even though suppressed? I can't use the OnLastRecord suppression formula because if an invoice only has a few lines, the OnLastRecord will be the first page, and I need them to display on...
  5. Danster

    Print full last page, no headers or footers

    I am hunting down a solution which works for this seemingly easy problem, but is massively difficult. I have seen the question asked on several forums, including here on tek-tips but nothing is working for me. I have a CR invoice layout. It has a few page header sections with company logo...
  6. Danster

    Rebuild index job massively increased DB size. How to get back down?

    Sorted (I think). I copied the database to another database for testing so I don't impact the live database. I found I fixed it by: Running my own REBUILD INDEXES script rather than using the Maintenance Plan. I set a FILL FACTOR of 90. After this ran to completion over the whole database...
  7. Danster

    Sql Server Implementation

    Am I stating the obvious if I say ODBC (for connectivity) over a VPN (for security)? cheers
  8. Danster

    restoring SQL08R2Std to Express 08R2

    So long as the database falls within the size limits of SQL Express, you should be fine, as long as the SQL08R2Std hasn't been service packed to increase the version higher than Express. SQL will not restore to a lower version. cheers
  9. Danster

    Rebuild index job massively increased DB size. How to get back down?

    As a general rule, I like to keep my databases reasonably efficient by running a Maintenance Plan to Rebuild Indexes and Update Statistics. Generally do it weekly. I was forgetting about FILL FACTOR, and the default for the instance is set to 0, which is what the Maint Plan job uses, so I...
  10. Danster

    Grouping data based on specific values

    Ken's right, this is more a database question. Your database view needs to have an extra column called Owner. Whether this comes from another table or not is something you'd need to know. If so, you need to have a table join.
  11. Danster

    How to suppress an entire "row" if one field is null?

    Best way to do this (in fact I'd say "the proper way") is to suppress the details section if email = "" i.e empty string. Right click the word on the left of your screen called Details, to the left f the design canvas. Go to Section Expert. Click the X+2 button next to Suppress. This gets you...
  12. Danster

    Runtime viewer export goes straight to Save report dialog

    Been a looooong time since I've posted here! I am a user & vendor of a ERP/financial application. The developers use Crystal runtimes as the reporting engine, so any hardcopy output is done via Crystal. Just about all reports display as print preview first, inside a CR Viewer window. A new...
  13. Danster

    Trigger For INSERT update field required

    Thx Denny, I definitely cannot update the inserted table, SQL warns me with an error "the logical tables INSERTED and DELETED cannot be updated" I can't write to the production table because there is no record yet to update. I need to set the value during the INSERT event. cheers Danster
  14. Danster

    Trigger For INSERT update field required

    I have a trigger which needs to update a field into my table only for an INSERT. My trigger reads thus... CREATE TRIGGER MyTrigger ON MyTable FOR INSERT AS DECLARE @SerialNo varchar (20) --Get the 6 char date SET @SerialNo = CONVERT(char(20), GETDATE(),112) SET @SerialNo =...
  15. Danster

    Resizing a static image

    Thx Gary. Just what I was after!
  16. Danster

    Resizing a static image

    Simple question but I don't know the answer... I'm just inserting a picture into a report. It's a company logo, but it's a bit too big. I just want to proportionally resize it dy dragging a handle, but it doesn't do it proportionally. I've tried dragging with Crtl & other keys, but hasn't...
  17. Danster

    Stored Procs and temp tables

    Ahhh. I see. I was about to post a big WOOOOOHOOOOO coz its working when I do the DELETE FROM, but I'll change it to TRUNCATE man, this has taken me so incredibly long! I'm stoked! Big fat star for you
  18. Danster

    Stored Procs and temp tables

    Yep, that works OK, but unfortunately, is is building up the second table with all the records from the first table as the program goes on. So I get VariableVal_1 field1 field2 field3 etc VariableVal_2 field1 field2 field3 VariableVal_2 field1 field2 field3 VariableVal_3 field1...
  19. Danster

    Stored Procs and temp tables

    George and others, I can't get the syntax right to copy the data from the first temp table into the second with my field. Ive tried INSERT INTO #MyTable2 @MyVariable, SELECT * FROM #MyTable but this doesn't work. I've tried INSERT INTO #MyTable2 VALUES (@MyVariable, #MyTable.Field1...
  20. Danster

    Stored Procs and temp tables

    No can do. The stored procs are part of an app and written by the developers (not me). I'm just running them for my own reporting requirements. But I still need the table.field value on the same row in #MyTable as the stored proc results. Other ideas? cheers

Part and Inventory Search

Back
Top