Interesting Problem/Bug with Logos in the page header

Scenario:

I have a report with a logo in the page header.

This report has 2 parameters: 1) Date 2) Boolean to Show/Hide detail.

When I put in the date and show the report, everything is fine. If I then change the boolean parameter to show or hide the detail, the logo file cannot be found (Displays a red X)

If I export the report like this, the red X is rendered in the export. The logo is not there.

Has anyone else experienced this issue?

Anyone know how to resolve it?

Thanks!

BobP

This is a known bug. The fix will be included in the next release.

Interactive Data and Clickthrough Reports

My reports are not allowing me to "Clickthrough" to more detailed reports.

I want my report to automatically show a detail record when they select some "interactive data" in my reports.

I have read a page on this stuff ( http://msdn2.microsoft.com/en-us/library/ms345252.aspx ) which states:

In Report Builder, a clickthrough report is a report that provides detailed information about the data contained within the main report. A clickthrough report is displayed when the Report Builder user clicks the interactive data that appears in the main report. These reports are automatically generated by the report server. You, as the model designer, determine what is displayed in clickthrough reports by setting the DefaultDetailAttribute and DefaultAggregateAttribute properties that you assign to an entity in the report model.

Hence, within my report model i have created an entity with a number of DefaultDetailAttributes.

I have not created a specific "click through" report as i would be happy to view the automatically generated report that should contain the attributes defined in the "DefaultDetailAttributes" list.

However, when i view the report, no data items are links (or "interactive data" as the msdn article describe them).

Has anyone got any ideas on how to make the report data interactive?

Thanks,

pete

We are not running SQL Server Enterprise edition. Doh.

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