Recent content by ClevelandSteve

I'm building a crosstab query in a Access 2007 database. One of the fields in the result set is titled <> and the entire column does not contain any values. Where is this field coming from? It's not part of my data anywhere.

Thanks for your input MDX. I agree with your statement and was considering that type of solution in my first post. My hesitation is that I would need to create views with all the fact tables of some sort so my users can perform cross customer analysis. Once I aggregate the low grains in my...

That’s actually how I have it set up now. I’ve always viewed that solution as shoehorning the data into a model that doesn’t quite fit. The problem with it is if the analyst doesn’t filter out the customers who send their data aggregated at the higher grain, they see large spikes on the dates...

Thanks, I wonder why that forum didn’t come up in my search.

I have a data warehouse that stores sales data sent to us by our customers. Managing the time/date dimension has become a challenge and I'm looking for some advice. Some customers will send daily sales, most send sales by week, and two send sales by month. How do I store these different...

I apologize if this is not the correct forum. It seemed to be the closest match I could find. I have a data warehouse that stores sales data sent to us by our customers. Managing the time/date dimension has become a challenge and I’m looking for some advice. Some customers will send daily...

I found the problem for anyone who may find this thread during a search in the future. End users would see the "The ConnectionString property has not been initialized" error on their screen, but checking the appliction log on the web server reveled the true soruce of the problem.

I gave it a try but got the same error at cmd2.

Yes, I agree. It originally had one connection, but in my loss for a solution I created a second one thinking maybe the second command was trying to use the connection before the first one was done with it.

I have ASP.net 2.0 application that needs to perform two tasks on an Oracle 10g database. Occasionally, the second task (cn2 in the code) will fail and return a “The ConnectionString property has not been initialized” error. This code has been through many revisions and I cannot figure out...

Try saving the Access report as a .rtf (rich text file). Word will be able to open it and it will look nearly identical to the Access report.

I have found a solution for the original post. For anyone who does a search and reads this thread in the future, the answer can be found here: http://www.tek-tips.com/viewthread.cfm?qid=1428276&page=1

Huh, visual studio will raise an “‘onsroll’ is not a valid attribute” warning but if I just ignore it and run the page anyway everything works fine. Odd. I do like your idea better of calling the javascript on the click event. It keeps the scroll from lagging. Thanks for the idea.

I posted this in the ASP.Net forum but it was suggested I post the question here, so here goes. In ASP.Net 2.0 I have a gridview inside of a panel control. The panel has ScrollBars="Auto" so when the height of the gridview exceeds the height of the screen it becomes scrollable. The problem I...

You think? I thought this thread would be more appropriate since the problem is not in the java script. I’ll give it a try though. Yes I tried the Page.MaintainScrollPositionOnPostBack property, but that only works at the page level. Since this is a scroll within a DIV it does not work.