Report Designer: Refreshing Fields VERY Slow

I have a query that uses temp tables, and the query seems to execute and
refresh fields fine, but as soon as I put in a parameter for a DateTime field
the query will run but the Refresh Fields button takes forever...like 2
hours! I think it is running my rather lengthy query without the parameters
which because of the size of the tables takes a long time.
I have tried changing the data type for the parameter from String to
DateTime and neither seem to refresh the fields quickly.
Can anything be done to refresh the fields list quicker?I thought my MSDN Universal Subscription entitled me to a response within two
days... I guess not.
"Chance" wrote:
> I have a query that uses temp tables, and the query seems to execute and
> refresh fields fine, but as soon as I put in a parameter for a DateTime field
> the query will run but the Refresh Fields button takes forever...like 2
> hours! I think it is running my rather lengthy query without the parameters
> which because of the size of the tables takes a long time.
> I have tried changing the data type for the parameter from String to
> DateTime and neither seem to refresh the fields quickly.
> Can anything be done to refresh the fields list quicker?
>

Report Designer: preview goes into infinite loop

Hello,
Situation:
- a report with cascading parameters [A], [B], [C]
- first parameter [A] loaded via non-queried values
- second parameter [B] loaded via stored procedure, taking [A] and a
constant as input (via dataset dsB)
- third parameter [C] loaded via the same stored procedure, taking [A] and
[B] as input (via dataset dsC)
When I preview this report:
- initial view ok
- modify [A] -> [B] changes accordingly
- modify [B] -> the designer starts flickering and goes into a never ending
loop.
The deployed report works just fine and as expected.
Bug ? Any work arounds ?
Thanks for any input!
TomSounds like a bug. There is another bug I have found with the preview tab
and cascading parameters. It only cascades once. I.e. if you go back a
second time and change A it does not change B. Again, deploy works fine. I
have access to the the internal bug reporting tool and when I report the
previous but I'll do this one too. I am not aware of any workaround. At
least it works in deployed mode.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tom VdP" <unick@.hot_mail_.c-o-m> wrote in message
news:1FBF14D5-28E3-4B76-93BF-47F292BC33FE@.microsoft.com...
> Hello,
> Situation:
> - a report with cascading parameters [A], [B], [C]
> - first parameter [A] loaded via non-queried values
> - second parameter [B] loaded via stored procedure, taking [A] and a
> constant as input (via dataset dsB)
> - third parameter [C] loaded via the same stored procedure, taking [A] and
> [B] as input (via dataset dsC)
> When I preview this report:
> - initial view ok
> - modify [A] -> [B] changes accordingly
> - modify [B] -> the designer starts flickering and goes into a never
ending
> loop.
> The deployed report works just fine and as expected.
> Bug ? Any work arounds ?
> Thanks for any input!
> Tom|||Thanks for reporting it.
It is annoying as the first parameter in our reports is the choice of
language. Depending on the selection the contents of the other dropdown
boxes is changed.
So we have cascading parameters in every report.
But we can use the deployed reports luckily.
Regards,
Tom
"Bruce L-C [MVP]" wrote:
> Sounds like a bug. There is another bug I have found with the preview tab
> and cascading parameters. It only cascades once. I.e. if you go back a
> second time and change A it does not change B. Again, deploy works fine. I
> have access to the the internal bug reporting tool and when I report the
> previous but I'll do this one too. I am not aware of any workaround. At
> least it works in deployed mode.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Tom VdP" <unick@.hot_mail_.c-o-m> wrote in message
> news:1FBF14D5-28E3-4B76-93BF-47F292BC33FE@.microsoft.com...
> >
> > Hello,
> >
> > Situation:
> > - a report with cascading parameters [A], [B], [C]
> > - first parameter [A] loaded via non-queried values
> > - second parameter [B] loaded via stored procedure, taking [A] and a
> > constant as input (via dataset dsB)
> > - third parameter [C] loaded via the same stored procedure, taking [A] and
> > [B] as input (via dataset dsC)
> >
> > When I preview this report:
> > - initial view ok
> > - modify [A] -> [B] changes accordingly
> > - modify [B] -> the designer starts flickering and goes into a never
> ending
> > loop.
> >
> > The deployed report works just fine and as expected.
> >
> > Bug ? Any work arounds ?
> >
> > Thanks for any input!
> > Tom
>
>|||I am not using cascading parameters but I have experieced a similiar problems
with the Report Designer preview (loops) and I sometimes get a Processing
Error 'Specified Cast in not Valid' , If I remove the Page Header OR Footer I
do not get the error, OR if there is labels only (no ReportItems! or Globals!
in the header/footer) it works.
There are no problems when the report is deployed.
"Tom VdP" wrote:
> Thanks for reporting it.
> It is annoying as the first parameter in our reports is the choice of
> language. Depending on the selection the contents of the other dropdown
> boxes is changed.
> So we have cascading parameters in every report.
> But we can use the deployed reports luckily.
> Regards,
> Tom
>
> "Bruce L-C [MVP]" wrote:
> > Sounds like a bug. There is another bug I have found with the preview tab
> > and cascading parameters. It only cascades once. I.e. if you go back a
> > second time and change A it does not change B. Again, deploy works fine. I
> > have access to the the internal bug reporting tool and when I report the
> > previous but I'll do this one too. I am not aware of any workaround. At
> > least it works in deployed mode.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Tom VdP" <unick@.hot_mail_.c-o-m> wrote in message
> > news:1FBF14D5-28E3-4B76-93BF-47F292BC33FE@.microsoft.com...
> > >
> > > Hello,
> > >
> > > Situation:
> > > - a report with cascading parameters [A], [B], [C]
> > > - first parameter [A] loaded via non-queried values
> > > - second parameter [B] loaded via stored procedure, taking [A] and a
> > > constant as input (via dataset dsB)
> > > - third parameter [C] loaded via the same stored procedure, taking [A] and
> > > [B] as input (via dataset dsC)
> > >
> > > When I preview this report:
> > > - initial view ok
> > > - modify [A] -> [B] changes accordingly
> > > - modify [B] -> the designer starts flickering and goes into a never
> > ending
> > > loop.
> > >
> > > The deployed report works just fine and as expected.
> > >
> > > Bug ? Any work arounds ?
> > >
> > > Thanks for any input!
> > > Tom
> >
> >
> >

Report designer

In a RD, i have 2 dataset, one of them consist of two field (id and name) by which the name will be shown as a parameter. When a user select from the combo box, how do I enable the id of the this dataset to be link up as a 'parameter' to another dataset which is a query to retrieve the result?

In another words instead of using the parameter 'name' i would like to implicitly link up the id instead of the name which is shown to the user.

Thanks.

Regards

Alu

In Report Parameters, you set the

Value Field to be ID

and the

Label Field to be Name

A bit like this

<Prompt>Select Hierarchy Group</Prompt>

<ValidValues>

<DataSetReference>

<DataSetName>H_Groups</DataSetName>

<ValueField>id</ValueField>

<LabelField>List</LabelField>

</DataSetReference>

</ValidValues>

Where id is the parameter passed to the query & List is the values displayed for the user to choose from in the Listbox

|||

thanks!

Regards

Alu

sql

Report Delivery problem with Data Driven Subscription

I created a data driven subscription for a report that will email a copy of the report based on a parameter passed from a table. The report runs successfully as indicated in Report Manager but the email is not delivered. I checked the ReportServerService log file and a message states that the report was sent to the proper email address. There is another log, ReportServerWebApp, that shows the message "The extension Report Server Email does not have a LocalizedNameAttribute" .

I created a regular subscription and it emails the report successfully so it can't be the SMTP server.

Any ideas how I can fix this problem with the Data Driven Subscription? Thank you.

David

I did some further checking. If I send off a second job, it delivers the emailed reports. However, the problem persists with the second job.That is, Reporting Services indicates that the job ran successfully and delivered the reports, but some of the reports are getting stuck in a queue somewhere between the reporting server, the remote SMTP server and Microsoft Exchange.

Is there anyone else having problems with Reporting Services reports not getting fully delivered by a remote SMTP server? Would using a local SMTP server fix the problem?

David

|||Sorry for the delay with replying this. From the SSRS prospective your data driven subscription has been delivered to SMTP server successfully. Then SMTP server failed to deliver e-mal. Any chance that e-mail TO address is build off a data-driven subscription query results and is incorrect? Per every successfully sent e-mail SSRS will write into the service logfile ReportServerService__<Date>.log a line: Email successfully sent to {0}. Can you double check that TO addresses are correct for the cases that you thin are failing?|||

All of the reports are being sent to the same email address. Some get there successfully, others don't make it out of the queue.

David

|||

Then it really looks like a problem with SMTP server. It’s likely not related to SSRS.

-Igor

Report Delivery problem with Data Driven Subscription

I created a data driven subscription for a report that will email a copy of the report based on a parameter passed from a table. The report runs successfully as indicated in Report Manager but the email is not delivered. I checked the ReportServerService log file and a message states that the report was sent to the proper email address. There is another log, ReportServerWebApp, that shows the message "The extension Report Server Email does not have a LocalizedNameAttribute" .

I created a regular subscription and it emails the report successfully so it can't be the SMTP server.

Any ideas how I can fix this problem with the Data Driven Subscription? Thank you.

David

I did some further checking. If I send off a second job, it delivers the emailed reports. However, the problem persists with the second job.That is, Reporting Services indicates that the job ran successfully and delivered the reports, but some of the reports are getting stuck in a queue somewhere between the reporting server, the remote SMTP server and Microsoft Exchange.

Is there anyone else having problems with Reporting Services reports not getting fully delivered by a remote SMTP server? Would using a local SMTP server fix the problem?

David

|||Sorry for the delay with replying this. From the SSRS prospective your data driven subscription has been delivered to SMTP server successfully. Then SMTP server failed to deliver e-mal. Any chance that e-mail TO address is build off a data-driven subscription query results and is incorrect? Per every successfully sent e-mail SSRS will write into the service logfile ReportServerService__<Date>.log a line: Email successfully sent to {0}. Can you double check that TO addresses are correct for the cases that you thin are failing?|||

All of the reports are being sent to the same email address. Some get there successfully, others don't make it out of the queue.

David

|||

Then it really looks like a problem with SMTP server. It’s likely not related to SSRS.

-Igor

report by multiple parameter with OR relationship

I am trying to create a report with three parameters (date, license number and application number). I want report by License Number or Application number in the date that I put in. I trying following in Record Selection:
1.
{Command.LICENSE_NO} = {?License Number} or
{Command.LICENSE_ID} = {?Application Number}

2.
if isnull({?License Number}) = false then
{Command.LICENSE_NO} = {?License Number};
if isnull({?Application Number})=false then
{Command.LICENSE_ID}={?Application Number};

** license_id is the application number(number). license number(string)

but both of them do not work. somehow I can not leave Application number empty.

Please Help!!!As Application Number is a number, Crystal wants you to specify one.
If you default it to 0 you could have a selection formula like

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

which means that if you supply a non-zero application number it will be used in preference to any licence id you provide.|||As Application Number is a number, Crystal wants you to specify one.
If you default it to 0 you could have a selection formula like

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

which means that if you supply a non-zero application number it will be used in preference to any licence id you provide.

I have tried using 0 as default, but for some reason. I still can not leave application number empty. I used exactly same as your code

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

but search will not start if I leave application parameter empty.

any thought?

Thanks for your help|||As Application Number is a number, Crystal wants you to specify one.
If you default it to 0 you could have a selection formula like

({?Application Number} = 0 and {Command.LICENSE_NO} = {?License Number})
or
({?Application Number} <> 0 and {Command.LICENSE_ID} = {?Application Number})

which means that if you supply a non-zero application number it will be used in preference to any licence id you provide.

Got it working with your code!!!

Thanks your so much!!

Report Builder Parameter List empty

After building a report in report builder, I've set on of the filters to prompt for user input "in this list". When I run the report I get a drop down list with nothing in it. I can manually type in a value an run the report but I'd like to be able to select the parameter from the list.

I've also tried clicking on (no values selected) and selected all the available values...however this gives me the same results.

I also have the same problem...and have been searching for an answer...

I know we fixed this or had a solution for this last year...and it may have something to do with the existing cardinalities in the Roles in the model...

But I'm still looking and trying to find a definite answer....

Report Builder Parameter Dependency

Dear Anyone,

Is it possible in report builder that for a report parameter to have a dependency on another report parameter?

Example:

Parameter 1: Country

Parameter 2: City

The selects a country called Philippines. When the user tries to select the specific city, only the cities that are under the selected country will be displayed.

Thanks,

Joseph

No, this is not possible in Report Builder parameters. You would need to import the report into Report Designer.

Report Builder filter dropdown list issues

How can I create a report in Report Builder with a date-type parameter that displays a dropdown list of month names displayed in the correct chronological order (i.e. January, February, etc.)? More generally, how does one sort filter values in the dropdown list?

On a related note, how do I get Report Builder to display (in the report) which values were selected from the dropdown list? Currently I get:

Filter: Transactions with: All of (Month = (prompted))

when what I really need is the month name(s) selected from the dropdown list.

Thanks!

Paul.

Paul Rayner wrote:

On a related note, how do I get Report Builder to display (in the report) which values were selected from the dropdown list? Currently I get:

Filter: Transactions with: All of (Month = (prompted))

when what I really need is the month name(s) selected from the dropdown list.
Thanks!
Paul.

Names will appear in dropdown if ValueSelection property of attribute Transaction is set to "Dropdown".

|||

Thanks for the reply. Perhaps I was insufficiently clear. I know how to get a dropdown list. What I don't know how to do is how to sort the date values (when displayed as month names) in a dropdown list. Month names are being displayed as April, August, etc. instead of January, February, etc.

Paul.

Report Builder error.

Hi,

I am facing a peculiar situation where my ad-hoc report is inter-mittently giving me the following error based on the parameter values I am selecting from the dropdown. What could be the possible reasons for this ?

---

Report execution error
The report might not be valid or the server could not process the data.

An existing connection was forcibly closed by the remote host.
-
Unable to read data from the transport connection:An existing connection was forcibly closed by the remote host.
-
The underlying connection was closed: An unexpected error occured on a receive.

---

In the same report if I try to add another runtime filter, the application crashes. This filter field has about 50k available values.Is that the reason for such behaviour? What can be the possible solution here ?

Is this error displayed during execution (preview) of the report or during design-time?

If it is being displayed during design-time, try opening the model in Model Designer and change the element's "Value Selection" property to "None". This will tell Report Builder to use a textbox instead of a dropdown menu for this element.

If this error is during execution (preview) of the report, does it occur when the report is published and executed directly from the server?

HTH, Jason Tremper

|||

Hi !

Sorry for the late response !The error is shown during execution of the ad-hoc report . As I said the above error comes only if I select some particular set of values from the parameter dropdowns.
The other question is that of the filter condition.The application crashes during the design time when I try to apply that filter.This filter probably tries to load all the available values which is about 50k!
I cannot make the 'Value Selection' property to 'None'. The user won't have a clue as to what to enter in the text box.

Report Builder error.

Hi,

I am facing a peculiar situation where my ad-hoc report is inter-mittently giving me the following error based on the parameter values I am selecting from the dropdown. What could be the possible reasons for this ?

---

Report execution error
The report might not be valid or the server could not process the data.

An existing connection was forcibly closed by the remote host.
-
Unable to read data from the transport connection:An existing connection was forcibly closed by the remote host.
-
The underlying connection was closed: An unexpected error occured on a receive.

---

In the same report if I try to add another runtime filter, the application crashes. This filter field has about 50k available values.Is that the reason for such behaviour? What can be the possible solution here ?

Is this error displayed during execution (preview) of the report or during design-time?

If it is being displayed during design-time, try opening the model in Model Designer and change the element's "Value Selection" property to "None". This will tell Report Builder to use a textbox instead of a dropdown menu for this element.

If this error is during execution (preview) of the report, does it occur when the report is published and executed directly from the server?

HTH, Jason Tremper

|||

Hi !

Sorry for the late response !The error is shown during execution of the ad-hoc report . As I said the above error comes only if I select some particular set of values from the parameter dropdowns.
The other question is that of the filter condition.The application crashes during the design time when I try to apply that filter.This filter probably tries to load all the available values which is about 50k!
I cannot make the 'Value Selection' property to 'None'. The user won't have a clue as to what to enter in the text box.

Report Builder and custom security - can I pass credentials as a parameter?

Hello,

I'm analyzing how our company can use security extensions along with the Report Builder. While testing custom security extensions I found that Report Builder is prompting me for the user name/password whenever I launch it from the browser. This is great, but I also need to launch it from the win forms application that already has been authenticated. Can I pass a user name/password as a parameter to the report builder so it does not show login dialog when I launch it from the application?

Thank you,

Leonid.

Hi,

Slightly off topic - we are setting out to do exactly the same thing - a custom security extension to an ADAM instance and with Report Builder access needed as well.

How hard was it to implement the extension? I have been looking here : http://msdn2.microsoft.com/en-us/library/ms152825.aspx. It does not seem so hard, but I am concerned in general about anything new.

Good luck with getting and answer to yoru question.

Mark

|||

I played with a sample code from Microsoft: http://msdn2.microsoft.com/en-us/library/ms160724.aspx, so I didn't write a single line of code.

Configuring is tedious, you should be very careful following all the steps they describe, but other than that - everything works fine. I haven't tried to revert it back, though :)

Leonid

P.S. In the instructions I skipped the following step because they obiously fixed CreateUserStore.sql script to do detect ASP user name automatically and forgot to update the documentation:

"Locate "LocalMachine" towards the end of the script and replace it with your own computer name. For Windows 2003 users, replace LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in IIS 5 compatibility mode). "

|||

Custom security should work with report builder - including the new in-model security

Report builder will always prompt for logon credentials even though you may have been already authenticated to the server - it is due to a limitation of the ClickOnce technology that report builder uses.

Report Builder and custom security - can I pass credentials as a parameter?

Hello,

I'm analyzing how our company can use security extensions along with the Report Builder. While testing custom security extensions I found that Report Builder is prompting me for the user name/password whenever I launch it from the browser. This is great, but I also need to launch it from the win forms application that already has been authenticated. Can I pass a user name/password as a parameter to the report builder so it does not show login dialog when I launch it from the application?

Thank you,

Leonid.

Hi,

Slightly off topic - we are setting out to do exactly the same thing - a custom security extension to an ADAM instance and with Report Builder access needed as well.

How hard was it to implement the extension? I have been looking here : http://msdn2.microsoft.com/en-us/library/ms152825.aspx. It does not seem so hard, but I am concerned in general about anything new.

Good luck with getting and answer to yoru question.

Mark

|||

I played with a sample code from Microsoft: http://msdn2.microsoft.com/en-us/library/ms160724.aspx, so I didn't write a single line of code.

Configuring is tedious, you should be very careful following all the steps they describe, but other than that - everything works fine. I haven't tried to revert it back, though :)

Leonid

P.S. In the instructions I skipped the following step because they obiously fixed CreateUserStore.sql script to do detect ASP user name automatically and forgot to update the documentation:

"Locate "LocalMachine" towards the end of the script and replace it with your own computer name. For Windows 2003 users, replace LocalMachine\ASPNET with NT AUTHORITY\NETWORK SERVICE (except when in IIS 5 compatibility mode). "

|||

Custom security should work with report builder - including the new in-model security

Report builder will always prompt for logon credentials even though you may have been already authenticated to the server - it is due to a limitation of the ClickOnce technology that report builder uses.

Report Builder - parameters

Is there a way to pass a parameter to the report builder?

We are not using impersonation to call the report builder so we don't know who the actual user is. We want to be able to pass the UserID to the report builder so we know who the actual user is supposed to be.

Thanks.

Sorry, currently the only parameters that can be passed to Report Builder are a server path, startup model, startup perspective or startup report.