ColdFusion

Reporting Style - coldfusion

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2009

Posts: 1

Reputation: keeran6 is an unknown quantity at this point

Solved Threads: 0

keeran6

Offline

Newbie Poster

Reporting Style - coldfusion

19 Days Ago

First of all, am in the process of learning cold-fusion coding.

I have a doubt in reporting part of coldfusion code.

I need to make a report style such as below

A B C Pass
x B x Fail
A x C Pass
A x x Pass

Presently am able to get display data table like below:

ABC Pass
BFail
ACPass
APass

Where A,B,C are feed group;

My coding specific to looping is below:

 Help with Code Tags 
 coldfusion Syntax (Toggle Plain Text) 
<cfoutput query="PromotionInfo" group= RID> <tr>
 
<cfoutput group="feed_group">
 
               <cfif IsSimpleValue(Feed_Group) >
 
                          <td  nowrap><a href="#PromotionInfo.Report#" target="_blank">#PromotionInfo.feed_group#</a></td>
 
                    <cfelse>
 
                          <td><strong>N/A</strong></td>
 
                </cfif>    
 
  </cfoutput>
<cfoutput query="PromotionInfo" group= RID> <tr>

<cfoutput group="feed_group">

               <cfif IsSimpleValue(Feed_Group) >

                          <td  nowrap><a href="#PromotionInfo.Report#" target="_blank">#PromotionInfo.feed_group#</a></td>

                    <cfelse>

                          <td><strong>N/A</strong></td>

                </cfif>    

  </cfoutput>

I tried for looping, still no sucess so far..

Note: Problem here in looping is When I tried cfif/Cfloop condition's for every column-wise data,

cfoutput for PromotionInfo.feed_group gives ABC (joined values) not separately ie. for each cycle of loop the data queried are shown in one single row. Am not able to split it since they are not having any delimiters.

Am not sure I gave the right picture of my problem, still expecting someone can help me..

Thanks

Keeran

Last edited by peter_budo; 17 Days Ago at 7:17 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)