Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mjjks
  • Order by date
  1. mjjks

    Displaying image from database issue. Need JPEG, comes as BMP

    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...
  2. mjjks

    Displaying image from database issue. Need JPEG, comes as BMP

    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...
  3. mjjks

    Using XML file concurrently

    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...
  4. mjjks

    Problem with checkboxes in DataGridView

    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...
  5. mjjks

    Problem with checkboxes in DataGridView

    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...
  6. mjjks

    Dataless report

    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.
  7. mjjks

    Dataless report

    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.
  8. mjjks

    Special Fields

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

    Crystal Reports & Visual Studio 2005 Pro

    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...
  10. mjjks

    Summary on non-recurring field question

    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...
  11. mjjks

    Summary on non-recurring field question

    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}...
  12. mjjks

    Summary on non-recurring field question

    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...
  13. mjjks

    Report straight from VB Form

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

    Report straight from VB Form

    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...
  15. mjjks

    Crystal Reports 10.0 and Visual Basic 6.0 Report HELP!

    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...
  16. mjjks

    Can Crystal (XI) save as previous version?

    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
  17. mjjks

    Crystal parameter in formula fails in VS2005. Help

    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...
  18. mjjks

    Crystal parameter in formula fails in VS2005. Help

    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...
  19. mjjks

    Linking Report &amp; SubReport

    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...
  20. mjjks

    Oldest Record

    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...

Part and Inventory Search

Back
Top