Adobe Community : Popular Discussions - Reporting

sub report in column header

forums_noreply@adobe.com — Thu, 24 Oct 2013 15:48:22 GMT

Infinite loop creating new page due to column header overflow.

I have a sub report on the column header which works,

Because my sub report return different records from data source, it fails and get infinite loop error message like above when I have 9 records, it works less than 9 records.

I would like to know my sub report returns records some times more, are there any place for my subreport?

Are there limit for sub report?

Your help and information is great appreciated,

Regards,

Iccsi,

Infinite loop creating new page due to column header overflow.

forums_noreply@adobe.com — Mon, 12 Sep 2011 19:27:44 GMT

i am getting an error and some pages "Infinite loop creating new page due to column header overflow. " --

using report builder 9, i have a fairly simple report - that contains 4 subreports.

for some pages i get the error - it seems if there is more data than would fit on 1 page.

smaller pages work fine.

the subreports are all simple queries and dumps....

containing page header, column header, detail sections.

page header has just a text bar of the name of the section.

column header has the field names

detail section has the data - 1 row for each row in the recordset.

nothing i do seems to change getting "Infinite loop creating new page due to column header overflow. " on a page with more than 15-20 records returned.

any ideas would be appreciated.

Fonts are not embedding in CFRB10, and CFRB11 reports it is still version 10??

forums_noreply@adobe.com — Thu, 02 Oct 2014 16:06:07 GMT

So, I have a report built using CFR Builder 10 with the fonts all marked as "embedded font" in order to make the report look as it should. However the fonts default to Helvetica when it generates.

So - I need to know why this is not working properly, since it should. All the HELP notes is that the PDF file will be larger with embedded fonts, which everyone should know already.

Second : I upgraded to CFRB11 to see if that issue was fixed, but when it opens it looks the same as CFRB10 and the HELP/ABOUT menu shows it is still version 10?? Is this just a bug or is Adobe pawning off version 10 as version 11. It should be a new version with the new CF version since it would need to include new functions etc, as well as have any issues fixed since version 10, of which there were a few.

Any ideas on either - or response from ADOBE?

I miss Macromedia, at least they always had staff members answering forum posts often.

"Chat with an agent" has 2-HOUR+ wait time !!!

forums_noreply@adobe.com — Thu, 16 Jan 2014 19:07:21 GMT

Does Adobe think customer service is a joke? Why is a 2-hour wait time acceptable? Someone contact me at b2bn@hotmail.com regarding a refund for an Adobe product I recently purchased. If not I'll just have to dispute the charge with my credit card company. Regardless of your attempt, forcing customers to wait over 2-hours for customer service will not stop me from getting a refund.

Tip - if you want to learn about a company and how much they value their customers, see how long it take to get in touch with customer service. That will tell you all you need to know.

Alternating row color for CF report Builder?

forums_noreply@adobe.com — Wed, 09 Jul 2008 13:37:45 GMT

I have a user who wants one of her reports to display alternating row colors for better read clarity. The reports are rather lengthy and the rows tend to blend in with eachother.

How do I Output SQL query (cfquery) to screen

forums_noreply@adobe.com — Mon, 01 May 2006 18:34:47 GMT

I'd like to output the completed SQL Query that I'm writing to CFQuery to the screen so I can see what the report is querying the database.

I tried <cfoutput>#myquery#</cfoutput> but that didn't work.

Shrink to Fit Text - ColdFusion Report Builder

forums_noreply@adobe.com — Thu, 22 May 2014 15:34:43 GMT

In ColdFusion Report Builder, is there a way to shrink text to fit a particular area? (as opposed to stretching with overflow)

Any help would be greatly appreciated!

- Chris

how to hide a report builder field if it is zero

forums_noreply@adobe.com — Wed, 02 Apr 2014 14:44:25 GMT

I am using Coldfusion Report Builder. If the value of a feild is zero, how can I hide it or show a blank. Keep in mind this field is a DollarFormat() field.

ColdFusion and SSRS

forums_noreply@adobe.com — Mon, 03 Feb 2014 18:21:08 GMT

Hello all,

How do I get ColdFusion to authenticate a user into SSRS? I'd like to get a way for a user to view a report in SSRS without providing any credentials.

Thanks

What is wrong here with my quick selection tool and tekst

forums_noreply@adobe.com — Fri, 13 Dec 2013 21:06:37 GMT

Hi I have ti right clik to se the selectet I show you a video so you can see because of my engles spelling is not the best here is the link https://www.facebook.com/photo.php?v=370911783055696&set=vb.100004106312048&type=2&theater

master detail report

forums_noreply@adobe.com — Fri, 25 Oct 2013 04:44:17 GMT

I want to create a master details report using CF 10 Report Builder, but I do not find the option.

I would like to know should I insert a sub report in to detail band to generate master details report.

If not, can you please advise what is the procedures to build master details report using CF 10 Report Builder.

Your help and information is great appreciated,

regards,

iccsi,

second sub report

forums_noreply@adobe.com — Tue, 22 Oct 2013 20:24:42 GMT

I have a report which has one sub report and works.

I just move this sub report from column footer to rpeort footer and add a new sub report to column report.

The main report and first sub report works still the same, but second sub report added does not show on the report.

The usb report works fine itself.

I just wanted to know are there any particular configure for more than one subreport on the report.

Your help and information is great appreciated,

Regards,

Iccsi,

Page Footer whitespace

forums_noreply@adobe.com — Thu, 26 Sep 2013 08:50:22 GMT

I have an invoice report that had N number of line items with N number of lines of description per line item. The invoice displays all of the line items, and then at the bottom of the last page, it provides a signature block for the customer to sign. Here is my problem: If I put the signature block in the page footer, it's displayed at the bottom - which I want - but repeated on every page. If I put the signature block in the report footer, it's displayed on the last page - which I want - but immediately following the last line item. I need it at the bottom of the last page only. The closest I have gotten is to try and predict the number of page that I will have and then hide the page footer until (what I think will be) the last page. However, this still have the page footer whitespace to show up which isn't right.

Report Builder - Last page issue and Report Footer issue

forums_noreply@adobe.com — Fri, 15 Oct 2010 19:36:10 GMT

I am using ColdFusion 9 Report Builder, am new to this product and encountering 2 issues.

Issue 1 - I have a field that I would like to print on the last page of my report. How can I determine the last page? I initially tried using a calculated field set to the 'highest' calc.Page_Number. Then I could compare the current page to the last page in the 'Print When' property. But calc.Page_Number can not be used in a definition of a calculated field.
Issue 2 - Depending on the amount of report detail, sometimes my report footer prints alone, without a page header and page footer. The report includes this page in the total number of pages. For example, if it is a 2 page report, the page header on page 1 will display Page 1 of 2. Then the only data on Page 2 is the Report Footer. No page header or page footer prints.

Any assistance on these issues would be most appreciated. To date, using the Report Builder has not been easy.

Template appears to be malformed

forums_noreply@adobe.com — Fri, 25 Jun 2010 15:26:04 GMT

I have a group of reports that work perfectly in CF7, but when I try to view them with CF9 I get the following.

The ColdFusion Report Builder report template appears to be malformed or contains errors.
The error is: java.lang.String cannot be cast to java.util.Map

The error occurred in C:\wamp\www\rl\views\order_guide.cfm: line 25

23 : </cfif>
24 : 
25 : <cfreport template="guides\order_guide.cfr" format="pdf">
26 :      <cfreportparam name="customerNbr" value="#URL.customerNbr#">
27 :      <cfreportparam name="storeNbr" value="#URL.storeNbr#">

Any thoughts?

Tons of CF Report Files ?

forums_noreply@adobe.com — Tue, 18 May 2010 08:44:16 GMT

Hi Guys,

I have tons of CF Report Files. Maybe 200 CFR files or more. Then all of them is using the template I've created before with default Input Parameters.

Is there a way that we update the Input Parameter in all CFR files using CF Report Builder or CF codes?

If this is not possible this will be a big cumbersome. I'm going to update the input parameter fields in all 200 or more CFR files.

Thanks in advance. Any idea CF Masters?

Cheers,

TheGame!

Calculate age in a function

forums_noreply@adobe.com — Tue, 16 Mar 2010 13:00:55 GMT

I am trying to calculate and return the age of a person. My code is:

I get a "If the expression is a string, ensure that it is within quotes. Error: report.ModStat(query.soc_sec)

is not a valid ColdFusion expression." error message when I try to run the report.

Any help would be appreciated.

Thanks.

CF8 Document PDF cutting off text

forums_noreply@adobe.com — Wed, 09 Dec 2009 13:16:44 GMT

I am facing text cut-off during CFDocument PDF page breaks.

I am using CF 8.

Anyone can help Plz ?

Thanks,

-SKS

cf8 report builder characterEncode ?

forums_noreply@adobe.com — Wed, 11 Nov 2009 02:55:56 GMT

HI,all

I am using win xp sp3/cf8.01, cf8 report builder,mssql2k5,IE6

There is the following requirement in a program:

When there is Chinese character in the label of report builder, but not get Chinese from the Database, as the picture illustrate below:

When the label in the Report is Chinese word, the Chinese words will replace by “?” if the Report generated into pdf file.

The final result as the following picture shows:

If press F8 button, the situation is below:

If I change the pdf character Encoding into identity-H, the problem still cannot be solved. Is there anyone who can tell me why and how to solve the problem? Thanks very much!

User inputted letters with dynamic fields in Report Builder

forums_noreply@adobe.com — Fri, 17 Jul 2009 18:37:42 GMT

I'm proactively trying to get certain aspects off our hands in IT and more specifically, the way letters are generated through ColdFusion. Right now we are using activeX controls (with some vbscript and asp pages) through IE to do Word mail merges for letter's for our students. We would like the user to be able to change these letters by themselves through our web application and have them saved in our database so they can be stored as a future template.

Now I'm new to Report Builder and have a few examples to show my colleagues, but I'm having troubles being able to dynamically insert the student's name (for example) into the report.

So basically I have an empty template with a huge dynamic box for the text which reads #param.MessageBody# that comes from a textarea within the cfm page. That works, but taking it one step further, I want to replace all instances of "%%StudentName%%" within that MessageBody with the actual student's name.

Since I cannot loop over the report and do my usual ReplaceNoCase(lMessageBody, "%%StudentName%%", Trim(ReportQueryLetters.StudentName), "ALL")>, how can I put this into a built-in function into the report?

I figured the function needs to be in <cffunction name="BeforeExport"> and while a simple display of the message works perfectly, I cannot get my replace line to work. I am passing the query to Report Builder instead of having it built-in, is that my problem?! I would prefer if it was external to save my stored procedures if I can. Is there any way to call the query to get that line to work?!

The code inside the cffunction (in report Builder):

The error:

Element STUDENTNAME is undefined in REPORTQUERYLETTERS.

Adobe Community : Popular Discussions - Reporting

sub report in column header

Infinite loop creating new page due to column header overflow.

Infinite loop creating new page due to column header overflow.

Fonts are not embedding in CFRB10, and CFRB11 reports it is still version 10??

"Chat with an agent" has 2-HOUR+ wait time !!!

Alternating row color for CF report Builder?

How do I Output SQL query (cfquery) to screen

Shrink to Fit Text - ColdFusion Report Builder

how to hide a report builder field if it is zero

ColdFusion and SSRS

What is wrong here with my quick selection tool and tekst

master detail report

second sub report

Page Footer whitespace

Report Builder - Last page issue and Report Footer issue

Template appears to be malformed

The ColdFusion Report Builder report template appears to be malformed or contains errors.

Tons of CF Report Files ?

Calculate age in a function

CF8 Document PDF cutting off text

cf8 report builder characterEncode ?

User inputted letters with dynamic fields in Report Builder