Recent content by ulag

Hi Madawc, Thanks for your reply. I use CR10. I have suppressing table (separate one) which has list of ruleid to supress So the ruleid are in list. For each section, I assigned as ruleid. If the ruleid is presnt in table, I have to suppress. I mean I have to supress detail section (2...

I need to suppress section if the ruleid exist ruleid has multiple records (derived from another table, other than real data table) ruleid 2 7 11 25 any help?

Hi Madhi, Thanks for your reply. The above suggested solution did not solve my problem. Let me rewite the problem. I need to supress text or field value or section based on multiple conditions. It is not just multiple conditions alone. The conditions are selected from list of records. CR reads...

I tried like this: {B.Inactive} <> 1 and {B.ruleId}=2 and {B.reportId}=1 and {B.CompanyId)=10 still have the problem

Thanks. But, still not working.

I am using CR 10 I need to suppress a section(which has values from A), if the value of B.inactive is not 1 and certain other conditions The table B has records based on companyId, ruleId and reportId I try to use like this {B.Inactive} and {B.ruleId}=2 and {B.reportId}=1 and {A.CompanyId}=...

Thats what, I am trying to do. I use stored procedure to create data. For each sub-report CR execute stored procedure. If I link the data from main report to subreport the above prefered structure rearranges to different results. Now my questions is Is there any way, I can use the data from...

Crystal version 8.5 (soon will upgrade to 10) Database/connectivity used ODBC- stored procedure from SQL server 2000 Example data State Source Count AuditCount VCount DCount AuditPct Florida Agent3 1805 1063...

This works for one field. If I want to add another field (ie field3) then it results like field1 field2 field1 filed3 field1 field4 ... ....

I have multiple fields appearing in a single report data is like field1 field2 filed3 field4 ... ... ... .... I need to report like field1 1 field2 2 field2 3 field2 ... ... field1 1 field3 2 field3 3 field3 ... .... I...

select clip.RiskStateId, clim.DistributionSource as DistributionSource, Field1 , field2, Field3, Field4 from cli.policy as clip , cli.METLIFEPOLICY as clim where YEAR(clip.Expdt)= 2004 and MONTH(clip.Expdt)= 6 and clip.riskcheck=1 and field1=clim.IDnum group by...

Now it prints one page report per state. I want all state together

I have data from stored procedure with passed parameters. I need to create report like using CR8.5 Section1 state Amount ----- ------- CA $30 TX $25 .... Section2 state Value ----- ------- CA 130 TX 225 I have...

The path of register_globals on/off seems to be still unclear. First thing is I want to convert all my old code to register_globals off. Is it worth to change my old code? For my new project, I need to make sure write code register_globals off compliant. Do any one has idea the what is...

After upgrading to latest PHP (4.3.0), I am facing problem with sessions variables, form variables and so on. Right now most of hosting uses register_globals as on. I changed few, but would like to know from others, to list what all should be changed? I want the code should work either in...