Search results for query: *

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

your first table "left" will return back everything regardless of what is in the outer tables met the criteria or not

also you can go to the format section the subreport is in, must be its own section and in the Linking you add that table to your main report, and put a formula in the supress that says LinkedSubTableField <> MainTableField make sure to go into the main sections Show SQL Querry and modify the...

the reason im doing this is because crystal does not proportion each photo correctly if the box is set to false on can grow and i may have several or hundreds of diffrent picture sizes and thats going to look pretty strange if i had a big picture of a midget but when you view it in crystal he...

I have a report that contains a BLOB wich holds an Image &quot;Bitmap&quot; from MSSQL database using Crystal v8. I want to keep the BLOB field from growing so as not to get all crazy and such if the actual picture size is larger than the dimensions i set. well if thats the case i have a formula...

put call in front of it, thats a function, and you must call it or else it thinks your assigning it to something thus giving the error expects '='