Search results for query: *

Hi ALL Does crystal report run on MYSQL thanks fsreport

Hi Folks Does Crystal report run on MYSQL?? I want to setup a system DSN Witch one of the database should i choose thanks fsreport

As printing technology keeps getting cheaper, we find some amazing printing features installed in our offices. One great feature is the ability of a printer to duplex print on both sides of the page. If you use this with your reports, you can reduce your paper requirement by almost half.But...

The current choices to display a negative number are to use a minus sign or to add brackets around a negative number.Back in our old COBOL programming days, we often wanted to display a negative number with a “CR” suffix. A bank might want to display “OD” if your account balance dipped below...

Hi All I'm using excel and asking if possible to add the date from jan 1 to dec 31 on an excel spread sheet like this here is how my spread sheet look like Collumn A 1-Jan 2-Jan 3-Jan and all the way to dec 31 not have to enter date for each cell fsreport

Hi CR 9.0 MS SQL i have check in the report option select distinct records select distinct records for browsing this report that contains 2 group only gr1 channel gr2 UU_Ref my records return from the report sql is a sample Channel***SCHTYPE****SCHNOTES****SCHSTART******Status...

hi folk Ms sql 2000 is there a way to speed up an index view. Can someone have some code for sample how to thanks fsreport

hi All Brain freeze here i have a stored procedure and it has no parameter in it i would like to created a parameter in crystal and pass it to the store procedure. Ex:let say i created parameter in crystal base on employee ID How will i go about creating it. I know how from a table but never...

hi All Ms. SQl Cr 9.0 I need youe help on this declared variable i have one for Territory like this //{@reset} to be placed in the territory GH: whileprintingrecords; numbervar cntforterr := 0; //{@accum} to be placed in the contact ID group footer: whileprintingrecords; numbervar cntforterr...

Hi -Lb for some reason it resetting the count even when it the same territory ex: C01 on the first page the accum number start at 3 and end at 47 second page it start a 0 and ends at 50 third page start at 2 and ends at 48 page 3 start at 1 to 25 page 4 start 0 to 25 page 5 start 1 to 16 then...

Hi All MS sql cr 9.0 My co-worker drop me off this report his stuck. In the report he has this this formula @SMA_Division sum({@Sale_SMA},{vw_all_contact_labels.CONTACT_ID})/{#GroupCount} my running total is #GroupCount is difine like this field to summarize: vw_all_contact_labels.LABEL_NAME...

ms sql cr 9.0 i have a running total that gives me a number and i have a summary that need to be divided by this running total. ex: count amount 2 100 i need to have the amount divided by count the summary is a sum(gross_amount,contact_id) my running total is...

Hi All Cr 9.0 MS SQl i have a report that has 2 parameter for selection {?Sale_Amount} {?Redemption_Amount} i have these 3 formulas @Sales if {TRANSACTION_HISTORY.TRADE_CLASS} = "S" then round({TRANSACTION_HISTORY.GROSS_AMOUNT}) @Redemption if {TRANSACTION_HISTORY.TRADE_CLASS} = "R" then...

Hi All cr 9.0 ms sql i have a report and 1 group in my report i have top5 records return ex: ph****company**** amount gr1 detail @amount(created summary on gr1) grft***ABC*********1000 *******DEF*********900 *******CDE*********800 *******GTH*********700 *******BYT*********600 Is...

Hi All cr 9.0 ms sql I have a main report thst has 1 group and it only returns the top 5 records on the report ex: ph: *** TOTAL LEGG MASON FUNDS / SMA ***Top 5 Territory gr1: territory****sales****red***net grft:INSURANCE****100******200***300 *****FUNDS********200******100****300...

hi All cr 9.0 ms sql i have table and the month is number and year is number and a parameter call month and the other year if i want from from PYTD is this ok if {ASSET_HISTORY.ASSET_MONTH} in [1 to {ASSET_HISTORY.ASSET_MONTH}] and {ASSET_HISTORY.ASSET_YEAR} in [{?Asset_Year}-1] then...

Hello All Cr 9.0 MS SQL i have a main report and a sub report on the main report i have 2 subtotal {@Sub_Tot_1} {@Sub_Tot_2} in my sub report i have {@Sub_Tot_3} I need to pass the value from {@Sub_Tot_3} to my main report so i can add {@Sub_Tot_1}+{@Sub_Tot_2}+{@Sub_Tot_3} to give me my...

Hello All cr 9.0 ms sql i have a report and it shows duplicated name contact group on here is my formula fsreport

Hello All cr 9.0 MS SQL i have this report and has one group gr1 uni_user.uu_ref my table are calshed.tbl and uni_user.tbl link calshed.schfor = uni_user.user_id ***************************************** and my running total are like this Field to summarize: Calshed.schtype Type of summary...

Hi Folks cr 9.0 ms sql i have this report and need to show all contact that does not match the the rep_alias table in ms sql query designer i used this *************************************** select contact_id from contact where contact_id not in (select contact_id from rep_alias ra, firm f...