asked on

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

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

ASKER CERTIFIED SOLUTION

Easwaran Paramasivam

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Grant Surridge

ASKER

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

samsymon

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.

Mike McCracken

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

Grant Surridge

ASKER

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