Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
EddieLotter
Advocate
EddieLotter
Advocate
Activity
‎Oct 01, 2013
10:56 AM
iccsi wrote: It seems that the subreport query does not follow the order by in the stored procedure. This is a different problem. It is best to start new threads with new problems. Are you sure the result-set is sorted the way you expect? The reason I ask is because I don't think the report changes the result-set. An easy way to verify is to look at the result-set returned from your stored proc to be sure what it looks like, for example: <cfdump var="#mysubStored#"> <cfabort>
... View more
‎Oct 01, 2013
09:02 AM
iccsi wrote: I would like to know any way to set sub report and main report to run a report which has sub report on it, If I understand you correctly, you want to pass a result-set to your subreport from the calling CFM script. To do so, you need to give your subreport a unique name in the Report Builder and then you can do something like the following: <cfreport format="PDF" template="MainReport.cfr" query="#mydata#"> <cfreportparam subreport="SubReportName" query="#mysubStored#"> </cfreport>
... View more
‎Oct 01, 2013
08:33 AM
"session start" is a server side concept. The server cannot access the client's temp directory. Please explain what you are trying to achieve and perhaps we can suggest some solutions.
... View more
‎Oct 01, 2013
08:27 AM
Have you tried conecting to MySQL with any other software? (The problem might not be with CF)
... View more
‎Oct 01, 2013
08:24 AM
That does make it difficult, however, if your line items are a fixed height then you can calculate whether the last page will have the overlap problem. You can have two subreports, one with a page break and one without. You can show the relevant one depending on the overlap calculation. Purely for intellectual curiosity, why does the signature block have to be bottom aligned?
... View more
‎Sep 30, 2013
08:44 AM
Use a subreport in the main report's footer.
... View more
‎Sep 30, 2013
08:41 AM
I can confirm that even if the page footer is set to print only when a condition is true, all pages reserve the size of the footer. What you can do is put your signature block fields in the "Watermark" band and set them to only print on the last page. Since the watermark can print anywhere on the page you can put the fields in the exact positions you want them to appear on the page. If the signature block has a lot of fields, you can conveniently put them in a subreport and put the subreport in the Watermark band. That way you only need to set the print condition on the subreport rather than all the fields.
... View more
‎Sep 26, 2013
11:40 AM
I'm afraid I am not an expert in Excel, so I am not familiar with its limitations. What you could do is create a macro in Excelto replicate what you're doing in CF. If the macro fails then the problem is with Excel. If the macro succeeds then the problem is with CF. Did you do the comparison after unpacking the file as I mentioned in my previous reply?
... View more
‎Sep 26, 2013
10:42 AM
Rename bigSheetTest.xlsx to bigSheetTest.xlsx.zip and then extract it. I also noticed you're writing to the root of the C: drive. You should only write to a folder that is guaranteed to be accessible to the CF server. I will test CF9 when I get a chance and let you know what I find.
... View more
‎Sep 26, 2013
08:49 AM
Just a shot in the dark, but are you using the domain attribute of the cfCookie tag? There is also the setDomainCookies attribute of the cfApplication tag that might help you. Message was edited by: Eddie Lotter: Additional info.
... View more
‎Sep 26, 2013
08:45 AM
I'm using CF9 so running the test won't help you in your environment. However, I am interested to know if you opened the good and the bad xlsx files in a plain text editor and compared them? Is CF10 emitting bad XML in the bad file?
... View more
‎Sep 26, 2013
08:35 AM
There are two ways I can think of, off the top of my head, perhaps others will chime in with more ways. The first is to use cfDocumentSection in a loop. Inside the cfDocumentSection have a sub-loop that iterates the desired number of rows. cfDocumentSection automatically creates a page break. The second way is to use cfDocumentItem with type="pagebreak" at the point where you want a page break. I hope this helps.
... View more
‎Sep 26, 2013
08:27 AM
Are you using the "Print When Condition" of the Page Footer itself, or of a field in the Page Footer?
... View more
‎Sep 23, 2013
12:22 PM
The quickest solution I can think of, off the top of my head, would be to have another calc field that stores the value of course.credits when course.course changes. When course.course changes, you can use the new calc field to print the total and then reset the new calc field.
... View more
‎Sep 23, 2013
10:41 AM
Please show your SQL query and also how you are calculating "calc.counter".
... View more
‎Sep 18, 2013
08:03 AM
The cfgraph tag is deprecated, look at the "format" attribute of the cfchart tag for supported graphics formats.
... View more
‎Sep 18, 2013
07:41 AM
You're very welcome. Glad I could help.
... View more
‎Sep 17, 2013
11:08 AM
There are at least two ways to handle this. The first way is to pass the column headings to the report as parameters. The second is to use a sub-report that uses a one record result-set which contains the column headings. You will need to set the sub-report's margins to zero to get things to line up properly.
... View more
‎Sep 17, 2013
10:57 AM
Unfortunately the Report Builder does not provide a way to access the field and label properties at runtime. The only way to make a label/field change its color depending on a value is to create multiple labels, one on top of the other; then use the "Print When Condition" property of each label to determine which one is visible for a given condition.
... View more
‎Sep 17, 2013
09:04 AM
If you are still having a problem with this, post a reply and we can work through the problem. I suspect you are setting up your calculated fields incorrectly.
... View more
‎Sep 17, 2013
09:02 AM
Are you talking about tabular columns (fixed columns) or report columns (dynamic flow)?
... View more
‎Sep 17, 2013
08:59 AM
Where the data comes from is irrelevant to the report. The report will use whatever result-set you give it. If you elaborate on what you're having difficulty with then perhaps we can get to the bottom of it.
... View more
‎Sep 17, 2013
08:57 AM
Place a check in the "Start New Page" check-box in the properties of your group. This will allow your page header to print correctly for each group.
... View more
‎Sep 17, 2013
08:52 AM
One trick is to create dummy report groups so that each sub-report can go in its own band in the report. Each group has a header and a footer, so it can accomodate two sub-reports.
... View more
‎Sep 17, 2013
08:49 AM
You would be far better off writing your query in such a way as to return only the data you want to see in your report, rather than trying to get the report to ignore certain records in the result-set.
... View more
‎Sep 17, 2013
08:47 AM
Try something like the following: and nmedu.date_rec = #iif( isDate(param.graddate1), createOdbcDate(param.graddate1), de("NULL"))#
... View more
‎Sep 17, 2013
08:43 AM
You could handle this in your SQL query, for example: select isnull(nmedu.graduated, Date()) as graduated from nmedu, institut Check your database documentation for the supported syntax.
... View more
‎Sep 17, 2013
08:37 AM
The report builder is very fragile. Have you tried completely removing it and re-installing it?
... View more
‎Sep 17, 2013
08:35 AM
Yes, this is possible. For example, in the calling CFM file, add your parameter: <cfreportparam name="prmOrderBy" value = "order by LastName"> Then, in Report Builder, add the following line at the bottom of the SQL query: #param.prmOrderBy# Naturally you wouldn't hard-code the "order by" clause, you would use a variable. You could, of course, handle the query dynamically in your calling CFM file and pass the query result-set to the report so that the report does not run its internal query.
... View more
- « Previous
- Next »
Copyright © 2024 Adobe. All rights reserved.
AdChoices