Search results for query: *

Hello, We are looking for a location to host Saberlogic's Logicity Solution Builder to run Crystal Reports (XI) at scheduled times. One suggestion has been to host LSB on one of our virtual servers and schedule these tasks outside of business hours. The questions that have come up are:What...

Based on what you folks are saying, it sounds like if we standardize all users to CRXI at the same time as our Windows 7 upgrade Q2 or Q3 this year, then move up to CR2008 in 2012, we should be fine. I haven't found anything on SAP's website regarding an endate for CRXI support cycle. Thank...

Thank you both for your responses. Q

Hi Fish, Thanks for your quick response. We've tested XI on Win7 in a pilot project, and are satisfied with that config. Our software management team have suddenly become version conscious, are suggesting a move to CR2008 (more testing), and are inquiring if there's anything been released since...

Hello, We currently have a blend of Crystal Reports versions in our corporate environment. CR8.5, 10, and XI. We're going to be upgrading from XP to Windows 7 in 2011 and are about to standardize the CR version to XI as it is Win7 comaptible. CR 2008 is 4 years old. Does anyone know if there...

The Logicity Crystal Reports Viewer might be considered a candidate for your requirements. The free version provides an easy-to-use app that can refresh a .rpt, add parameters, search the generated report in the viewer, convert to .pdf and other formats, email the report, schedule Logicity to...

Cricket, Fisheromacse, We'll review the manner we currently generate barcode labels. Thanks for the assistance with this. Q

Hi Cricket, Thanks for your reply. My apologies for taking so long with my reply. The barcode font being used in these labels is IDAutomationHC39M (free download) which gets added to the CRXI font list. The capability to toggle The Human Readable setting on/off is not part of the font...

Hello, Is anyone in our CR community aware of a barcode font that displays the barcode's alphnumeric value above the barcode instead of below? I'm currently using 3 of 9 in CRXI and the location of the barcode's numeric value is obstructed (by client process). Client does not wish to move...

Hello LB, Removed the ToNumber() on formula @Microfilm_ID, and the result worked beautifully! Your help with this is very much appreciated! (and educational) Thanks, Q

Not successful at retrieving the image count per batch. Microfilm ID consists of 2 parts, Julian date & series number separated by a space. (e.g. 10049 50361). Lbass assisted with: ----------------------------------------------------------- @MICROFILM_ID...

LBass, Works very nicely! I apologize for taking this long to get back to this post. Created the formula @Microfilm_ID as: ------------------------------------------ replace({DOCMETA.XMICROFILM_ID}," ","") ------------------------------------------ Updated SEQ formula as recommended: When...

LB- Thanks for the additional info & time spent on this. I'll update post as soon as we have a opportunity to make the changes. Q

LBASS, confirmed it is the space causing the error by using some microfilm IDs with no space in the Oracle test environment. The correct format will always be with a space after the 5th character. I will attempt to reformat the microfilm id (no space)in a separate formula & pull that into your...

Doesn't like the space in the microfilm ID? I need to retain the space in the final format. Q

LBASS, thanks for your prompt reply! All fields coming over from the Oracle table are varchar. I've had to convert the microfilm id fields to numbers using CDbl(). No errors found in the formula, but I'm getting "The string is non-numeric" error on the first "CDbl({DOCMETA.XMICROFILM_ID})" in...

Hello, Using Crystal Reports XI. Am trying to create the following format in a report. The data comes from an Oracle database table. I have a list of digital images, each its own “microfilm id” scanned in batches. The batches are reviewed and at times some images deleted and rescanned at a...

Hello lbass, Works beautifully! Great solution. Your help with this is much appreciated. In summary, we have 2 views 1.) VU_Barcode: Select TO_CHAR(to_date(sysdate), '*yyddd')||'='|| to_char(rownum + 49999)||'*' as BARCODE, TO_CHAR(rownum + 49999) SERIES_NUM From ANY LARGE TABLE where rownum...

I came up with this in a view: Select TO_CHAR(rownum + 0) QUANTITY from a table where rownum < 3 The resulting dataset is: Row # QUANTITY ----------------- 1 1 2 2

Thanks lbass. I'll update this post with an outcome as soon as our DBAs build this table! Protocol, priviledges, etc... Q