I think I found it. My code should have been:
If .Field.ValueType = crDateTimeField Then
Using this seems to work anyway. Thanks for letting me vent.
lfb
Hi All,
Going out of my friggin mind trying to work this bloody thing out. Appreciate any help. I've searched everywhere but suspect I probably don't know the right keywords because this is so easy and I shouldn't be finding it so hard.
Using win xp, sp2, vb 6, crystal 10
referencing craxdrt...
Its an adUseClient connection so: static.
What I'd really like to do is grab the recordset, copy it into memory on the client and then perform aggregate functions on it, group, sum etc. Since I'm dealing with potentially thousands of records I'd like to avoid dropping it into an xl worksheet...
I know this sounds pretty basic but do you mean something as simple as:
Select * from Table_test where field3 = 'Smith'
This would return you all fields without having to hardcode them where your field(3) = Smith.
Hi all,
I'm using Excel 2003 and Win Xp sp2 to connect to SQL server 8 to return a recordset. Great tool because I can group the data before getting into xl which greatly reduces the number of records I need to retrieve.
Problem is I need to do another grouping on the recordset itself. I...
Just in case anyone is wondering. My solution to this was to build the main report using just the group heading TITLE_NO. Next I created sub-report with the grouping that I wanted, independent of the TITLE_NO. I linked by TITLE_NO and dropped this into the main report footer hoping that for...
Hi all,
I'm using crw 8.5, Oracle (not sure which version) and Win2k sp4 .
I want to extract some sub totals sorted by my second grouping instead of the first grouping. The complicating factor is the group selection formula.
I have two groups
Group 1: {ITEM.TITLE_NO}
Group 2: {ITEM.TECH_CODE}...
Hi Gary,
Thanks for your response.
Inside VB when using the Crystal Report Designer the right click option says "Format Multiple Objects".
When running the Crystal Reports application the right click option says "Format Objects".
In both cases they perform the same function.
In previous...
Hi All,
I'm using CRW9 SP 2 in VB6 (SP5) with ADO recordsets.
Quick question: I've just upgraded to CR9 and when i use the "Format Multiple Objects" right click funtion, it does not seem to do anything. Normally it would copy the font, font size, font style, colour, suppression formula's of...
Hi All,
I had already uninstalled CRW9 SP 2 and started receiving these errors. I found the fix by following the instructions at http://support.businessobjects.com/library/kbase/articles/c2009848.asp
However, the one step they did not include that made all the difference was:
1). unregister...
Hi All,
I've done some more research using the sample data shipped with Crystal version 9. You can find this in C:\Program Files\Crystal Decisions\Crystal Reports 9\Samples\En\Code\Visual Basic\Inventory Demo\Inventory.vbp.
I ran this, quit the report (not the app), ran it again etc 30 times...
Hi All,
I'm running Crw 9 sp 2 inside VB6(sp5) with SQL2000 back end on OS's WinXP, Win98, WinME, Win2k.
I'm finding huge, huge memory leaks occurring on client machines when they run a report.
When I first access our application it may be using, say 30mb of RAM (in Task Manager in the Mem...
Hi All,
Running crystal 9 Sp 2 in a W2k, XP environment in a VB 6 Sp 5 application.
I've noticed that previewing a report via terminal server (so we connect to a machine, run a report) or Citrix will display incorrect colours in the image. For example an image that is normall black text on a...
Hi All,
I had two drives on my machine. The master had ME installed, the slave Win2k. I always used Win2k and since this was on a bigger drive wanted to make it my primary drive then remove the old volume with ME to install on another machine.
So I managed to re-format this drive with ME (my...
Hi All,
Running Office XP.
I haven't even attempted to tackle this hoping that somone out there can direct me to a macro that already does it all.
I have a scenario where I am bringing in data to Excel that contains RTF code.
If you are not familiar with this, RTF editors store text with...
I had this exact problem. I found that my printer was using font substitution Arial -> Helvetica. Changing the setting to "No Substitution" the problem went away.
OFFICE 2000.
I have created a query to an external data source (SQL SERVER 2000 SP 2). The source contains a NOTES field that contains RTF text and code.
As soon as I bring the query into Excel the RTF formatting is pasted into the cell which makes it very difficult to read. I have tried to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.