Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Avoid credentials prompt with combo params Post Reply Post New Topic
Author Message
mapon
Newbie
Newbie
Avatar

Joined: 23 Jun 2015
Location: Spain
Online Status: Offline
Posts: 3
Quote mapon Replybullet Topic: Avoid credentials prompt with combo params
    Posted: 25 Jun 2015 at 1:54am
Hello...
I'm doing a report in Crystal XI R2 Development version and I show it with visual basic6 . I have two parameters that must be required in the loading of report. One of them should be loaded via combo. If I write these 2 values the report load properly . But if I point to one of the parameters to be loaded dynamically in a combo from one of the fields of the command I use to generate the report, a prompt is shown requesting user and pass.
Connection credentials are assigned to all tables in the report in this way:

For Each crxTable In report.Database.Tables
    crxTable.ConnectionProperties.DeleteAll
    crxTable.ConnectionProperties.Add "DSN", "xxx" 'DSN
    crxTable.ConnectionProperties.Add "User ID", "xxx" 'UserID
    crxTable.ConnectionProperties.Add "Password", "xxx" 'Pswd
Next crxTable

Why if I apply the data to parameters in text mode Crystal does not request connection credentials but if the parameters are requested via combo those credentials are requested ?

How I can prevent connection credentials being requested ?
I searched a lot to all sides without results and urgently need these parameters are requested by combo without asking for connection credentials.
Thanks in advance


Edited by mapon - 25 Jun 2015 at 2:07am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.