hi all,
before i had a big database more than 90GB and it's growing very sharp so what i did is to create a summary database that gonna hold some aggregation and i create also three tables that gonna hold the data, on will hold the data for the last three months (very detailed information) one between 3 months and a year(less detailed) and the last one older than a year(less less detailed) these are the company requirement i'm working with.
then i transfer the data to the new tables with stored procedures.
now my question is: do i need to create a view for these three tables? and if yes how should i do it?!! cus i do not have the same columns in the three tables.
thanks experts.hi all,
i just posted another question .
titeled optimizing stored procedure
thanks
Showing posts with label hold. Show all posts
Showing posts with label hold. Show all posts
Friday, March 23, 2012
Friday, March 9, 2012
Parameters in Page Header
I am trying to put my parameters in my page header.It do works fine.I am using a textbox to hold the value of my parameters.I use
= Join(Parameters!resourceParams.Label, ", ")
in my textbox expression.But my problem is,when there are too many values specified(because i am using a dropdown with multi select) the page header,overlaps the body of my report. The page header's text overlap the contents of my report body.What could be the reason or work around for this? Thanks guys
Make your text box the maximum height and width you want it to have and than select can grow = false..
If you keep the text left align.. No one will know that its very big.
Subscribe to:
Posts (Atom)