Formula Field Not growing when in the same page footer as a sub-report -

-

basically, have formula runs while printing records, can print 0-3 rows using chr(13) , global stringvars form final string (tried chr(10) , chr(13)), in same page footer sub report can have anywhere 0 rows above 3. both set "can grow" formula field never grows past sub-report.

i'm using crystal reports 9.

i tried using box around formula leading previous page footer page footer.

here's formula

whileprintingrecords; global stringvar wd; global stringvar adv; global stringvar nasc; stringvar final :="";  if wd <> "" , adv <> "" , nasc <> "" final := wd  + chr(13) + chr(10) +  nasc + chr(13) + chr(10) + adv else if wd = "" , adv <> "" , nasc <> "" final := nasc + chr(13) + chr(10) + adv else if wd <> "" , adv = "" , nasc <> "" final := wd + chr(13) + chr(10) + nasc else if wd <> "" , adv <> "" , nasc = "" final := wd + chr(13) + chr(10) + adv else if wd = "" , adv = "" , nasc = "" final := ""; final

and here's sample of 1 of 1 of formulas set stringvars, follow same method. 

whileprintingrecords; global stringvar adv; global stringvar status;  if({column1}="ex"    or {column1}="adv"    or {column1}="cr"    or {column1} = "des" )  ( adv := "#     - exempt";  status := "status"; "#") else ""

each subreport has it's own details section , if fields set there, shows results of rows, if put in footer. conversely, formula set in footer (page or report) works in aggregate form, because footer supposed used aggregate result (max,min,sum etc). if put formula in footer , edit return field value or has field's value, return result first row of select (like top 1 in sql), think.

of course not sure because have not displayed results or schema, case seems it


Comments

Post a Comment

Popular posts from this blog

google api - Incomplete response from Gmail API threads.list -

-
i plot number of emails in inbox on time using gmail api , i'm seeing lot of drop-outs, whatever reason i'm getting incomplete count of messages @ single time points. my plots here: https://plot.ly/~tdsmith/2 -- "drop-outs" i'm complaining trace shoots downwards , recovers previous level @ next timepoint. the code i'm using count emails here: https://github.com/tdsmith/gmail-plotly/blob/master/gmail-plotly.py#l47-l64 what can diagnose these faults?
Read more

Installing Android SQLite Asset Helper -

-
i need use ready made database. search solution on internet did not work until decided use mentioned library found here . however, found hard use library in installation procedures shallow beginners. i appreciate step step procedure on how use android studio. in struggle tried copying sources main/libs , adding line gradle did not work. use api 19 if helps. update here build.gradle // top-level build file can add configuration options common sub-projects/modules. buildscript { repositories { mavencentral() } dependencies { classpath 'com.android.tools.build:gradle:0.11.+' compile 'com.readystatesoftware.sqliteasset:sqliteassethelper:+' // note: not place application dependencies here; belong // in individual module build.gradle files } } allprojects { repositories { mavencentral() } } trying compile project error error:(9, 0) no signature of method: org.gradle.api.internal.artifacts
Read more

Qt Creator - Searching files with Locator including folder -

-
one quick question qtcreator : know possible use locator open files using "ctrl-k" shortcut. however, possible search files including locations? for example, let's want locate file named "main.cpp" in folder named "myfolder" , have lots of other main.cpp files. what should type locator in order open ? just type myfolder/main.cpp in locator
Read more