Friday, March 9, 2012

interact with every detail row

Hi;
is there a way to interact with every detail row that is about to print?;
for acumulating values or perform special validations
TIAIf I understand you correctly, you could use ReportItems![fieldname].value.
fieldname would be the name of the textbox(es) you are interested in
interacting with.
"Willo" wrote:
> Hi;
> is there a way to interact with every detail row that is about to print?;
> for acumulating values or perform special validations
> TIA
>
>|||let me try to clarify my problem...
lets say i have table1 with accounts
--
TABLE1
accountid balance
1 10000
2 20000
and table2 with debits and credits
--
TABLE2
accountid debit credit
1 450
1 300
1 50
2 1000
2 3450
and table3 with account names
--
TABLE3
accountid accountname accountnumber
1 AAAAAAAA 3243223432
2 BBBBBBBBB 9832798273
i need an output like this
---
account
3243223432 AAAAAAAAA initial balance debit credit
final balance
10000
450 10450
10450
300 10150
10150
50 10100
account
9832798273 BBBBBBBBB initial balance debit credit
final balance
20000 1000
21000
21000
3450 17550
"honus" <honus@.discussions.microsoft.com> wrote in message
news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
> If I understand you correctly, you could use
> ReportItems![fieldname].value.
> fieldname would be the name of the textbox(es) you are interested in
> interacting with.
> "Willo" wrote:
>> Hi;
>> is there a way to interact with every detail row that is about to print?;
>> for acumulating values or perform special validations
>> TIA
>>|||using a conditional statement and ReportItems! should work out for you. Name
your textboxes in tables 1 and 2 for easier referencing.
Or change your SQL to do this for you, which would probably be the easiest
way.
--
I am living proof that 95% of programmers are idiots.
"Willo" wrote:
> let me try to clarify my problem...
> lets say i have table1 with accounts
> --
> TABLE1
> accountid balance
> 1 10000
> 2 20000
> and table2 with debits and credits
> --
> TABLE2
> accountid debit credit
> 1 450
> 1 300
> 1 50
> 2 1000
> 2 3450
> and table3 with account names
> --
> TABLE3
> accountid accountname accountnumber
> 1 AAAAAAAA 3243223432
> 2 BBBBBBBBB 9832798273
>
> i need an output like this
> ---
> account
> 3243223432 AAAAAAAAA initial balance debit credit
> final balance
> 10000
> 450 10450
> 10450
> 300 10150
> 10150
> 50 10100
> account
> 9832798273 BBBBBBBBB initial balance debit credit
> final balance
> 20000 1000
> 21000
> 21000
> 3450 17550
>
>
>
>
> "honus" <honus@.discussions.microsoft.com> wrote in message
> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
> > If I understand you correctly, you could use
> > ReportItems![fieldname].value.
> > fieldname would be the name of the textbox(es) you are interested in
> > interacting with.
> >
> > "Willo" wrote:
> >
> >> Hi;
> >>
> >> is there a way to interact with every detail row that is about to print?;
> >> for acumulating values or perform special validations
> >>
> >> TIA
> >>
> >>
> >>
>
>|||im trying to do it in sql but i think i cant be done on a single SELECT
statment.
On RS, all i need is to define a variable, initializing it with INITIAL
BALANCE for each account, suming each debit and subtrating each credit and
print th FINAL BALANCE for each record.
It is a simple task on most of other report tools, but i dont know how to do
it on RS... im very frustrated with this tool!
"honus" <honus@.discussions.microsoft.com> wrote in message
news:36EE88E4-29A6-44CD-AAB0-0642DC7B0958@.microsoft.com...
> using a conditional statement and ReportItems! should work out for you.
> Name
> your textboxes in tables 1 and 2 for easier referencing.
> Or change your SQL to do this for you, which would probably be the easiest
> way.
> --
> I am living proof that 95% of programmers are idiots.
>
> "Willo" wrote:
>> let me try to clarify my problem...
>> lets say i have table1 with accounts
>> --
>> TABLE1
>> accountid balance
>> 1 10000
>> 2 20000
>> and table2 with debits and credits
>> --
>> TABLE2
>> accountid debit credit
>> 1 450
>> 1 300
>> 1 50
>> 2 1000
>> 2 3450
>> and table3 with account names
>> --
>> TABLE3
>> accountid accountname accountnumber
>> 1 AAAAAAAA 3243223432
>> 2 BBBBBBBBB 9832798273
>>
>> i need an output like this
>> ---
>> account
>> 3243223432 AAAAAAAAA initial balance debit credit
>> final balance
>> 10000
>> 450 10450
>> 10450
>> 300 10150
>> 10150
>> 50 10100
>> account
>> 9832798273 BBBBBBBBB initial balance debit credit
>> final balance
>> 20000
>> 1000
>> 21000
>> 21000
>> 3450 17550
>>
>>
>>
>>
>> "honus" <honus@.discussions.microsoft.com> wrote in message
>> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
>> > If I understand you correctly, you could use
>> > ReportItems![fieldname].value.
>> > fieldname would be the name of the textbox(es) you are interested in
>> > interacting with.
>> >
>> > "Willo" wrote:
>> >
>> >> Hi;
>> >>
>> >> is there a way to interact with every detail row that is about to
>> >> print?;
>> >> for acumulating values or perform special validations
>> >>
>> >> TIA
>> >>
>> >>
>> >>
>>|||Why not it can be done using sql, I created your 3 tables and wrote a query
to retrieve the final balance as well using calculated field.
Amarnath, MCTS
"Willo" wrote:
> im trying to do it in sql but i think i cant be done on a single SELECT
> statment.
> On RS, all i need is to define a variable, initializing it with INITIAL
> BALANCE for each account, suming each debit and subtrating each credit and
> print th FINAL BALANCE for each record.
> It is a simple task on most of other report tools, but i dont know how to do
> it on RS... im very frustrated with this tool!
>
>
> "honus" <honus@.discussions.microsoft.com> wrote in message
> news:36EE88E4-29A6-44CD-AAB0-0642DC7B0958@.microsoft.com...
> > using a conditional statement and ReportItems! should work out for you.
> > Name
> > your textboxes in tables 1 and 2 for easier referencing.
> >
> > Or change your SQL to do this for you, which would probably be the easiest
> > way.
> > --
> > I am living proof that 95% of programmers are idiots.
> >
> >
> > "Willo" wrote:
> >
> >> let me try to clarify my problem...
> >>
> >> lets say i have table1 with accounts
> >> --
> >> TABLE1
> >> accountid balance
> >> 1 10000
> >> 2 20000
> >>
> >> and table2 with debits and credits
> >> --
> >> TABLE2
> >> accountid debit credit
> >> 1 450
> >> 1 300
> >> 1 50
> >> 2 1000
> >> 2 3450
> >>
> >> and table3 with account names
> >> --
> >> TABLE3
> >> accountid accountname accountnumber
> >> 1 AAAAAAAA 3243223432
> >> 2 BBBBBBBBB 9832798273
> >>
> >>
> >> i need an output like this
> >> ---
> >> account
> >> 3243223432 AAAAAAAAA initial balance debit credit
> >> final balance
> >> 10000
> >> 450 10450
> >> 10450
> >> 300 10150
> >> 10150
> >> 50 10100
> >>
> >> account
> >> 9832798273 BBBBBBBBB initial balance debit credit
> >> final balance
> >> 20000
> >> 1000
> >> 21000
> >> 21000
> >> 3450 17550
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> "honus" <honus@.discussions.microsoft.com> wrote in message
> >> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
> >> > If I understand you correctly, you could use
> >> > ReportItems![fieldname].value.
> >> > fieldname would be the name of the textbox(es) you are interested in
> >> > interacting with.
> >> >
> >> > "Willo" wrote:
> >> >
> >> >> Hi;
> >> >>
> >> >> is there a way to interact with every detail row that is about to
> >> >> print?;
> >> >> for acumulating values or perform special validations
> >> >>
> >> >> TIA
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||maybe im just plain idiot, could you show me how you did it?
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:B8EA7478-B492-4D96-B1D5-73F24693268A@.microsoft.com...
> Why not it can be done using sql, I created your 3 tables and wrote a
> query
> to retrieve the final balance as well using calculated field.
> Amarnath, MCTS
> "Willo" wrote:
>> im trying to do it in sql but i think i cant be done on a single SELECT
>> statment.
>> On RS, all i need is to define a variable, initializing it with INITIAL
>> BALANCE for each account, suming each debit and subtrating each credit
>> and
>> print th FINAL BALANCE for each record.
>> It is a simple task on most of other report tools, but i dont know how to
>> do
>> it on RS... im very frustrated with this tool!
>>
>>
>> "honus" <honus@.discussions.microsoft.com> wrote in message
>> news:36EE88E4-29A6-44CD-AAB0-0642DC7B0958@.microsoft.com...
>> > using a conditional statement and ReportItems! should work out for you.
>> > Name
>> > your textboxes in tables 1 and 2 for easier referencing.
>> >
>> > Or change your SQL to do this for you, which would probably be the
>> > easiest
>> > way.
>> > --
>> > I am living proof that 95% of programmers are idiots.
>> >
>> >
>> > "Willo" wrote:
>> >
>> >> let me try to clarify my problem...
>> >>
>> >> lets say i have table1 with accounts
>> >> --
>> >> TABLE1
>> >> accountid balance
>> >> 1 10000
>> >> 2 20000
>> >>
>> >> and table2 with debits and credits
>> >> --
>> >> TABLE2
>> >> accountid debit credit
>> >> 1 450
>> >> 1 300
>> >> 1 50
>> >> 2 1000
>> >> 2 3450
>> >>
>> >> and table3 with account names
>> >> --
>> >> TABLE3
>> >> accountid accountname accountnumber
>> >> 1 AAAAAAAA 3243223432
>> >> 2 BBBBBBBBB 9832798273
>> >>
>> >>
>> >> i need an output like this
>> >> ---
>> >> account
>> >> 3243223432 AAAAAAAAA initial balance debit credit
>> >> final balance
>> >> 10000
>> >> 450 10450
>> >> 10450
>> >> 300 10150
>> >> 10150
>> >> 50 10100
>> >>
>> >> account
>> >> 9832798273 BBBBBBBBB initial balance debit credit
>> >> final balance
>> >> 20000
>> >> 1000
>> >> 21000
>> >> 21000
>> >> 3450 17550
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> "honus" <honus@.discussions.microsoft.com> wrote in message
>> >> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
>> >> > If I understand you correctly, you could use
>> >> > ReportItems![fieldname].value.
>> >> > fieldname would be the name of the textbox(es) you are interested in
>> >> > interacting with.
>> >> >
>> >> > "Willo" wrote:
>> >> >
>> >> >> Hi;
>> >> >>
>> >> >> is there a way to interact with every detail row that is about to
>> >> >> print?;
>> >> >> for acumulating values or perform special validations
>> >> >>
>> >> >> TIA
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||hey it is pretty simple, fortunately you have exact link between tables. So
join them and create a query by selecting the required columns and a
calculated column of (balance +debit - credit) will give you Final balance.
If this is what you want, do it and let me know whether it works.
Amarnath, MCTS
"Willo" wrote:
> maybe im just plain idiot, could you show me how you did it?
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:B8EA7478-B492-4D96-B1D5-73F24693268A@.microsoft.com...
> > Why not it can be done using sql, I created your 3 tables and wrote a
> > query
> > to retrieve the final balance as well using calculated field.
> >
> > Amarnath, MCTS
> >
> > "Willo" wrote:
> >
> >> im trying to do it in sql but i think i cant be done on a single SELECT
> >> statment.
> >>
> >> On RS, all i need is to define a variable, initializing it with INITIAL
> >> BALANCE for each account, suming each debit and subtrating each credit
> >> and
> >> print th FINAL BALANCE for each record.
> >>
> >> It is a simple task on most of other report tools, but i dont know how to
> >> do
> >> it on RS... im very frustrated with this tool!
> >>
> >>
> >>
> >>
> >> "honus" <honus@.discussions.microsoft.com> wrote in message
> >> news:36EE88E4-29A6-44CD-AAB0-0642DC7B0958@.microsoft.com...
> >> > using a conditional statement and ReportItems! should work out for you.
> >> > Name
> >> > your textboxes in tables 1 and 2 for easier referencing.
> >> >
> >> > Or change your SQL to do this for you, which would probably be the
> >> > easiest
> >> > way.
> >> > --
> >> > I am living proof that 95% of programmers are idiots.
> >> >
> >> >
> >> > "Willo" wrote:
> >> >
> >> >> let me try to clarify my problem...
> >> >>
> >> >> lets say i have table1 with accounts
> >> >> --
> >> >> TABLE1
> >> >> accountid balance
> >> >> 1 10000
> >> >> 2 20000
> >> >>
> >> >> and table2 with debits and credits
> >> >> --
> >> >> TABLE2
> >> >> accountid debit credit
> >> >> 1 450
> >> >> 1 300
> >> >> 1 50
> >> >> 2 1000
> >> >> 2 3450
> >> >>
> >> >> and table3 with account names
> >> >> --
> >> >> TABLE3
> >> >> accountid accountname accountnumber
> >> >> 1 AAAAAAAA 3243223432
> >> >> 2 BBBBBBBBB 9832798273
> >> >>
> >> >>
> >> >> i need an output like this
> >> >> ---
> >> >> account
> >> >> 3243223432 AAAAAAAAA initial balance debit credit
> >> >> final balance
> >> >> 10000
> >> >> 450 10450
> >> >> 10450
> >> >> 300 10150
> >> >> 10150
> >> >> 50 10100
> >> >>
> >> >> account
> >> >> 9832798273 BBBBBBBBB initial balance debit credit
> >> >> final balance
> >> >> 20000
> >> >> 1000
> >> >> 21000
> >> >> 21000
> >> >> 3450 17550
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "honus" <honus@.discussions.microsoft.com> wrote in message
> >> >> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
> >> >> > If I understand you correctly, you could use
> >> >> > ReportItems![fieldname].value.
> >> >> > fieldname would be the name of the textbox(es) you are interested in
> >> >> > interacting with.
> >> >> >
> >> >> > "Willo" wrote:
> >> >> >
> >> >> >> Hi;
> >> >> >>
> >> >> >> is there a way to interact with every detail row that is about to
> >> >> >> print?;
> >> >> >> for acumulating values or perform special validations
> >> >> >>
> >> >> >> TIA
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

No comments:

Post a Comment