Recent content by jj22171

I want to query the suppliers table for vendors added to changed on a certain date. PL010200 seems to be the table but cannot find the field for the date added/changed. Can anyone help? Thanks a lot.

Is it possible in to have two different chart types for two different series group in Reporting Services 2008 (or Report Builder 3.0). For example, in one chart Budget figures are represented by a line graph while Actuals are in bar graph. Thanks

I'm working on a financial report with current period, year-to-date columns and comparative columns for same period and year-to-date from prior year. Datasource is a cube but unfortunately, it doesn't have the PriorYear_Period and PriorYear_YearToDate as measures. Cube has FiscalYear dimension...

We have our databases on SQL 2008 Express which we want to move to a different machine with SQL 2008 Standard. The databases are relatively small. After doing the necessary configuration, how much work is needed recreate the databases? Is it possible to restore Express backup into the Standard...

My SSIS package imports data from a text file. The Data Flow works fine until reaching a certain row and it gives out error message "[Flat File Source [1]] Error: An error occurred while processing file "myFile.txt" on data row 663207." Upon checking, data row 663207 is a blank row but not the...

I'm using Cisco VPN client version 5.0.03.0560 in my laptop with Windows Vista. When trying to connect, this error message show up when trying to log-in "Failed to enable Virtual Adapter". The surprising thing is one time it works, the next time, it doesn't. The last time it didn't, I just...

Thanks, Denny. My first attempt was not successful as it gave me more records than expected. Then I realized one of the source tables has lots of blank/null values in one of the key fields. Once they were filtered-out, Merge Task worked like a charm. Thank you very much.

I'm trying to write an SSIS package with 3 important tasks. Task 1 queries from a couple of joined tables. Task 2 queries from another couple of joined tables. Task 3 joins results from Task 1 and Task 2 and write the results into a staging table. My option at the moment is to use view for each...

My spreadsheet has hyperlink that points to say, cell A50. When selected, it goes to A50 but at the bottom of the screen. How can I make it display as the first cell on the top right of the screen? Thanks for the help.

I have one main report with 3 subreports using the same recordsource (say, qry_Source). Each time a subreport is opened, the recordsource is re-queried. Question: Is there a way to requery the recordsource only once instead of 3 times? Thanks a lot. jj

Thanks PHV for your help and the quick response. jj

I copied an mdb from another computer. Its queries has the WITH OWNERACCESS OPTION. Now when I created a new mdb in my computer, the new queries have the same option as default. Is there a way to disable this option? What is its implication if I distibute my mdb's to other users? Thanks. jj

Thanks, linmey. I've browsed through most of those threads and other related topics and had the impression that iexpress is easy to use based some people's comments. I thought maybe there's something missing after following the step by step procedures in one of the sites.

I have a VBScript (MySetup.vbs) that creates folders (C:\Documents and Settings\#UserName#\All Users\MyCopyFolder) and copies files (icon, shortcuts, mdb) from a shared network drive and to user's folders. It works fine. Now I want to create a self-extracting file using iexpress. I included a...

Not sure if it's the best solution but it looks like it's working. I created a temporary table with a single hyperlink field and bound to it a textbox in my form. Now I can drag and drop my saved email to the textbox and use it to populate my records. Hope others may find this useful.