Recent content by konad

I have a very large Stored Procedure in MSSQL2000 that im calling and giving it 4 parameters, and returning Many Parameters, that are populated by calculations within the same stored procedure, the problem is if i run the sproc for the first time that day using {CALL SPROC_GETVALUE('1/1/2003'...

there are several tutorials you can download from the seagate site that show you exactly how to do this in vb and a few other languages

do all machines have the same crystal reports update patches?

it is not very clear what you are trying to do with the report viewer or your report or recordsets are you setting an existing report = to your recordset results and trying to open it into a Viewer or ?

yes it can be set at runtime thats why i posted some of the code for it there, and crystal doesn't exactly tell you that you can but i trialed and errored through it till i was able to do just about anything at runtime

also bear in mind i was looking for that blobfield and when i found it i set the current section = to the withevent section, but if i had multiple formatting in diffrent sections i set the withevents section = nothing before i set the current section = to it

you can do it in the Section Format Event of the Report, here is a VB Code example where im resizing a BlobField Image to keep the same ratio of its original width and height to keep it from being stretched out of proportion. Option Explicit ' ***** Modular Declarations Private WithEvents...

the subreport has to be changed at the customers site to point to the correct Location, changing the main reports is only for the main, go to the sub and edit and then link it properly

there are several Crystal Tutorials in your help files in Crystal that show you this, in fact you can go to crystals site and download a few programs that do exactly that

ok, a large problem was with Jasc Paint Shop pro v7 reporting the image size wrong, not sure whats up with that

yes the picture is displayed fine, but to resize it means that any picture that comes up in this report with new search parameters is going to be sized wrong as well which will ultimitly cause problems depending how large the picture is because of the scaling factor crystal implements, crystal...

i have a report linked to SQL Database, i have a Blob Field inserted onto the report for a bitmap field in my database, on the initial record i know the photo's dimensions are W 313 pixels by H 235 pixels, which is W 4.347 inches by H 3.264 inches, which i have verified by the original image...

also check your subreort linking, make sure you are not linking

you don't need to add the table 2 times, simply link your origin and destination both to customerid then modify your Crystal SQL statement to say OR instead of AND, and if you need to modify your join from inner to say LEFT OUTER depending how you want your records returned if there is a match...

parse it out by doing a string search like Right({table.tablename}, 15) Returns the last 15 characters of the field as a String. then you could do an isdate() function on that returned string to make sure you got it