Showing posts with label example. Show all posts
Showing posts with label example. Show all posts

Friday, March 23, 2012

Reporting Services Problem

I have a URL link to a report such as in a html page. Here is a typical example

<a href = "List">http://www.myserver.com/ReportServer?%2fCustomReports%2fOrganization>List of Managers</a>

This works great and renders the report

However after I return to the calling page and perform a POST such as

<form ACTION="http://www.myserver.com/Catch.asp" METHOD="post" name="frm1" id="frm1"
<INPUT id=Var1 name = Var1 type=hidden value="valuetopost">

The variables Var1 are never passed if I do this AFTER linking to the report. It always works if I do this BEFORE calling the report. I can only get this to work again by closing out the html page and starting again

Does anyone have any ideas what is wrong?You should try posting this to SQL Server Reporting Services forum.

reporting services print preview

Why whenever I create a report that is more than 1 page long, do I get a
blank page between every page of my report? In VS for example if I
create a 3 page report, I get a 6 page report and every other page is
blank on the print preview.
How do you prevent this?
Cheers,
Mike
*** Sent via Developersdex http://www.examnotes.net ***Check that your page margins are correct.
If you have overshot your page margins with a table or object then you will
get this.
Immy
"Mike P" <mike.parr@.gmail.com> wrote in message
news:eynAtgDeGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Why whenever I create a report that is more than 1 page long, do I get a
> blank page between every page of my report? In VS for example if I
> create a 3 page report, I get a 6 page report and every other page is
> blank on the print preview.
> How do you prevent this?
>
> Cheers,
> Mike
>
> *** Sent via Developersdex http://www.examnotes.net ***

Reporting services over internet

Is there any example how to make Report available over internet to our
customers?
How to get username and password from customers?
How to connect aspx page and report?Internet deployment is discussed in
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx.
On your last question, please refer to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_intro_7xb6.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"TomislaW" <tomislav147@.hotmail.com> wrote in message
news:%23kb%23D2maEHA.972@.TK2MSFTNGP12.phx.gbl...
> Is there any example how to make Report available over internet to our
> customers?
> How to get username and password from customers?
> How to connect aspx page and report?
>
>

Friday, March 9, 2012

Reporting Services how do I disable a drop down box

Hi,

SQL Server Reporting Services 2005.

I have a tick box that is required to enable or disable two associated drop down boxes.

Example: Tick box has 2 associated drop down boxes. The drop down boxes list details of Area from a database. The Area is linked to Properties. This allows the selection of Properties to be filtering by Area. Ticking the tick box allows the user to select from the drop down boxes.

I have tried setting the Report Parameters in different ways, but without any success.

Please can someone suggest how I can set the two drop down boxes to be disabled when the tick box is unticked and enabled when the check box is ticked?

Thanking you,

dwemh

Hi,

I think enabling or disabling of parameter controls is not possible, since we have limited access to report parameter controls.

You could have cascaded parameters instead. On selection of tick box populate the Area dropdown (by filling the Area dataset with the result of the tick box as input parameter), which in turn populates Properties based on the default Area value.

By tick box do you mean check box, because when I choose a Boolean report parameter type I am getting radio buttons!

Thanks,

JDee