Recent content by Parkaboy

Thanks for the replys. Yes I was coding it correct, and all of the suggested solutions were helpful and led me to the real issue: I could only succesfully pass the date if I did so under Group Selection Formula. If I try to pass the same selection formula for records, the report does not...

Creatd report based on date of an action. Having trouble passing date to record selection (literal date) so I created a formula: (will be adding parameters at a later date) Shared datetimeVar dt :={Action.EnteredDate}; If dt = #2011-02-01# then 'T' else 'F' If the date is within...

Will do. Joins are not working, so I'll try adding the second lookup table. Manually created labels to get the project done this morning.... Thanks for your response, hopefully this method will work.

In the most basic form, I'm trying to add two separate validation sets (the English label related to the actual numeric value) to the same detail line in my report. I can add the first reference to a valset no problem (regardless of which one) but when I try to add a second set from the VSE...

Thx for the replies. Using very similar code to yours in vb.net Syntax is correct, loops thru all tables, then fails to logon. No problem until I try to send to printer, then Returns an unhandled exception: "Unable to connect: incorrect log on parameters." server, UID, and PWD are correct...

Have been trying to find a working solution to the problem of changing SID at runtime. Like many users we have a TEST and PROD environment. Currently running separate test and prod version of reports in lieu of the ability to change SID at runtime. Have scoured the forum and web with no...

Good point. that must be why some reports were OK with the table changes, and others weren't. I'll review all the reports for the setting and hopefully this will work from this point on. Side note: while the updating the table is covered under the verify DB command, I have found verify...

Hello All: I have written an app in VB.NET 2005 that calls 60 crystal reports, refreshes them, sends the needed number of copies to the printer, and exports a single copy to PDF format. The problem is a random number of reports refuse to be called by the .NET program. We can manually...

Hello All: I am calling CR XI reports from Visual Studio 2005 and I have run into a problem regarding verifying the database. The report will hang up and refuse refresh due to a change in the data table. I know this can be done manually thru CR, but want to verify with code. I am using the...

No go on formatting the datetimepicker. regardless of the format I try to pass ( need #2007-2-13#) I end up with #2/13/2007#. Can I even pass the correct format with a DTP, or maybe I need to have the user enter the date in a textbox....... The stringvalue dates I am passing work great...

Thanks for the reply. I'll try it out and get back to you.

Morning All: I have written an application with VB.Net that successfully prompts and passes STRINGFIELD parameter values through VB to Crystal Reports. Everything is working great, until I try to pass a Datafield value. None of the formats I tried to pass appear to provide the correct format...

Created a program to find, refresh, and printout crystal reports. Works great on reports WITHOUT parameters. Problem arises when I try to access a report with parameters field I receive the error at the bottom, using the code below. code used: Dim Par As...

Thanks for the confirmation on the viewer. My app does not need to display anything, just process and print. Thanks again for the reply.

I am trying to address parameters in my VB.Net app and need to know if the CR Report Viewer is necessary? I am currently printing and exporting using the ReportDocument with success and want to address parameters from the RD as well. I have noticed most of the examples in Tek-Tips (excellent...