Problem with LoadReport web method

Hi,

I'm working on a reporting client for Reporting Services 2005 using SOAP. The problem I'm having is that for reports with multiple pages or a document map, the LoadReport web method, always says they have 0 pages or no document map.

To simplify the problem, i created a simple console app that just calls LoadReport on the /AdventureWorks Sample Reports/Product Catalog report to see if HasDocumentMap is true (it should be but isn't).

Any suggestions?

Kwan

I figured it out and it makes sense. The information is available only after you call Render.

So call, Render, then GetExecutionInfo to get the correct values for HasDocumentMap and NumPages.

Problem with extra pages

I'm having problems with extra pages when doing a page break on a group in a
table. I know this is a problem in SRS 2000, but are there any work-arounds
for this?Try to take out the footer/header of that group so no extra rows are
dislayed. See if that works...

problem with exports in pdf

Hi
I am trying to export the report in pdf file with version 5.0. In pdf file
, it leaves the blank pages in between. At the same time returns half of the
information on one page and continues half on another page. For some data,
it gives acsii characters in the pdf file and when in the designer view ,
the same report looks correct.
This happens intermittently. For some data , the same RDL works fine whereas
for some, it doesnt give the proper formatting.
Please provide the solution and suggestions if any.
Thanks & Cheers,
TruptiTo keep the PDF export from leaving blank pages or having columns on one
page and others continued on the next, make sure the BODY size of the report
is not even 1 pixel more than the PAGE SIZE - (the MARGINS).
--
Adrian M.
MCP
"Trupti" <gettrupti@.hotmail.com> wrote in message
news:Oa9qP57IFHA.3332@.TK2MSFTNGP15.phx.gbl...
> Hi
> I am trying to export the report in pdf file with version 5.0. In pdf
> file , it leaves the blank pages in between. At the same time returns half
> of the information on one page and continues half on another page. For
> some data, it gives acsii characters in the pdf file and when in the
> designer view , the same report looks correct.
> This happens intermittently. For some data , the same RDL works fine
> whereas for some, it doesnt give the proper formatting.
> Please provide the solution and suggestions if any.
> Thanks & Cheers,
> Trupti
>|||Dear Trupti
I am experiencing the same problems - and at least in my case it does not
have anything to do with the definition of the report width.
I have checked my report's and body's width over and over again - everything
is as it should be. And according to the piece of advice Microsoft is dishing
out setting the correct report and body width should do the trick - but it
does not. And it seems as if nobody is really working on solving this problem
because there are no better answers to be found in this newsgroup - and the
problem is known for a long time now!
According to my own experiences, reports with tables do just fine. It is
reports that contain a matrix that have this pdf-problem. We have even
istalled and tested the beta version of SP2, but with no better results. I am
at the end of my rope. I really wish somebody would come up with an
explanation and solution soon!
Greetings to all poor souls out there suffering from the same phenomenon...
"Trupti" wrote:
> Hi
> I am trying to export the report in pdf file with version 5.0. In pdf file
> , it leaves the blank pages in between. At the same time returns half of the
> information on one page and continues half on another page. For some data,
> it gives acsii characters in the pdf file and when in the designer view ,
> the same report looks correct.
> This happens intermittently. For some data , the same RDL works fine whereas
> for some, it doesnt give the proper formatting.
> Please provide the solution and suggestions if any.
> Thanks & Cheers,
> Trupti
>
>|||Send a description of the problem/issue to:
mswish@.microsoft.com
http://www.microsoft.com/mswish
That way you don't just wait for a 'solution' - you can have an active share
in encouraging Microsoft to fix the problem.
--
Adrian M.
MCP
"j schuetz" <jschuetz@.discussions.microsoft.com> wrote in message
news:B16D99CB-D4A7-48A3-9CA0-627B73C94904@.microsoft.com...
> Dear Trupti
> I am experiencing the same problems - and at least in my case it does not
> have anything to do with the definition of the report width.
> I have checked my report's and body's width over and over again -
> everything
> is as it should be. And according to the piece of advice Microsoft is
> dishing
> out setting the correct report and body width should do the trick - but it
> does not. And it seems as if nobody is really working on solving this
> problem
> because there are no better answers to be found in this newsgroup - and
> the
> problem is known for a long time now!
> According to my own experiences, reports with tables do just fine. It is
> reports that contain a matrix that have this pdf-problem. We have even
> istalled and tested the beta version of SP2, but with no better results. I
> am
> at the end of my rope. I really wish somebody would come up with an
> explanation and solution soon!
> Greetings to all poor souls out there suffering from the same
> phenomenon...
>
> "Trupti" wrote:
>> Hi
>> I am trying to export the report in pdf file with version 5.0. In pdf
>> file
>> , it leaves the blank pages in between. At the same time returns half of
>> the
>> information on one page and continues half on another page. For some
>> data,
>> it gives acsii characters in the pdf file and when in the designer view
>> ,
>> the same report looks correct.
>> This happens intermittently. For some data , the same RDL works fine
>> whereas
>> for some, it doesnt give the proper formatting.
>> Please provide the solution and suggestions if any.
>> Thanks & Cheers,
>> Trupti
>>|||I have deposited a detailed documentation with the Microsoft support of my
home country - but up to now nothing has resulted of that either.

Problem with Database: " No value given for one or more required parameters."

I am working on my first project, and using Visual Web Developer 2005, and I am having one heck of a time with one of my pages.

I am making a makeshift shoppingcart program for one of my classes, and I can't get the checkout page to work. All my other pages work just fine, and this is the only one that won't work.

I am hoping someone is able to help me

I am attaching what I think is causing the problem, hopefully someone might see something amiss:

These are my AccessDataSources
<asp:AccessDataSource ID="adsAddNewOrder" runat="server" DataFile="~/App_Data/GoalieStore.mdb" InsertCommand="INSERT INTO Orders(OrderID,CustomerID,SalesTaxRate,Shipping) VALUES (?,?,0.14,25)" SelectCommand="SELECT OrderID, CustomerID FROM Orders"></asp:AccessDataSource>
<asp:AccessDataSource ID="adsAddNewOrderDetails" runat="server" DataFile="~/App_Data/GoalieStore.mdb"
InsertCommand="INSERT INTO OrderDetails(ProductID,OrderID,Quantity) SELECT ProductID,OrderID,Quantity FROM Cart WHERE (CustomerID = ?)"
SelectCommand="SELECT ProductID, OrderID FROM OrderDetails"></asp:AccessDataSource>
<asp:AccessDataSource ID="adsClearCart" runat="server" DataFile="~/App_Data/GoalieStore.mdb"
DeleteCommand="DELETE * FROM Cart WHERE (CustomerID = ?)" SelectCommand="SELECT Cart.* FROM Cart">
</asp:AccessDataSource>

and I have VB.Net code as follows:
Protected Sub ClearCart()
'Create a Delete Query Parameter using a Session variable tag
Dim paramCID As New SessionParameter
paramCID.SessionField = "CustomerID"

adsClearCart.DeleteParameters.Clear() 'clear all existing Delete Query parameters
adsClearCart.DeleteParameters.Add(paramCID) 'add the Session variable Parameter
adsClearCart.Delete() 'run the query
End Sub

Protected Sub btnNewOrder_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim paramCID As New SessionParameter
paramCID.SessionField = "CustomerID"
Dim paramOID As New SessionParameter
paramOID.SessionField = "OrderID"
'add the parameters to the Order table Insert Query and run the Query
adsAddNewOrder.InsertParameters.Clear()
adsAddNewOrder.InsertParameters.Add(paramOID)
adsAddNewOrder.InsertParameters.Add(paramCID)
adsAddNewOrder.Insert()
'add the parameter to the OrderDetails table Insert Query and run the Query
adsAddNewOrderDetails.InsertParameters.Clear()
adsAddNewOrderDetails.InsertParameters.Add(paramCID)
adsAddNewOrderDetails.Insert()
'Clear Cart
ClearCart()
Server.Transfer("confirm.aspx")
End Sub

The user presses a button to confirm there order, and thats when I get the error "No Value given for one or more required parameters."

Hope someone can help!
Thanks,
Greg

As you said that is a problem from confirm.aspx

http://forums.asp.net/thread/1472678.aspx

Thanks