Search results for query: *

Thanks for the replies - got sidetracked with another project. BoulderBum: Yes - it goes as JPEG into database as content type is specified as JPEG and there's validation that allows JPEGs only. NeilTrain: I will try saving as JPEG, but part I don't get is - I already specify content type...

Quick foreword: I inherited a web app that uploads images into SQL database for storage and displays them on a web page, at request. Problem is that when I right-click on loaded image, then "Save As", I have only BMP option and need to have whatever content type is, which is currently...

Hello, I have an events ASP page that displays events from database. To make it database independent, I'm exploring using XML file as storage instead of database. What I'm afraid is that there will be issues when several users perform add/edit/delete operations at the same time, so I'm not...

Thanks for the opinion Alex. Yes, for most applications I use stored procedures or command object. For this project however, user has requirements to pick a table name from drop-down and have all table's columns loaded. So, I don't really know table structure, and it might change as columns...

Hi. I need some advice as I got stuck a little. So, I have a windows form with a DataGridView that gets populated with table data for Add/Edit/Delete operations. Data generally is entered through another interface and checkboxes data on database side(SQL2K) are defined as bit (NOT NULL) type...

A little extra work in the beginning might save you hours of redesign later, when application matures. If both solutions above don't work for you, how about creating local HTML page and show it in a browser control.

As an alternative to Turkbear's suggestion, you could use an XML file as data source. That way all you have to do is to manually(or with an editor) edit your XML file to create/update user guide.

You could also use DateDiff ("d",CurrentDate,{Table.DateField}) LB, does Crystal default to days when you do it like in your example?

If you're using embedded reports, then your setup will install into application directory. You would use something like this (C# example): ReportsFolderPath = Application.StartupPath; // This is where your reports are The other alternative is to store path to reports in App.Config file...

LB, thank you so much for your help. It works. I actually used running total on {@A_Count} instead of {@A_Time} and reset it at group level. Only problem I have is that it comes back with 0 when group detail rows have all 1's, and I need to count that condition as one. I'll try to think of...

Thanks for the reply LB. I apologize if I confused you with a word "unique". I don't really want to count unique/distinct values, but when they change. Let me try to explain again. So, I have {@A_Time} formula that will output 1 for "Condition A" and 0 for everything else. In {@A_Count}...

Hi All. I'm doing something wrong as I get this error: "A Summary has been specified on a non-recurring field. Details: @A_Count" Formula @A_Count: if {@A_Time} > 0 and {usp_RPT_RW_CONDS_TIME;1.TIRE_CHAIN_RSTRCT_DESC}<> Previous({usp_RPT_RW_CONDS_TIME;1.TIRE_CHAIN_RSTRCT_DESC}) and...

Also, if you're using VB.NET, then you can store data in memory using DataSet, and tie that DataSet to report.

Hmm. If user will enter data into app, that it has to be stored somehow, either in a file based system or database before user will preview report. You can use text, csv or XML files to store data, if it doesn't require security. It all depends how much data is entered, data validation, have...

It probably uses old dlls even version 10 dlls are installed. Your developer needs to remove old ones. Check link below. Different version but similar issue...

I didn't find such option. I created reports in ver. XI and open them an app. developed in VS2005 and version in VS2005 is 10.2.36. I'm having issue when Crystal won't display parameters on a report when opened in windows app's crystal viewer. Any ideas? Thanks

Jason, Thanks for the reply. How do you set report's source parameter? I tried to set parameter for report object like below but still get an error. oRpt.SetParameterValue("@STARTDATE", StartDate) Interestingly enough, if I modify any working report that uses stored procedure, to use...

Hi All. I have a report developed in Crystal XI. It has stored procedure as data source, which takes two parameters (@StarDate and @EndDate). I use those data parameters in formulas and everything works great, when I run report in Crystal. I added report to VS2005 project and when I try to run...

Sorry about omitting version. It's a Crystal XI. When I created report and subreport, I selected stored procedures as data source. Crystal detected parameters in stored procedures and added them as crystal parameters and doesn't let me to delete/re-add them. I managed to create link between...

Is this a suppression condition as you don't have "if" statement? If it's a suppression, remove if-then. I can't test without data but try this: if {c_str_m_parm.emtek_id} = {?Pm-r_adt_core.emtek_id} and IsNull ({c_str_m_parm.changed_date}) and {c_str_m_parm.object_name} like...