[RESOLVED] VS2005 & Crystal Reports 11

[mickey_pt]

Hello

I need help to change the select commnad for the report...

I have an sqlserver database and with the help of the wizard i managed to create the report for one table ( the one that i need info), i created the report without any type of parameter (something like SELECT * FROM table)...

My problem's that i have in the table a bit column, what i want to do if it's possible, is when the user click a button, get prompted to show every record, the ones that the bit's 1 (true), or bit's 0...

It's possible to do this at runtime? and how?

Thks

[mickey_pt]

Seems like no one knows...

[mickey_pt]

I managed to do this by using the recordselecctionformula...

But now i have another problem, before showing the report i get prompted for the login to sql server database...

My connection string is set at runtime, if i use the windows authentication everything works fine, but if i use the sql server authentication i get prompted, and in the sql server login window i only have to ucheck "use integrated security" and click in finish... then sometimes i get a msgbox that says logon failed. others this msgbox doesn't shows up. But in any case if i press the refresh button of the crystal report viewer i see the report...

Thks