Search results for query: *

Thanks again for the help Lbass!

Does any one know how to force a pagebreak if the details section contains more than, say, 6 rows.

Thanks for the help Madawc. Having solved one problem I now have another which I will start a new thread :-)

I'm using CR XI. My report paginates after each group and I want to print a group of fields (located in the group footer section) for an address at a specific location on every page. Since each group has varying # of rows in the details section, my address block is being pushed lower on the...

Exactly what was needed, Lbass! Thanks alot to you and Madawc for the help! Tom

It seems to me that if the group field is numeric, the format of the field in the group tree should be the same format as it is in the report section. It seems strange that the group field has to be changed to a text type in the grouptree to achieve the proper format.

Your suggested solution indicates that the Group Tree field is treated as text type. Is that correct? If so, I'm surprised that CR can't handle numeric types in the group tree, considering the power of the software in other areas.

I am using CR ver 11 and I want to format the grouped field in the Group Tree as single decimal and no thousands comma. I am able to format the group field OK in the report. The group tree is defaulting to 2 decimal places and a thousands comma. Any help? Tom

Using CR XI, I have a SQL command defined using the Database expert. The SQL command is simply, Select Sum(Column1) As TotalA FROM Mytable WHERE Column2='A' When I browse the SQL result within the Links tab, the result is correct. But when place TotalA into the page header section, the...

Thanks for the response. I determined what the problem was. The servername on my development machine was being stored in the VB.Net embedded report so, when run on the client machine, the servername could not be found and was triggering the Logon prompt. I fixed the problem by changing the...

I am using CR for Visual Studio 2005, for a windows ap, with an unsecured Access DB and when I try to print a report, the Logon prompt pops up. The user name defaults to "Admin" and the password is empty. I try to just press ok without entering a password but no success. I don't get the logon...

I explored using a crosstab but found that in order to as you said ," then place the A,B...H field as the Column, and the value as the summary value." all of my columns types for my summary table needed to exist in the current data- which do not. So I am falling back to my use of a var total...

I have several groups with a title "A", "B",etc up to about "H". In the groupfooter I have a summary field for the numeric field in each group. In the report header I have columns titled "A", "B" up to "H". Under each column heading I want to print the group total in the corresponding...

OK, I have decided to go with 2 subreports in my main report. The main is grouped by account. I set up a shared boolean var for each sub that is true if records appear in the sub. If false, the section with the sub is suppressed. I am using a technique described in a book by Brian Bischof CR...

I think I understand. I plan on implementing your suggestions later today. I really appreciate ALL of your time with my questions, LBass. I'll let you know how it works out Tom

Regarding subreport 2, I'm still a bit unclear how to get the monthly values to total next to the month using the 'print on change of month'. Will the month totals need to be formula fields that filter with a date range? Also, I understand that the main report will not print if both subreports...

Table 1 Account single Name string Address " City " State " Zip integer Table 2 holds the transaction data for water purchases, transfers, or allocations that the account has made or received from the water district itself or from other accounts during the fiscal year. An...

I need to correct myself a bit. Section B is actually derived from the same Table 4 used Section C - not Table 3, so forget about table 3. Tables 2 and 4 are linked by account to table 1. In order to derive the monthly totals in Section 2, I was envisioning CR stepping thru each record in...

Sorry about the surprise. I guess I boiled my report down too much at first. Below is a schematic layout for the report. The report is to be printed for any account in Table 1 that has activity in either Section A or C for the subject week. The table in brackets is the source for the fields in...

Thanks once again LBass. If you have the patience, I have another question regarding the groupheader/detail/groupfooter layout. As you noticed my group#1 will be on the accounts table(Table 1). But my report will have essentially 3 sections in this order. 1 A list of water purchases or other...