Solved

Crystal Reports in ASP.net - add parameter, wants username and password

Posted on 2011-09-12
5
458 Views
Last Modified: 2012-05-12
Hi

I have setup access to Crystal Reports on the web via asp.net, and all seems to work fine

However, as soon as I add a parameter (code below), it asks for a username and password, which is driving me mad!

 
<Report FileName="InvoiceSummary.rpt">
				<parameters>
					<CR:ControlParameter ControlID="HiddenField" ConvertEmptyStringToNull="False" 
						DefaultValue="" Name="InternalInvoiceNum" PropertyName="Value" ReportName=""></CR:ControlParameter>
				</parameters>            
            </Report>

Open in new window


Why does adding a parameter mean needing to enter a username and password ? I have set it as integrated security in IIS but still no joy

Please help!

Thanks
0
Comment
Question by:seancurt
5 Comments
 
LVL 16

Accepted Solution

by:
Easwaran Paramasivam earned 500 total points
Comment Utility
0
 

Author Comment

by:seancurt
Comment Utility
Hi

Thanks for that, but doesn't work for me. I now get "Database Logon Failed"

If I run it in Visual Studio on my machine, it works fine. If I put it remotely through IIS, it asks for the info or fails like the above.

I see that there is extra coding in the code behind, however I don't have one. All I have is below

<CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" 
        AutoDataBind="True" GroupTreeImagesFolderUrl="" Height="1269px" 
        ReportSourceID="CrystalReportSource" ToolbarImagesFolderUrl="" 
        ToolPanelWidth="200px" Width="1082px"  ></CR:CrystalReportViewer>

    <CR:CrystalReportSource ID="CrystalReportSource" runat="server" >
        <Report FileName="InvoiceSummary.rpt">
            <parameters>
                <CR:Parameter Name="UserName" DefaultValue = "globe" />
                <CR:ControlParameter ControlID="HiddenField" ConvertEmptyStringToNull="False" 
                DefaultValue="" Name="InternalInvoiceNum" PropertyName="Value" ReportName=""></CR:ControlParameter>
            </parameters>
        </Report>
    </CR:CrystalReportSource>

Open in new window



As it works locally, but not remotely it seems that it is permissions related. But I have tried anonymous access (using admin logon), integrated (i am an admin) and both, but still no good
0
 
LVL 3

Expert Comment

by:samsymon
Comment Utility
I think it is not because of the parameter,but how you access the data from the data base.
Which method you used to display the report Push or Pull method.

Are you doing any sub report.
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Where does the report pull its parameter from?

Is the report saved with data?

If you run without using the parameter are you prompted for a value?

Did you give EVERYONE permissions to the database?

Generally Crystal run from a server is run under a system login in not the user running the report.

mlmcc
0
 

Author Closing Comment

by:seancurt
Comment Utility
Hi

The first solution was ok, i just had understand it !

I created an empty viewer. Then take their code and so the report and params is loaded in in the codebehind

Thanks for your help
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

744 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

15 Experts available now in Live!

Get 1:1 Help Now