Solved

The report you requested requires further information.

Posted on 2009-07-10
3
1,233 Views
Last Modified: 2012-06-27
I have a crystal report in a vb.net page using the crystal viewer.
this is the code.
it works fine on my local machine
I have the odbc source set on my machine DSN and the IIS server as well

but when I move it up to the server it gives me
The report you requested requires further information.
     and asks me for the password....
any help would be appreciated Thanks

Dim params As New ParameterFields ' tHis requires only one object
 

            Dim dte1Field As New ParameterField ' ParameterField for 1st param

            Dim dte2field As New ParameterField ' param for second param\
 

            Dim dte1Value As New ParameterDiscreteValue 'ParameterDiscreteValue for 1st param

            Dim dte2value As New ParameterDiscreteValue
 

            dte1Value.Value = Request.QueryString("dte1")

            dte2value.Value = Request.QueryString("dte2")
 

            dte1Field.Name = "@dte1"

            dte2field.Name = "@dte2"
 

            dte1Field.ParameterValueType = ParameterValueKind.DateParameter

            dte2field.ParameterValueType = ParameterValueKind.DateParameter
 

            dte1Field.CurrentValues.Add(dte1Value)

            dte2field.CurrentValues.Add(dte2value)
 

            params.Add(dte1Field)

            params.Add(dte2field)

            'Dim params As New ParameterFields ' tHis requires only one object

            'Dim locField As New ParameterField ' ParameterField for 1st param

            'Dim locValue As New ParameterDiscreteValue 'ParameterDiscreteValue for 1st param
 

            'locValue.Value = Request.QueryString("Loc").ToString()

            'locField.Name = "@Loc"

            'locField.ParameterValueType = ParameterValueKind.StringParameter

            'locField.CurrentValues.Add(locValue)

            'params.Add(locField)
 

            Dim myreport As New ReportDocument

            myreport.Load(Server.MapPath("Reports\Type-10.rpt"))

            myreport.SetDatabaseLogon("XXXXX", "XXXXXX")

            CrystalReportViewer1.ParameterFieldInfo = params

            CrystalReportViewer1.ReportSource = myreport

            Session("StoreReport") = myreport

Open in new window

0
Comment
Question by:kurtrossr
3 Comments
 
LVL 7

Expert Comment

by:PCIRichard
ID: 24824620
Is the odbc datasource also set up on the server?
0
 

Author Comment

by:kurtrossr
ID: 24824887
yes. and tested successfully
.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24828967
You need to change the database location in the application since you are changing the connection.

I'll try to find an example.

mlmcc
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

In my previous two articles we discussed Binary Serialization (http://www.experts-exchange.com/A_4362.html) and XML Serialization (http://www.experts-exchange.com/A_4425.html). In this article we will try to know more about SOAP (Simple Object Acces…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now