I have created a report with multiple data fields, no category fields or series fields. THe data fields are sums and distinct counts. I would like the y axis titles to be the names form the data fields. I am using SQL 2008 as a backend and BIDS to do the report. If i was in Crystal doing this...
that is awesome, make sense. If i made another column tbl_financePeriods.dtm_financePeriodEnd
it should work if i do this?
Select tbl_financePeriods.dtm_FinancePeriod,
Sum(tbl_hrs.int_hrs) As TotalHours
From tbl_hrs
Inner Join tbl_financePeriods
On...
I am using SQL 2008 and am new to it. I want to group a table tbl_hrs which has two fields:
dtm_tcdate and int_hrs
However i want to group by financial periods (13 per yr). I was thinking the easiest long term solution would be to create another table: tbl_fincanceperiods that held these dates...
I have built an Access 2010 database with the data in a SQL Server (2008) called WH. It will be used for a project that is phased in over time. There is a main form (frm_Check_Incidents) that pulls in data from another SQL server (Brown) with a list of incidents. The users are going to phase...
Access did all the alias work for me. I made sure the alias's were the same as in the relationship window. I did join by the right field.
I am using linked tables? What is a linked view, sorry for my ignorance but what/how?
I have a report i am creating useing Access 2010 and my data is on a SQL 2008 R2 backend. The main table for the report tbl_CB_or_CA has multiple lookups in it, they are:
CB_or_CA_Method_ID
CB_or_CA_Source_ID
CB_or_CA_Target_ID
These are the IDs that link to the field LookupID in another table...
Thanks MazeWorX
So in my case I would put Forms![MyForm]![CB_or_CA_Method_Combo]
Do i need a (0) here so the calculated field can pull the right value from the combo (like "phone","email") not the IDs (like 1-4)?
I have a subform where the last field is a concatenated combination of all the fields so the user can copy all of it to paste it into another db (only possible solution). I am using Access 2010, the data is on a SQL 2008 back end. I have been able to concatenate the fields except the combos...
Thanks. i may have neglected to mention the report needs to be self sufficient, I don't want to have to import it into access every night manually. If the report will need to use an odbc connection doesn't the CMS of Crystal Enterprise need the same ODBC connection as i need the report to run in...
I am using Crystal Reports 2008, and i have a report that i need export its results and then pull those results into another report. Normally i would just use a subreport but i have so much data that i need to export the results and pull them in so its not too slow. I will be using crystal...
I see that Ken Hamady replied to a similar post i did with the answer:
To do this in XI you would need to use a SQL Command that returned two columns like this:
Facility / Facility A
Facility / Facility B
Department / Department A
Department / Department B
Then you only need two parameters, the...
Would it still be okay if each column lined up so for example the Vehicle names were in the column, and then Depot Name, Client NameX etc? if so can't you use a table to do this?
It may be your margins, i would try shrinking the vertical size too much and see if it all stays on one page. If it does then you know you just need to tweak the height.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.