Hi,
I have data that looks like:
ticket code
12345 a
12345 b
12345 c
45567 a
45567 b
How do I write a query to make it look like
ticket codes
12345 a,b,c
45567 a,b
thanks!
Hi,
It had been about 8 years since I have developed i Access. Rather rusty!
Could someone assist in showing me how I could pull run a saved import using a command button in a form?
Using Access 2007 and Excel 2007. thanks,
Hi,
I am using CR10 and SQL 2005. I have a cross tab with:
Rows: {@category}
[which is a formula resulting in a 3 range series (1-5, 6-10, 11 or more)]
Cols: Table.costctr
[Field which contains a cost center number]
Summarized Fields: Sum of @count and
Sum of Table.Spend
[where {@count}...
Hi,
I am running CR10 in SQL 2000. I have a Main report with 9 (yes 9) small linked subreports, a report dashboard of sorts ,all but one of the reports is limited to a "top 5" so only one expands in size/varies in size. I have a problem when running the report for a year, that one silly...
The only thing I have ever been limited by is the print driver. If the report is too wide or too long, it will fail. Are you scheduling these on different PC's? May be the difference, otherwise, I am not aware of a limitation.
Hi, I am using CR10 Developer in a SQL environment. I have a bar chart showing a dollar amount for Y Axis and a group name for X axis.
My problem...the report only shows 5 of the 7 groups even when each group has data to show..as each does...
I am hoping this is a default I can change...
Hi,
I am running SQL 2000, CR10 in a C#.Net web app;
I have a problem where certain users, once they have logged in to the web application can run several reports fine, but when they click on one specific report they use the most (10 to 1) it does not open to the parameter page at all...
Hi,
I am running CR10 with SQL 2000 accessed using an ASP.net and C#.net web application.
There are several folders of CR reports to which users of the application are "assigned" these reports are what the users "see" when logged into the online app.
I have had people with access to the...
I finally used vnc and had the user walk me through what they were doing step by step. On the phone they had insisted they were follwing proper naming conventions, expot procedure, etc. The user was adding a "." to the file name! Sometimes, the answer is an old easy problem..sorry and thanks,
I am running CR10 in a SQL 2000 enviroment. I have a C#.net web app that displays a list of the reports, allows the user to enter parameters, passes them to CR10 and SQL and displays the report onscreen. Usually, the user can export to Excel or Word or several other standard types.
The...
Hello,
Forgive me if this has been asked before, but,
Running CR10 and MS SQL 2000.
Is it possible to have a parameter for input on a grouping by Top N - Top 10, Top 20, Top 50, etc and basically, have the report display the Top N based on a selection/input by user?
Let me know if I need to...
Hi,
I can only link on client code because the Charge table is fed by a file sent to me over which I have no control.
What I need is a report with the Charge records and any possibly related Sale records from my accounting data..the only thing that lets me know if they are possibly related is...
I was hoping that simply returning a True or False might work, allow me to explain in more detail, maybe you could advise of a better approach.
I have two tables, Charge and Sale, that I can only link on a client code.
Charge.TrxDate is the date the charge was posted by a credit company...
Hi,
Could someone please advise how to write a formula to select dates from one date field (DateA) based on that date being within the max/min range of dates in another date field (DateB)?
This needs to be done without input from an end user. Using CR9 and SQL 2000.
Thanks!
I changed "SET SurveyDate to dbo.CheckSurveyed.SurveyDate" to "SET SurveyDate = dbo.CheckSurveyed.SurveyDate"
After I got an error ....ner "to"
Also, I am getting "Incorrect syntax near '6'"
Any ideas? Many thanks!!
HI, I really do!
I need to link two tables dbo.Survey and dbo.CheckSurveyed on dbo.Survey.Full_Name to dbo.CheckSurveyed.Pass_Name
Then I need to:
update dbo.Survey.SurveyDate to dbo.CheckSurveyed.SurveyDate
Where dbo.CheckSurveyed.SurveyDate is (Greater than 6 Months prior to)...
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.