Re: Report Building? Any Options or Solutions
Hmm, that sounds complicated. When you say RB, do you mean CFRB or something else? And what are the sub reports for, in other words do they run concurently or do they take certain reality space? If they take reality space then you would need to look into a grow option, but my experience with sub reports is that the sub report defines the space required. It sounds like that the Report is not designed in the most efficent manner for what you are trying to achieve. On 4/13/07, Graham Pearson [EMAIL PROTECTED] wrote: I am working with RB and have ran into a problem which I am unable to solve. My Report has 6 SubReports which I would like displayed one right under the other however I as a developer do not know how much space to give each subreport and this report will be used as documentation within the educational market. At the present time I have text within various subreports overlapping and would like to know if this can be solved if it can not be solved, is their anything in existence that can create semi-complex reports which will be displayed via the web. The educational agency that this application is for can not afford Crystal Reports so moving to that is out of the question. What are people doing to create professional semi-complex reports for their applications. -- This message has been scanned for viruses and dangerous content by our email content filter. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275110 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Building? Any Options or Solutions
The RB is CFRB. The Report I am trying to generate is one where a principal in a school will select a date range and a listing of teachers along with a list of objectives that they would like to run this summary report on. I then create the necessary queries to pull in all audits that fall within the date range, and have been performed on the list of teachers. I then perform another query on the previous query to create a query of only the audits which the principal would like to see objectives on. So right before the report is displayed on the screen I have a query which has the School Public Data, 3 Form Variables which are the Selected Teachers, Start Date Range, End Date Range and a Query which lists all objectives with one objective per row that has an ID number, Category Name like Students Participation, Score0 through Score5, Total and Average. Now this list can be 1 Row or 100 Rows as it all depends on the principal and what they have selected. In my previous attempt at this report through CFRB Each of my subreports were one objective which I passed into the primary report as a param. This did work however if one Objective had 15 records the objective which was next would overlap on some of this one objectives. In the CFRB I tried all of the options to find a way that if I made each of the subreports 1.000in and had 8 subreports included on this main report for each of the objective areas, and one of the objective areas had 25 records to display, it would be nice for that subreport to display fully then the next subreport would start at the end of the previous subreport instead of starting at the inch location in the properties of that subreport. This report might not be designed in an efficient manner as this is the first time in history that I have needed to generate what I would call a professional type report. Hmm, that sounds complicated. When you say RB, do you mean CFRB or something else? And what are the sub reports for, in other words do they run concurently or do they take certain reality space? If they take reality space then you would need to look into a grow option, but my experience with sub reports is that the sub report defines the space required. It sounds like that the Report is not designed in the most efficent manner for what you are trying to achieve. On 4/13/07, Graham Pearson [EMAIL PROTECTED] wrote: I am working with RB and have ran into a problem which I am unable to solve. My Report has 6 SubReports which I would like displayed one right under the other however I as a developer do not know how much space to give each subreport and this report will be used as documentation within the educational market. At the present time I have text within various subreports overlapping and would like to know if this can be solved if it can not be solved, is their anything in existence that can create semi-complex reports which will be displayed via the web. The educational agency that this application is for can not afford Crystal Reports so moving to that is out of the question. What are people doing to create professional semi-complex reports for their applications. -- This message has been scanned for viruses and dangerous content by our email content filter. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Report Building? Any Options or Solutions
Ok the only solution as I stated would be to ue the option after importing the sub report, would be to set it to can grow, that is what it is in CR but not sure about CFRB as it crashes under Vista. If all else fails you could look at iReport, aka Jasper Reports (free and open source) and is what is embeded into CF MX. However you will have the same problem, I would imagine. The reason I asked about the design and whether it ran consecitvely or not is that you could use a page break between each sub report. On 4/13/07, Graham Pearson [EMAIL PROTECTED] wrote: The RB is CFRB. The Report I am trying to generate is one where a principal in a school will select a date range and a listing of teachers along with a list of objectives that they would like to run this summary report on. I then create the necessary queries to pull in all audits that fall within the date range, and have been performed on the list of teachers. I then perform another query on the previous query to create a query of only the audits which the principal would like to see objectives on. So right before the report is displayed on the screen I have a query which has the School Public Data, 3 Form Variables which are the Selected Teachers, Start Date Range, End Date Range and a Query which lists all objectives with one objective per row that has an ID number, Category Name like Students Participation, Score0 through Score5, Total and Average. Now this list can be 1 Row or 100 Rows as it all depends on the principal and what they have selected. In my previous attempt at this report through CFRB Each of my subreports were one objective which I passed into the primary report as a param. This did work however if one Objective had 15 records the objective which was next would overlap on some of this one objectives. In the CFRB I tried all of the options to find a way that if I made each of the subreports 1.000in and had 8 subreports included on this main report for each of the objective areas, and one of the objective areas had 25 records to display, it would be nice for that subreport to display fully then the next subreport would start at the end of the previous subreport instead of starting at the inch location in the properties of that subreport. This report might not be designed in an efficient manner as this is the first time in history that I have needed to generate what I would call a professional type report. Hmm, that sounds complicated. When you say RB, do you mean CFRB or something else? And what are the sub reports for, in other words do they run concurently or do they take certain reality space? If they take reality space then you would need to look into a grow option, but my experience with sub reports is that the sub report defines the space required. It sounds like that the Report is not designed in the most efficent manner for what you are trying to achieve. On 4/13/07, Graham Pearson [EMAIL PROTECTED] wrote: I am working with RB and have ran into a problem which I am unable to solve. My Report has 6 SubReports which I would like displayed one right under the other however I as a developer do not know how much space to give each subreport and this report will be used as documentation within the educational market. At the present time I have text within various subreports overlapping and would like to know if this can be solved if it can not be solved, is their anything in existence that can create semi-complex reports which will be displayed via the web. The educational agency that this application is for can not afford Crystal Reports so moving to that is out of the question. What are people doing to create professional semi-complex reports for their applications. -- This message has been scanned for viruses and dangerous content by our email content filter. ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275116 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Report Building? Any Options or Solutions
I am working with RB and have ran into a problem which I am unable to solve. My Report has 6 SubReports which I would like displayed one right under the other however I as a developer do not know how much space to give each subreport and this report will be used as documentation within the educational market. At the present time I have text within various subreports overlapping and would like to know if this can be solved if it can not be solved, is their anything in existence that can create semi-complex reports which will be displayed via the web. The educational agency that this application is for can not afford Crystal Reports so moving to that is out of the question. What are people doing to create professional semi-complex reports for their applications. -- This message has been scanned for viruses and dangerous content by our email content filter. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
