Recent content by Danster

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.

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

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.

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

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

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

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

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

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

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.

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

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

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

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

Thx Gary. Just what I was after!