Internal Architecture of MDF file

--I just created a new datbase. Added one row to the table and an index.
--Looking at the mdf file using a hex editor surprised me.
create database mydb1
go
use mydb1
go
create table table1 (a char(10), b char(10))
go
insert into table1 values ('firstTest','23571113') --primes 2-13 if you care.
--Stop here..Shut down sql and view the mdf file with a hex editor (hackman)
--Search for string 23571113. You will find one (1). Only one.
--Start sql
use mydb1
go
create index idx1 on table1(b)
--Stop here..Shut down sql and view the mdf file with a hex editor (hackman)
--Search for string 23571113. You will find THREE (3). Why?
--Serious replies only please.
/Bob
Bob,
You don't need a hex editor; you use use DBCC PAGE to view the page
structures without going to all of this trouble. Syntax here:
http://www.sql-server-performance.co...ented_dbcc.asp
If you're really interested in this stuff, you should get a copy of Kalen
Delaney's _Inside SQL Server 2000_, which describes the structures in great
detail.
"Bob" <utefan001@.gmail.com> wrote in message
news:40692455.0409281803.4ce67381@.posting.google.c om...
> --I just created a new datbase. Added one row to the table and an index.
> --Looking at the mdf file using a hex editor surprised me.
> create database mydb1
> go
> use mydb1
> go
> create table table1 (a char(10), b char(10))
> go
> insert into table1 values ('firstTest','23571113') --primes 2-13 if you
care.
> --Stop here..Shut down sql and view the mdf file with a hex editor
(hackman)
> --Search for string 23571113. You will find one (1). Only one.
> --Start sql
> use mydb1
> go
> create index idx1 on table1(b)
> --Stop here..Shut down sql and view the mdf file with a hex editor
(hackman)
> --Search for string 23571113. You will find THREE (3). Why?
> --Serious replies only please.
> /Bob
|||See
http://www.nigelrivett.net/PageStructure.html
"Bob" wrote:

> --I just created a new datbase. Added one row to the table and an index.
> --Looking at the mdf file using a hex editor surprised me.
> create database mydb1
> go
> use mydb1
> go
> create table table1 (a char(10), b char(10))
> go
> insert into table1 values ('firstTest','23571113') --primes 2-13 if you care.
> --Stop here..Shut down sql and view the mdf file with a hex editor (hackman)
> --Search for string 23571113. You will find one (1). Only one.
> --Start sql
> use mydb1
> go
> create index idx1 on table1(b)
> --Stop here..Shut down sql and view the mdf file with a hex editor (hackman)
> --Search for string 23571113. You will find THREE (3). Why?
> --Serious replies only please.
> /Bob
>
|||Maybe its got to do with additional pointers in the index ?
Dylan
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#kbGikcpEHA.1668@.TK2MSFTNGP14.phx.gbl...
> Bob,
> You don't need a hex editor; you use use DBCC PAGE to view the page
> structures without going to all of this trouble. Syntax here:
>
http://www.sql-server-performance.co...ented_dbcc.asp
> If you're really interested in this stuff, you should get a copy of Kalen
> Delaney's _Inside SQL Server 2000_, which describes the structures in
great
> detail.
>
> "Bob" <utefan001@.gmail.com> wrote in message
> news:40692455.0409281803.4ce67381@.posting.google.c om...
> care.
> (hackman)
> (hackman)
>

Internal Architecture of MDF file

--I just created a new datbase. Added one row to the table and an index.
--Looking at the mdf file using a hex editor surprised me.
create database mydb1
go
use mydb1
go
create table table1 (a char(10), b char(10))
go
insert into table1 values ('firstTest','23571113') --primes 2-13 if you care.
--Stop here..Shut down sql and view the mdf file with a hex editor (hackman)
--Search for string 23571113. You will find one (1). Only one.
--Start sql
use mydb1
go
create index idx1 on table1(b)
--Stop here..Shut down sql and view the mdf file with a hex editor (hackman)
--Search for string 23571113. You will find THREE (3). Why'
--Serious replies only please.
/BobBob,
You don't need a hex editor; you use use DBCC PAGE to view the page
structures without going to all of this trouble. Syntax here:
http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp
If you're really interested in this stuff, you should get a copy of Kalen
Delaney's _Inside SQL Server 2000_, which describes the structures in great
detail.
"Bob" <utefan001@.gmail.com> wrote in message
news:40692455.0409281803.4ce67381@.posting.google.com...
> --I just created a new datbase. Added one row to the table and an index.
> --Looking at the mdf file using a hex editor surprised me.
> create database mydb1
> go
> use mydb1
> go
> create table table1 (a char(10), b char(10))
> go
> insert into table1 values ('firstTest','23571113') --primes 2-13 if you
care.
> --Stop here..Shut down sql and view the mdf file with a hex editor
(hackman)
> --Search for string 23571113. You will find one (1). Only one.
> --Start sql
> use mydb1
> go
> create index idx1 on table1(b)
> --Stop here..Shut down sql and view the mdf file with a hex editor
(hackman)
> --Search for string 23571113. You will find THREE (3). Why'
> --Serious replies only please.
> /Bob|||See
http://www.nigelrivett.net/PageStructure.html
"Bob" wrote:
> --I just created a new datbase. Added one row to the table and an index.
> --Looking at the mdf file using a hex editor surprised me.
> create database mydb1
> go
> use mydb1
> go
> create table table1 (a char(10), b char(10))
> go
> insert into table1 values ('firstTest','23571113') --primes 2-13 if you care.
> --Stop here..Shut down sql and view the mdf file with a hex editor (hackman)
> --Search for string 23571113. You will find one (1). Only one.
> --Start sql
> use mydb1
> go
> create index idx1 on table1(b)
> --Stop here..Shut down sql and view the mdf file with a hex editor (hackman)
> --Search for string 23571113. You will find THREE (3). Why'
> --Serious replies only please.
> /Bob
>|||Maybe its got to do with additional pointers in the index ?
Dylan
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:#kbGikcpEHA.1668@.TK2MSFTNGP14.phx.gbl...
> Bob,
> You don't need a hex editor; you use use DBCC PAGE to view the page
> structures without going to all of this trouble. Syntax here:
>
http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp
> If you're really interested in this stuff, you should get a copy of Kalen
> Delaney's _Inside SQL Server 2000_, which describes the structures in
great
> detail.
>
> "Bob" <utefan001@.gmail.com> wrote in message
> news:40692455.0409281803.4ce67381@.posting.google.com...
> > --I just created a new datbase. Added one row to the table and an index.
> > --Looking at the mdf file using a hex editor surprised me.
> > create database mydb1
> > go
> > use mydb1
> > go
> > create table table1 (a char(10), b char(10))
> > go
> > insert into table1 values ('firstTest','23571113') --primes 2-13 if you
> care.
> > --Stop here..Shut down sql and view the mdf file with a hex editor
> (hackman)
> > --Search for string 23571113. You will find one (1). Only one.
> > --Start sql
> >
> > use mydb1
> > go
> > create index idx1 on table1(b)
> > --Stop here..Shut down sql and view the mdf file with a hex editor
> (hackman)
> > --Search for string 23571113. You will find THREE (3). Why'
> > --Serious replies only please.
> > /Bob
>sql

Interesting isNumeric result

Does anyone else get the following result when running this query?

Select isnumeric('4D7')

--

1

(1 row(s) affected)

Does anyone know why this would return true for numeric?

Thanks,

Ray

That is another representation of 4.0E+7 -or 40000000.0, and is, therefore, a valid numeric.

You may find this article useful.

isnumeric -What is wrong?
http://www.aspfaq.com/show.asp?id=2390

|||Yeah, IsNumeric is pretty horrible. Vote here for a change https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=177308

Interactive sort, forcing a row to remain at the end still cant get it to work

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

d

e

a

b

c

Sort would return

a

b

d

e

c

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

c

a

b

d

e

Thanks in advance

Dave

|||Anyone?

Interactive sort, forcing a row to remain at the end

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

d

e

a

b

c

Sort would return

a

b

d

e

c

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

c

a

b

d

e

Thanks in advance

Dave

|||Anyone?

Interactive sort, forcing a row to remain at the end

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

d

e

a

b

c

Sort would return

a

b

d

e

c

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

c

a

b

d

e

Thanks in advance

Dave

|||Anyone?

Interactive Sort in Matrix

Hi,

I making a report using Matrix with 2 row groups and 1 column group. The group names are:

Row : CompanyName, TotalUsers

Column: UserType

Detail Group has a count of number of user in each type.

I want to use interactive sort feature on my column group so that when I click on my column header, it sort my detail group data ascending or decending and companyName and total users based on datail group.

Thanks a lot,

-Rohit

I tried different options for the scope but non of them works. Does any one know how to do this?

Thanks.

Interactive Sort in Matrix

I have a Matrix in a report - created like below. Each row has a different dataset and I need to make each Column to be sortable so they can click on the column header say "Summary of Accounts" and sort them and do that for each column header. So far I havent seen anything that looks promising that can do this. Is there away this can be done?

6 Columns and 14 Rows

--headers

Summary of Accounts No debts origBal AccrInter PaidDate CurrBal

Activity count() Sum() Sum() First() Sum()

phase count() Sum() Sum() First() Sum()

attorney etc etc

collection

not inititated

resolved

interrupted

cancel

closed

revised

letter service

Totals:

The combination of Interactive Sort and Matrix are not good! I managed to get it working but only for row groups.|||I know they are not how about how did you do the row groups? If they can sort by row then fine that is good enough for me then!

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
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>